COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: actcognosuser on 26 Jan 2024 04:51:15 PM

Title: Running a report in PDF does not show the prompts
Post by: actcognosuser on 26 Jan 2024 04:51:15 PM
Hi,

Prompt page is based on radio button selections. Pages are rendered based on radio button group.
When option B is selected Employee Sales page is rendered. But the report page has prompts for date and sales type which is not displaying when the report is run in PDF or Excel.

PROMPT PAGE
Radio button group
A Overall Sales
B Employee Sales
C Regional Sales
D Product Sales

REPORT PAGE for B

Value Prompt 1 Select start date    value prompt 2 select end date  value prompt 3 select Employee

List
Employee Name  Sales DEpt  Revenue     MachineID
abc            Furniture    $34,344       g1258


Title: Re: Running a report in PDF does not show the prompts
Post by: cognostechie on 27 Jan 2024 07:44:12 PM
Create a Layout calculation on the Report Page, select the Prompt and insert it inside the Layout calculation. It will be something like ParameterDisplayValue('ParameterName')
Title: Re: Running a report in PDF does not show the prompts
Post by: dougp on 29 Jan 2024 11:49:35 AM
I'm confused.
Are you wanting to display the prompts and somehow make the Excel or PDF output interactive?  That won't work.  They are HTML elements.  They'll only work in the browser.
Or are you just trying to display the parameter values that were used?
Title: Re: Running a report in PDF does not show the prompts
Post by: actcognosuser on 31 Jan 2024 01:37:19 PM
I want to display the prompts on the Report and also the detail in the list.
Title: Re: Running a report in PDF does not show the prompts
Post by: actcognosuser on 31 Jan 2024 01:40:10 PM
@Doug Can we have the radio button and date prompts on the prompt page?