Print Page - Date filter not working when a report has more than 1 date field

Title: Date filter not working when a report has more than 1 date field
Post by: crackie on 11 Apr 2007 03:13:01 AM

Hi there,

Has any1 came across a situation where you have a report with 3 dates. For instance you want to see how many files per hour were loaded in a particular day. You will have a File date - Load Start and Load End. When you apply a filter on File Date - it throws an error. When you remove the other dates (Load start and Load End) it's working perfectly.

Rgds

Title: Re: Date filter not working when a report has more than 1 date field
Post by: BIsrik on 11 Apr 2007 03:19:30 AM

check the data types of the two fields..r u using any charecter function in the filter..

Srik

Title: Re: Date filter not working when a report has more than 1 date field
Post by: crackie on 11 Apr 2007 03:24:46 AM

thank you for your reply, this is how I created the filter.
cast_date([DSS2 Data Source View].[t_event_gap].[file_date]) = cast_date( getdate ( ) -1)

I know the other two date fields are datetime as I need to calculate hours from them as well.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: crackie on 11 Apr 2007 03:13:01 AM