sql server reporting services: Currency Exporting to Excel -- sql server reporting services

You're in the

sql server reporting services

group:

Currency Exporting to Excel

Chris Taylor
3/8/2006 11:41:29 AM

sql server reporting services:

Hi,

In one of my reports I have some fields that are currency fields displayed
with the currency format string (C). However, when I export these to Excel
(2003) I get the little yellow warning that says Number stored as text. And
if I try to do a sum by dragging across the cells and clicking the sigma
button at the top, it causes it to put an odd formula in the top row.

Is there an easy fix so that #'s exported as currency remain tied to excel
as currency?

Thanks,
Chris

Re: Currency Exporting to Excel

Chris
3/8/2006 1:15:33 PM

I tried this on a matrix in RS2005 and it worked OK.
The format was c0. I do remember it being an issue in 2000. I don't
think there was a way round it in the report definition.

The only thing you could try is, in Excel, highlight the column and
format the cell to currency. If this works you will be able to do a SUM.

Cheers
Chris

[quoted text, click to view]

--

Re: Currency Exporting to Excel

Chris Taylor
3/13/2006 10:17:37 AM

Tried formatting C0, stlil getting the text formatted as #.

MS any insight on this?

[quoted text, click to view]

Re: Currency Exporting to Excel

t-weilu NO[at]SPAM online.microsoft.com
3/14/2006 12:00:00 AM

Hi Chris,

Please modify the column width in Excel. I have tested in my side on RS
2005, it works fine.

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Re: Currency Exporting to Excel

Kevin L.
3/23/2006 7:54:01 AM

Nope. I just tried this; both FormatCurrency and Format c0 send a
number as text, causing Excel to just put a Smart Tag on it and ignore
it in functions. I know that converting numbers to text is the entire
purpose of those two functions, but making them the sole means of
formatting numbers makes the Excel export function about as useless as
nipples on the Batsuit.

Wei Lu: I think Chris Taylor means "text formatted as number" and not
"the column's too narrow, so Excel puts in pound signs to tell you to
resize the column."

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn