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 |
New coloums are added in database, then how you know in report level
Why cognos decision stream is used?
How do I remove the hyperlink from the drill through report?
----------0Diff b/w Report Functions and Database functions?
hi,dis is kumari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is vicky_ceti@yahoo.co.in hope u will respond as soon as possible. thank u in advance
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
Is it possible to apply access manager user rights in impromptu?
what is power prompt in cognos ep7series?what is the use of this?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
difference between join and union in reportstudio?
How can we do the unit testing?
what is mean by complex starschema ,star schemagrouping?