Drill down on reports on reportserver with BIRT

ReportServer (EN)
1

I am new to the report server and I want to do an analysis of the reports.

I can drill down into Birt in eclipse from Report A to Report B. But when I upload my reports to Reportserver I can not drill down from one report to another.

I have read that documentation, but I do not understand it.

Https://reportserver.net/en/guides/admin/chapters/Drill-Down-Reports/

I want to pass some parameters from report A to report B (date, product ID, category) not just a parameter.

At BIRT, I followed these steps from Drill to Details (http://www.eclipse.org/birt/demos/)

Many thanks in advance
Adasan

2

I still have not found a solution.

Can anybody help me?

Thanks.
Adasan

3

Hi Adasan,
to define drill down or drill across reports is manual work.

  • First you need the reports you want to connect. Of course the drill in the development environment might work, but not immediately in ReportServer.
  • Then check

https://reportserver.net/en/guides/admin/chapters/Executing-Reports-via-the-URL/, because that gives you an idea of how to pass the parameters needed.

  • Define an Object of Report A as the starting points for the Drill Down in Report A by assigning the link to Report B (see Step 2 for the link). To include the Backlink check

https://reportserver.net/en/guides/admin/chapters/Drill-Down-Reports/.

Consider a Matrix of locations and Years, filled with turnovers , every turnover could be starting point for the drill. The parameters to provide for the jump from a given turnover of location_i and year_j (namely location_i and year_j) to Report B need to be derived manually in Report A. With these Parameters you assemble the link according to the two hints above.

Do not forget to include the backlink Parameter as an extra parameter, see second hint.

Hope this helps

Eduardo