Missing report headers when exporting to XLS Data Only

[Former Member]

Hello all,

I searched for this topic and was unable to find a similar one!

I have a report that's very long.. (Page Setup:User Defined)

When I export to Excel Data Only, with option of: Custom: Data is exported according to selected options, the output shows some headers only and skips many.

I tried going into Design view and putting grids around each feild so that they don't overlap.

How can I fix this issue?

Thanks,

[Former Member · Accepted solution]

Under Options: Simplify Page Headers was causing this issue.

Does anyone know how to save these options? It seems like everytime I try to export, they're defaulted to previous standard values...

For now the issue is fixed.

[Former Member · Accepted solution]

Go to FILE->Export->Report Export Options then select Excel Data Only option from the Format drop down window then press ok.

Check page headers and footer check box and press ok.

This should set the options to export report header and footers.

Hope this helps!

Achett13

[Former Member]

I had this issue once, and i found there is a blank space in the header, after i use "fit the section", the title is in the excel file