Skip to Content
0

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

Oct 20, 2016 at 08:34 AM

37

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Abhilash Kumar
Oct 20, 2016 at 10:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 20, 2016 at 02:04 PM
0

Hi Abhilash,

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

--GS

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Oct 20, 2016 at 02:23 PM
0

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

Do you have an example please?

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 21, 2016 at 05:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded