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

The chart cannot show before the filter is selected

Started by udung, 04 Nov 2013 06:15:58 AM

Previous topic - Next topic

udung

hi All,

i have request like below:
- the chart cannot show before the filter is selected

existing condition:
- the filter using value prompt in body page with optional condition



please advise to configure it

Thanks

longbaobao

#1
If I understand your question correctly, you want to set a filter with a default prompt value when you run the report.If that is the case, you can try to  form your filter something like the following syntax:
[Date(Continuous)]>=(#prompt('Date_P1','date', '(_add_days (current_date,-31))')#)

Even if the filter is optional, the report will wait for the parameter in the filter to be set. So all you can see is a blank page. The message "your report is running" will be there forever. This is a problem I came across before and the above syntax is how I solved it. Hope this can help you. :)

calson33

Put your chart in a conditional block, and set the condition to show only when the drop down is not null.

unknown

Or, you can define your prompt on the prompt page and you wont see the chart until you make a selection on the prompt page.

udung

hi calson33,

can you guide me step by step to configure it please
i need the chart not appear befere user click button finish to filter the report


Thank u

udung

Quote from: unknown on 04 Nov 2013 11:52:23 AM
Or, you can define your prompt on the prompt page and you wont see the chart until you make a selection on the prompt page.

in my report, the filter in report page not in prompt page

thank u

udung