Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Export To Excel error
0 views
Skip to first unread message
Kevin Vogler
Nov 9, 2009, 5:30:13 PM11/9/09
to
I have a report with numeric data that displays correctly on a web page or
exported as csv or xml. However, when it's exported as Excel, the "number"
formated column displays as "#Value!". the currency formated column displays
correctly everywhere. The numeric column is an integer and is a sum (ie.
Sum(Fields!MonthUnits.Value). What should I change to get the data to
display correctly in Excel. I can't find any other instances in the other
reports.
exported as csv or xml. However, when it's exported as Excel, the "number"
formated column displays as "#Value!". the currency formated column displays
correctly everywhere. The numeric column is an integer and is a sum (ie.
Sum(Fields!MonthUnits.Value). What should I change to get the data to
display correctly in Excel. I can't find any other instances in the other
reports.
Thanks in advance,
Kevin
Rictastic
Nov 10, 2009, 9:23:39 AM11/10/09
to
Hi
It's just a guess but try Sum(CInt(Fields!MonthUnits.Value)) and see
what happens
Kevin Vogler
Nov 11, 2009, 2:12:49 PM11/11/09
to
Thanks for the response.
I'm still not sure how I fixed it. All I did was change the cell formatting
to show the 1000's separator. It was already formatted as numeric.
Thanks,
Kevin
"Rictastic" <rickd...@gmail.com> wrote in message
news:6195897a-cc6d-4222...@m26g2000yqb.googlegroups.com...
0 new messages