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 |
whats the difference between previous version of cognos and cognos 8 BI?
wt is scope relationship?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What are the differences between Cognos 8 and Cognos 7.x version?
What is Online View?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
Can you define confirmed dimension?
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
What is the difference between set functions and filter function in dimensional data?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
Which one is better among Value and select & search prompts,in terms of performance?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?