ReportServer Forum

richardlrz

Member

Registered: 2020-12-20

sub report

Hello Merry Xmas and Happy New years!

I am good for MS SQL server SSRS but new bee for ReportServer, I wonder if ReportServer can offer same function as SSRS does, I would like to have a report which allow user browse reom web browser, and allow user select one record and click navigate to sub report by taking that record 's information as a parameter. for example, I have a 4 group team report and once I select 1 group, I am able to call another sub report which will show all of the members in that select group? any idea will be great appreciate.

Richard

eduardo

Administrator

Registered: 2016-11-01

Website

Re: sub report

Hi Richard,

for BIRT / Jasper, this can be done with drill-down functionality: https://reportserver.net/en/guides/admi … n-Reports/

For dynamic lists, pls take a look here: https://reportserver.net/en/guides/admi … amic-List/
6.2.6. Linking Dynamic Lists to URLs
you can link to the subreport, as all reports in ReportServer can be called via URL, passing needed parameters in URL: https://reportserver.net/en/guides/admi … a-the-URL/

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: sub report

Hi Richard,

additionally, you can drill with pivot / Mondrian reports:
https://reportserver.net/en/guides/user … ysis-View/

8.6. Drill

Regards,
Eduardo