Print Page - Should not select future date

Title: Should not select future date
Post by: kirru_alayam@yahoo.co.in on 04 Apr 2016 05:26:45 AM

Hi,

I have report with a prompt page. Prompt page contains a date range prompt (start date and end date).

I have requirement like Future date (05 apr 2016 onwards) should not display in the date prompt when I select 04 Apr 2016.

How to achieve this. Kindly help me.

Thanks,
Hari

Title: Re: Should not select future date
Post by: cognos-t on 05 Apr 2016 02:58:13 AM

Hi Hary,

you can use a filter in the underlying query for the promt with following syntax: [Date Item] <= current_date

Future dates will be filtered out dynamically.

Best regards

Title: Re: Should not select future date
Post by: kirru_alayam@yahoo.co.in on 12 Apr 2016 02:12:26 AM

Hi,

Thanks for your reply.

I have given like below in the filter for date range prompt..

([Presentation Layer].[Effective Date].[Effective Date].[Effective Date].[Effective Date] in_range ?dateRange?)<=current_date

But getting an error..

RSV-VALl-0010 failed to load the report specification. XQE-PLN-0164 The query is not supported. The argument at position 1 of '<=' used in a detailFilter can not be coerced into a 'value' expression.

Thanks,
Hari

Title: Re: Should not select future date
Post by: BigChris on 12 Apr 2016 02:17:36 AM

Hmmm...looks like you're using dimensional data, in conjunction with a detail filter - is that right?

If that's the case then you definitely should look to use a slicer instead.

Title: Re: Should not select future date
Post by: kirru_alayam@yahoo.co.in on 21 Apr 2016 01:47:32 AM

Yes Chris.. I am using DMR Model.

Thanks,
Hari

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kirru_alayam@yahoo.co.in on 04 Apr 2016 05:26:45 AM