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 |
pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com
What is the use of report studio?
what is filter?give me one example that you created a report in your project?
How can we convert imr report into Impromptu web report?
How to select all in value prompt instead of cascade prompt?
How can i approach to write Congnos Certification? What exactly should i do? Can anyone guide me plz?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?
Explain the different stages in creating a report in cognos report net?
What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?
where exactly determinants are used in cognos framework manager?