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

Rending page based on data item value

Started by Anke, 25 Aug 2017 11:12:40 AM

Previous topic - Next topic

Anke

Hi,
I have several queries each with specific filters.  I have a page for each query. I am trying to print all of the stores letters together in one report... with a query for each page/letter.

I would like to render the correct page based on a render variable.  I have not been successful in getting this to work.  I have done render variables but always from a prompt value.  Without some type of render variable I am getting blank pages...

If each query if for a separate store (as each query has other store specific filters)...e.g query1 store is South, query2 store is West...and so on....How can I create a variable so that when the report runs, I get letters for each store and zero blank pages.

I have tried putting my 'store' data item in the page properties, creating variables for each page, to no avail... :(   


...OR can I create a multi-select prompt... where user selects one or more store and link to correct pages that way?  ...all of the prompts for rendering I have created the user can only select one value...

Anke

WOohooo!  I got it to work! 
I was able to just use a prompt (multi-select) then create multiple string variables and set up that way...
coooolnees!