Display field name for each record in crystal record?

Question

For example:

select * from emp


Default Result will be like This in Crystal Reports

No Name
1 nnn
2 mmm
3 ppp

I want like the crystal report display as follows

No Name
1 nnn
No Name
2 mmm
No Name
3 ppp

Answer 1

The following should be performed in the Design tab of your Crystal Report:

1) If you don't want the field names (column headings) to be displayed at the top of each page, then suppress the page header section that is currently printing these column headings. (Right mouse click on the name of the Page Header section, then select Suppress)

2) If you want to add field names (column headings) above each row of data so that the field names are displayed everytime a new row of data is displayed, then do the following:
2a) insert a new Detail section below the existing Detail section (Right mouse click on the name of the Detail section, then select Insert Section Below)
2b) copy the field name text fields from the suppressed Page Header section to this new Detail section (For each field name text field that you wish to copy, left mouse click on text field in the Page Header section and then click CTRL-C to copy and then click CTRL-V to paste and then left mouse click in the new Detail B section that you just created. This will create a new copy of the text field in the Details B section.)
2c) reorder the two Detail sections so that the new Detail section containing the column headings is printed before the old Detail section containing the data (Left mouse click on Details B and then drag and drop it above Details A)

Basically all you are doing with these steps is suppressing the page header text that you don't want to see and then creating a new Detail section that repeatedly displays the column heading text just above each row of data.