display date in increment order..???

[pooja]

please advice how to display dates in increment order from pearameter_display for a week.
ex-
we have weekly-report which dispaly data for MON-FRI.
user can select any monday_date(DATE_FROM prompt) in prompt page which results MON thru SAT data in report.
now we are trying to display all the date col in report from prameter_dispaly
we tried _add_days(paramdispaly(date_from),1),_add_days(paramdispaly(date_from),2)  but not working.
please share any hints

thank you in advance

[MFGF]

now we are trying to display all the date col in report from prameter_dispaly

Hi Pooja,

Sorry - I don't understand what you are trying to do.  Are you trying to display the dates included in the report in a heading?

we tried _add_days(paramdispaly(date_from),1),_add_days(paramdispaly(date_from),2)  but not working.

What is date_from?  Is it a query item?  A parameter?  Something else? If it is a query item, what data type is it - a date or text or...?  If it is a date query item, then using _add_days() is a legal thing to do, but would need to be used directly on the item - ie -  _add_days([date_from],1)

What is paramdispaly() - I don't think this is a valid function in Cognos 8.  Do you mean ParamDisplayValue() or ParamValue() or something else?

What do you mean by "but not working"?  Does it not return a result?  Does it return an error?  If so, what is the message?

Lots of questions! :)

MF.

[pooja]

sorry MFGF

its a date parameter with prompt page

we want to display:

when user select 09/06/2010 (monday) on prompt page--then it should display all week long dates like-
09/06/2010 | 09/07/2010 | 09/08/2010 | 09/09/2010 | 09/10-2010 | 09/11/2010

and we have a prompt page with date_from.
=====================================
we tried _add_days(paramdispaly(date_from),1),_add_days(paramdispaly(date_from),2)  but not working.---

It gives us error.


please advice

[MFGF]

sorry MFGF

its a date parameter with prompt page

we want to display:

when user select 09/06/2010 (monday) on prompt page--then it should display all week long dates like-
09/06/2010 | 09/07/2010 | 09/08/2010 | 09/09/2010 | 09/10-2010 | 09/11/2010

and we have a prompt page with date_from.
=====================================
we tried _add_days(paramdispaly(date_from),1),_add_days(paramdispaly(date_from),2)  but not working.---

It gives us error.


please advice

Do you mean that you want these dates to be included in the report, or you want the dates to be displayed on the prompt page?

Where are you coding this expression - as a filter?  A layout calculation?  A query calculation?

If it is a filter, then you could try:

[your date item] >= ?date_from? and [your date item] <= _add_days(?date_from?,5)

Or am I misunderstanding what you are tyring to do?

MF.