How do split one record in two lines in report

[konda1234]

Hi,

I want a report and one record should display in two lines.
If I export that report to Excel I need that one record in 2 lines.
I desinged the report to show one record in two lines but if I export that report to
excel the entire record showing only one line. The excel file is not showing like report.
Even if report shows one record in 2 lines the excel file is showing in one line only.
How can I export the file such that one record should be in 2 lines.

Ex:

I have query like

select * from temp;

report is some thig like this.

123 Mark John Testt TestTest - first line
456 xxx yyyy zzzzz - second line

In the above report one record is in 2 lines.
If export that report to excel then excel file is not showing the record in 2 lines. The excel is showing all fields in one row only . i.e

123 Mark John Testt TestTest
456 xxx yyyy zzzzz

The excel format looks like that.
I want excel file like this:

123 Mark John Testt TestTest -- first line
456 xxx yyyy zzzzz -- second line


Please can any help help me how can my excel file will show one record in 2 lines if i export the report.

Thanks in advance.

 

[konda1234]

Hi,

Can any help me please.....

 

[TomCologne]

You could add Group Headers, one for the first line and one for the second.
Place the report controls in the headers instead of the Detail section.
Exporting the report to Excel will then show each record in two rows.
However, the sheet will look like

1.Line: A1,B1,C1,D1,E1
2.Line: F2,G2,H2,I2,J2

TomCologne