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 |
Can you define cube?
What is difference between content store and content manager?
how to create cubes in transformer ?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
What are the components of the report studio?
hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....
What is Local Cache and how does it help in performance tuning
what is the use of layout calculation?
Define dimensions?
What is model?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what is meant by roll up and roll back in dataware housing????
4 Answers Covansys, IBM, Wipro,