How to display the subreport headers from the Main report to Excel

[Former Member]

Hi All,

Currently I am facing an issue of displaying all sub report headers while exporting all data to Excel.

I need to have incremental header value (say 1 to 25) in page header of Main Report.Hence I created a subreport with a query and converted those rows to columns and placed that subreport values in Main report.

However I am not getting the subreport value which is placed in Page Header of Main Report while exporting the report to CSV File.

Desired O/p should be:

Member_Id Member Name 1 2 3 4 5

The values from 1 to 5 should not be manually placed as text as it should be incremented in page header of report.

Could you please suggest me any solution for this

[Former Member]

yea, i do have

Fields should display in in the page header as date1,date 2........date n. as dynamically

I do not want to manually do it as entering in to text box there.

--GS

[abhilash_kumar]

I'm not sure what you mean by displaying fields in Page Header.

Do you have an example please?

-Abhilash

[Former Member]

Hi Abhilash,

Do you have any other way that could display the fields in page header increased from (eg 1-25) dynamically?

--GS

[abhilash_kumar]

Hi Ginu,

Subreports are not exported to CSV. This is 'by design'.

You'd need to export to Excel and then convert to CSV.

-Abhilash