Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Oct 20, 2016 at 10:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2016 at 02:04 PM

    Hi Abhilash,

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

    --GS

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2016 at 02:23 PM

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

    Do you have an example please?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2016 at 05:12 PM

    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

    Add comment
    10|10000 characters needed characters exceeded