COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: kbasha2004 on 23 May 2008 02:40:34 PM

Title: Report Period
Post by: kbasha2004 on 23 May 2008 02:40:34 PM
Hi All,

I created 2 Date data items:
Date1= First of Month
Date2= Last of Month

I need to display these values on top of Report with the Heading as Period From and To where I used Text item and from REport Expression I used the above Date1 and Date2 Data items and ran the report in HTML format. I'm able to see the values of Date as 01-May-08 To 23-May-08.

When I run the same report in Excel format it is showing as some number 23459 To 23483.

I tried using ParmDisplayValue and Parmvalaue....not successful.

Can anybody please suggest what is happening here and how to resolve this.

Thanks in advance!

KBasha
Title: Re: Report Period
Post by: Gopinath on 27 May 2008 04:39:15 AM
Place a Block, cut and paste the Date data items in it.
Title: Re: Report Period
Post by: kbasha2004 on 27 May 2008 08:06:03 AM
Hi Gobinath,

Thankyou , it worked.

Kbasha2004