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

Reprompt on a Joined Query

Started by A.C.Sanchez, 12 Apr 2011 10:57:45 AM

Previous topic - Next topic

A.C.Sanchez

I have two queries (query1 and query2), one of which contains [Product Type].  The queries are joined (Main Query), and produce correct output.  I want to add an optional reprompt to my report, based upon [Product Type].

I have another query called p_Product Type, which is the parameter for my prompt.  When I then point my query to this parameter, should I do that in the original query1, or in the joined Main Query?  Or does it need to be in both?

I can't figure this out for the life of me!