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