COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jb2321 on 23 Apr 2015 03:26:44 PM

Title: PDF Drill Through Yields Different Results than HTML
Post by: jb2321 on 23 Apr 2015 03:26:44 PM
We recently came across a report that seems to spit out different data based off of the format you run it in.  We have a summary crosstab report that lists a total count of people for a certain fund code within a selected year. We have enabled drill through functionality on the total count field.  When you run this report in HTML and click on a drill-able count number for let's say the fund code of 'ABC' the drill through report launches and I get a list of the people associated with fund code 'ABC', exactly how it should work.  When I run the same report in a PDF format and click on the count number for fund code 'ABC' my drill through report opens with a list of every person from every fund code.  Has anyone seen or heard of something like this before?

Thanks for your help on this.

Jesse
Title: Re: PDF Drill Through Yields Different Results than HTML
Post by: BigChris on 24 Apr 2015 02:01:59 AM
You can render different things depending on the format of the report...I'd check for that in your source report. Have a look for variable(s) based on ReportOutput().
Title: Re: PDF Drill Through Yields Different Results than HTML
Post by: navissar on 24 Apr 2015 08:53:45 AM
If I understand correctly, when your parent report is pdf, it doesn't pass selection parameter values to a child report. That's to be expected, PDF doesn't hold any contextual data, nor is it able to transmit it further...
Title: Re: PDF Drill Through Yields Different Results than HTML
Post by: jb2321 on 11 May 2015 08:20:27 AM
Hi Nimrod Avissar,

That's exactly what is happening, I'll just have to make sure they execute the summary report in HTML and not in PDF.  Thanks for the reply.
Title: Re: PDF Drill Through Yields Different Results than HTML
Post by: sunny bachan prasad on 25 May 2015 01:25:32 PM
Hi Nimrod,
So drill through is not possible if the user will run the report in PDF format.