Export to Excel...real values getting dispalyed as string

Hi All,
I have generated and exported to excel. The report is of cross-tab consiting
of real values. In excel, the values are shown as of string data type.
Can some let me know why is this happening and how to resolve this.
This is creating a big problem..kindly help
Thanks,
LakshmiYou can put explicit data type conversion for your values i.e.:
=CInt(Fields!Total.Value-Fields!Discount.Value)
Alex
Alex
"Lak" wrote:
> Hi All,
>
> I have generated and exported to excel. The report is of cross-tab consiting
> of real values. In excel, the values are shown as of string data type.
> Can some let me know why is this happening and how to resolve this.
> This is creating a big problem..kindly help
>
> Thanks,
> Lakshmi