HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
Answers were Sorted based on User's Feedback
Answer / gouda
for drill through, we have to select the source report(summary) and target report(detail report)but both report contains a one same column or reference column .
right click on source report ,drill through option you can c and click and select target report by giving the new link, with the same column name
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pradeep nambiar
1. Open the target report in Query Studio.
2. Confirm that the report is available for drill-through
access:
● From the menu, select Run Report, Advanced Options.
● Select Enable drill through from a package in the report
output and then click OK.
3. Create a filter that will serve as the drill-through
parameter, or that will be used to filter the
report.
● Select the column that you want to filter on, and click
the filter button.
● Change the settings as needed, and click OK.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vik
for eg:-
create a detailed repots,apply filter on that like
([ordermonth=a] save that
then create one detailed report
create new promt page
in that drag anew value prompt
follw instrction
then right click on data item click on drill through
Is This Answer Correct ? | 1 Yes | 4 No |
Answer / siva
we develope the drillthrough reports in ssrs by right click
on report then one wizard will open.in that go
to 'navigation'.then click on goto url...goto
report....this way u can develope drillthrough report.
Is This Answer Correct ? | 0 Yes | 12 No |
What are the components of the report studio?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is difference between content store and content manager?
diff b/w layout calculation and query calculation
what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??
What are initial page components of Cognos connection?
How can create users and permissions in cognos?
Can you define slice?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
What is defined as Query studio?
What is Normalization?
how to hide a particular pages at time if you get blank pages