COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: udung on 04 Nov 2013 06:15:58 AM

Title: The chart cannot show before the filter is selected
Post by: udung on 04 Nov 2013 06:15:58 AM
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
Title: Re: The chart cannot show before the filter is selected
Post by: longbaobao on 04 Nov 2013 10:04:09 AM
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. :)
Title: Re: The chart cannot show before the filter is selected
Post by: calson33 on 04 Nov 2013 10:15:23 AM
Put your chart in a conditional block, and set the condition to show only when the drop down is not null.
Title: Re: The chart cannot show before the filter is selected
Post by: 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.
Title: Re: The chart cannot show before the filter is selected
Post by: udung on 05 Nov 2013 02:31:27 AM
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
Title: Re: The chart cannot show before the filter is selected
Post by: udung on 05 Nov 2013 05:26:22 AM
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
Title: Re: The chart cannot show before the filter is selected
Post by: udung on 06 Nov 2013 02:35:38 AM
hi Alll,

done
using render variable

Thank u