COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: actcognosuser on 22 May 2024 05:12:08 PM

Title: Required Date prompt returns no data
Post by: actcognosuser on 22 May 2024 05:12:08 PM
Date prompt is set to required. When the report is run it is allowing the user to select the Finish button even if the date was not selected.
 UI is Edit Box

Title: Re: Required Date prompt returns no data
Post by: MFGF on 23 May 2024 07:34:20 AM
Quote from: actcognosuser on 22 May 2024 05:12:08 PMDate prompt is set to required. When the report is run it is allowing the user to select the Finish button even if the date was not selected.
 UI is Edit Box



Things to check:
Is there a default set for the prompt - either in the Default Selections property, or if the prompt is driven from a macro in an expression, within the prompt macro?
Is the Usage of the filter the prompt ties to set to be required or optional?

Cheers!

MF.
Title: Re: Required Date prompt returns no data
Post by: actcognosuser on 23 May 2024 08:56:55 AM
There is no default set on the date prompt.

This is a required filter in the query



[ReportDate]>=to_char(?P_StartDate?,'Mon DD, YYYY')
and
[ReportDate]<=to_char(?P_EndDate?,'Mon DD, YYYY')

Also by pulling the paramdisplayvalue(?P_StartDate?) and ?P_EndDate? , I noticed
that the calendar date is displaying as May 1, 2024 instead of May01, 2024.