Sunday, 15 March 2015

reporting services - SSRS Collapsed (hidden) rows still show up when exporting -



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