exponential values in the report

Hi,

I am values in scientific notation when i am rendering the report into excel.

I wanted the number to be displayed as it is without any scientific notation(exponential format)

Thanks in advance

Nalini

This is generally a formatting problem.

Can you give an example of one of the values that is rendering this way in Excel? Tell us:

* -- what is the real data value and type as it appears in the dataset

* -- what is the expression you are currently using in the RDL to display this expression

>L<

|||

Hi Lisa,

Thanks for the reply

The value which is being displayed is 2E+09

But when we go to the actual value it is 1506500000

One more example in this regard would be 5E+10 and the actual value is 50512086334

The data type in the table is numeric(22,3)

The value given above is a calculated value and is SUM of such fields.

The preview is beign displayed with the normal values but this problem arises when i render them to excel.

Thanks in advance,

Nalini

|||

OK, I did some simple tests with your value

SELECT cast(50512086334 AS numeric(22,3))

... and it looks like all you need to do to fix this is to *widen* the column. If you try widening the column directly in Excel, you'll see what I mean. But you probably should just widen that column slightly in the original report layout to resolve this. I realize that it displays okay in the unexported version, but Excel apparently needs a bit more room <s>.

HTH,

>L<