COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bbtresoo on 07 Apr 2014 12:38:15 PM

Title: Values prompt/Calendar
Post by: bbtresoo on 07 Apr 2014 12:38:15 PM
Hi Guys,

Please I need all of u to help me to understand something. I created my dashboard including a from date and to date on the prompt page with a values prompt, everything was ok until user asked me to replace the values prompt date by a calendar. When I run the report I get my prompt page with the default date (april 7, 2014) what's normal, when I press button finish, I get a white empty page. When I select different values I get something. After investigation, I found out that when the selected date is not stored in my date column , I get that white empty page. Still don't know why. Has anyone already faced that problem? Thks a lot of your feedback
Title: Re: Values prompt/Calendar
Post by: Lynn on 07 Apr 2014 01:59:15 PM
I'm not sure I entirely understand the question. If you don't have data for a particular day then you can't report anything for that day.

The calendar control defaults to the current date. There are no data handlers you can create to display a message to the user indicating there are no results for the date they chose.

You need to provide some details on what expected behavior you want to get more answers I think.
Title: Re: Values prompt/Calendar
Post by: bbtresoo on 08 Apr 2014 04:30:21 PM
Thank you for your feedback.I've finally found the solution. The empty white page was due to fact that render empty page  option was set to yes instead of no. Actually I wanted to have displayed no data available instead of an empty white page (what's not very user friendly!!) when I don't have data for the selected range.
Title: Re: Values prompt/Calendar
Post by: BigChris on 09 Apr 2014 02:32:56 AM
Thanks for posting the solution...not everybody does!