reporting services - SSRS Collapsed (hidden) rows still show up when exporting -
i writing ssrs 2005 study in bids 2008 has recursive grouping , visibility toggle. initial toggle state false, detail rows hidden. when view study in preview window, shows correctly, similar below.
+group 1 +group 2 +group 3 however, when switch print layout or export report, first grouping show expanded below.
group 1 detail 1 detail 2 grouping 2 grouping 3 so far i've tried using different set of info in case caching results , expand/collapse status. i've tried deleting , recreating group. i've tried creating exclusively new study project , recreating everything. no avail.
has encountered before , been able prepare it?
edit:
i set study aside few days , came morning. started new study , rebuilt it, changing few values each time , checking see if issue popped up. found first grouping not expanded when exporting until add together header/footer report. do, export starts expand group.
further, header/footer causes issue when 1 of them has expression, parameter, or built-in field (execution time, example). if header , footer made of static values (i.e. "report title"), works fine.
for example, added header single textbox. in textbox, typed in "report name". when tested it, issue did not occur , groups remained collapsed. went , changed value of textbox '="report name"'. time issue did occur , first grouping expanded automatically.
so, question why using dynamic info in header/footer cause print layout view/export expand first grouping , of sub-groups?
reporting-services reportingservices-2005 ssrs-grouping
No comments:
Post a Comment