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