Error: To prevent unexpected results.....

[hschembri]

I have successfully created a report with a prompt page. When I come to the workspace, I drag the cross tab component of the report and than my prompt page and on apply of the filter, I get the error:

To prevent unexpected results, this widget is not currently responding to prompts.

Screenshot below:
https://drive.google.com/file/d/0B13O4Lr3CqAlcmttcS1TYTFzbVE/edit?usp=sharing

I am using IBM Cognos Workspace 10.2.1.

[vkraju]

using "CAST" instead of to_date or to_char in the filter fixed the issue.

Example
cast([Presentation Layer].[Calendar].[Date Time], varchar(50) )  between (?p_dur_from?) and  (?p_dur_end?)