If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Rendering Report Pages Based on Selections

Started by mgregory24479, 11 Sep 2019 11:38:15 AM

Previous topic - Next topic

mgregory24479

I have a report that has 5 pages:
~ Info
~ Dupes
~ Email
~ Mail
~ Call

When users run the report, they will run it as Run Excel and Info and Dupes will always show. We want the users to select the page type that want to receive output on. For example: if they select within the prompt page that they want email, they will only get info, dupes, and email. If they select Info, Dupes, Email, Call, they will only get that info.

Here is what I have done within the report file:

~ I have created a value prompt (titled pListType).
~ Static Choices have been set to:
       * M-Mail
       * E-Email
       * C-Call
~ I created the variable type to Boolean Variable for each item listed above to read ParmDisplayValue('pListType)'XXX' respectively.
~ I set the respective page Render Variable to the applicable values
~ Ran the report, selected the value of Email and Mail and when the file Excel file opens only my Info and Dupes page shows.
~ Ran the report, selected only one of the static choices (i.e., Mail) and it returns Mail, Info, and Dupes

I know I am missing a step, just can't figure it out. Any help is greatly appreciated.

     

manjunathgowda

Hi,
what you done correct after static choice
-- create string variable , In expression use value prompt parameter, add values
Email
Mail
Call
--go to page explorer ,select report page
click on column Email-- Properties --conditional -- render variable =string
select email and dont select  mail ,call
again repeat it for other two