Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Mahendra on 23 May 2011 06:47:17 AM

Title: How to use Date range prompt on a single date column
Post by: Mahendra on 23 May 2011 06:47:17 AM
Hi gurus,

     In my report I have a date column, how to use date range prompt on the same column, can any body please help me its very urgent...


Thanks in Advance..


Mahi
Title: Re: How to use Date range prompt on a single date column
Post by: MFGF on 23 May 2011 08:16:26 AM
You will need your filter to use the in_range operator

eg

[your date field] in_range ?your parameter?

The date range prompt should then fulfil the start and end dates for the range.

Regards,

MF.
Title: Re: How to use Date range prompt on a single date column
Post by: Mahendra on 23 May 2011 11:51:16 PM
Thanks for ur quick replay,

  And in my report i have used the text box prompts to enter from date and to date,do i have to convert this to date format let me know please..


Thanks & Regards
Mahi

Title: Re: How to use Date range prompt on a single date column
Post by: MFGF on 02 Jun 2011 05:17:14 AM
The best idea usually is to use a date prompt rather than text prompts, but it's your choice.

Regards,

MF.
Title: Re: How to use Date range prompt on a single date column
Post by: Arpitagrawal9 on 14 Jun 2011 01:56:22 AM
You can use to calender/date prompt so that User can directly choose the data and you wont have to convert it in any specific format.Cognos By default provides this prompt.
Hence once you have created both the prompts you can apple a filter in your report query with a condition like [Date] between ?StartDate? and ?EndDate?

Hope this helps:)

In case you still face any issue feel free to write me.
Text only | Text with Images