The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
3 years ago

RowExpansionMode - Report Viewer

Hello,  Is there a way to apply the RowExpansionMode (e.g. - Collapse All) setting when a user select's "Show report"? The Report Viewer appears to default and expands all.  Ideally, I would like...
Cube View
Reports
Maja's avatar
Maja
New Contributor II
3 years ago

Hi Sean,

I am not sure I fully understand your question, can try using a parameter that prompts the user when running the report.

 

 

You can also create  delimited list parameters that drive the suppress format. You would have two rows in the report, one that expands to more detail and one that doesn't.

I hope this helps.

Maja

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
3 years ago

Thanks Maja.  When I run the report with Row Expansion Mode set to Collapse all, it generates in the data explorer as expected.  However, when I try and view the report as a PDF via the report viewer, it ignores the collapse all and generates the entire tree (expanded).  I suppose your later parameter suggestion would alleviate that by hiding the row, but didn't know if there was a way to specify the row expansion mode in the PDF/Report Setting.

  • Maja's avatar
    Maja
    New Contributor II
    3 years ago

    Hello Sean,

    When you think about it the reason why it expands in PDF is because you don't have an option to expand on the screen like you can in excel and DER. So the functionality makes sense.