Report Period

[kbasha2004]

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

[Gopinath]

Place a Block, cut and paste the Date data items in it.

[kbasha2004]

Hi Gobinath,

Thankyou , it worked.

Kbasha2004