Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have built an excel report that is using paging to create a new sheet for each "Customer" and levels to create a table with subtotals for each "level".
When I run the report from NPrinting (in the template editor) it displays perfectly as expected.
When I run the report using on demand it creates all the levels for each table regardless of the paging filter applied.
I have searched for an answer but have found nothing. It seems the selected on demand App filters have no effect on the leveling applied to the excel report.
Thanks
Thanks Ruggero
I figured out the issue, I was using set analysis on the table measure to filter the data in the table. Once I removed the set analysis and used actual selections in the App the results come out as expected.
Hi,
Be sure you are applying filters to the same app used as the source of the report.
For debugging purposes, you can add a Formula in the template with =GetCurrentSelections() so you will see the list of applied filters.
Best Regards,
Ruggero
Thanks Ruggero
I figured out the issue, I was using set analysis on the table measure to filter the data in the table. Once I removed the set analysis and used actual selections in the App the results come out as expected.