SSRS 2008
8 views
Skip to first unread message
munnyAnu
May 1, 2012, 1:36:39 PM5/1/12
to Microsoft Reporting Services
Hi All,
I have a report with nested sub reports and these sub reports are
toggled by parent report items.
for Example:
Country List --- (Main Report)
State list --- (sub report of Country list report)
--- report results based on country key input...
County list --- (sub report of State list) --- report
results based on state key input...
when I run the report showing all countries list first (1st level
only)
--- - then when I expand each country showing states (2nd level)
-- then when I expand each state showing counties (3rd level)
This hierarchy is working well in SSRS. but when I export to excel, I
can't see this hierarchy (expand/collapse signs). Instead excel
report
showing all records.
I am not sure why this hierarchy is not showing in excel. Any help is
appreciated.
Thanks,
Munny.
I have a report with nested sub reports and these sub reports are
toggled by parent report items.
for Example:
Country List --- (Main Report)
State list --- (sub report of Country list report)
--- report results based on country key input...
County list --- (sub report of State list) --- report
results based on state key input...
when I run the report showing all countries list first (1st level
only)
--- - then when I expand each country showing states (2nd level)
-- then when I expand each state showing counties (3rd level)
This hierarchy is working well in SSRS. but when I export to excel, I
can't see this hierarchy (expand/collapse signs). Instead excel
report
showing all records.
I am not sure why this hierarchy is not showing in excel. Any help is
appreciated.
Thanks,
Munny.
munnyAnu
May 1, 2012, 1:36:39 PM5/1/12
to Microsoft Reporting Services
Reply all
Reply to author
Forward
0 new messages