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

Experts Need Help!!!!!!!

Started by knip, 24 Oct 2012 01:44:47 PM

Previous topic - Next topic

knip

HI All,
        I have a report holding a prompt page and a main page
now when i am running my report i pass a parameter from the prompt page say ?x?, and my main page holds a drop down and i am passing a parameter say ?Y? from this drop down.....

either of filters  are applied on the same data item in my query. (my ?X? is multi select and ?Y? is a single select)

the problem is when i am passing a  value from the prompt page my report should run on this parameter with out asking me for ?Y? and when i enter in to main page i should be able to apply ?Y? filter....but here when iam running my report it is popping up me asking for ?Y?, and if i make ?Y? as optional and when i land into main page i am unable to filter my data on ?Y?

Please  help me how to handle this filters



mtirpude

Hi,

Select your ?y? prompt on main page. In the properties pane, click on default selections and give some value as default which you want to see when the main page loads first time. You can change this value in drop down when main page loads.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com

HalfBloodPrince

#2
I think its a logical confusion. when you select first parameter from prompt page it wil filter the data based upon that parameter.Since in report page  u have another prompt on same data item , so its not showing data since its already filtered by first prompt. If In both prompt if u select  same item it wil show data. So u need to take dicision whether to remove  prompt Y or keep X on prompt page or keep Y and remove prompt X

mtirpude

Hi,

In that case, when you drag prompt Y in your main page, use existing parameter "x" for the prompt.

Regards,
Manish | +919673990644
www.infocepts.com | mtirpude@infocepts.com

knip

@halfblood
yes you are right
but when i apply my filt
er in report page, it should over rite the filter i have applied from prompt page,so at a given time only one filter is applied