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.
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