You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Download grid as Excel ad-hoc when data rows/columns are hidden

Summary:

When downloading grid as Excel-adhoc in Narrative reporting, it gives an error if all data rows/columns in the grid are hidden. This was not an issue in FR before

Detail:

Report in FR:

Opens in HTML and select Export In Query-Ready Mode

Downloads the file as expected:

Opens the ad-hoc grid with no issue:

We migrated the same report to Narrative Reporting:

Opens in HTML and try to download the same grid above using Download as Excel ad-hoc:

Below error message pops up:

This is due to the fact that the data columns are hidden as they need to be grouped and calculated to produce the final desired number using formulas.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!