sql server reporting services: Export to Excel 2003 -- sql server reporting services

You're in the

sql server reporting services

group:

Export to Excel 2003

Glen Tosco
3/16/2005 9:48:20 PM

sql server reporting services:

When exporting a report to Excel 2003 my calculated field exports as "Number
Stored as Text" is there a way to set these to export to Excel as Numbers?

RE: Export to Excel 2003

v-mingqc NO[at]SPAM online.microsoft.com
3/17/2005 8:25:54 AM

Hi Glen,

Thanks for your posting!

From your descriptions, I understood that you would like to save calculated
field as number in Excel. Have I understood you? Correct me if I was wrong.

Based on my knowledge, I am afraid there is temporarily no such setting we
could configure in Reporting Services.

However, I find you may convert it in the Excel. Check the article below
and let me know whether it works for you

Convert numbers stored as text to numbers
http://office.microsoft.com/en-us/assistance/HP030559001033.aspx

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

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: Export to Excel 2003

Glen Tosco
3/18/2005 7:05:13 AM

Michael,

That is what we are currently doing...however it would be much better if RS
would export it as numbers. We will hard code the calculation into SQL this
should fix our problem.

Thanks
Glen
[quoted text, click to view]

Re: Export to Excel 2003

v-mingqc NO[at]SPAM online.microsoft.com
3/21/2005 12:00:19 PM

Hi Glen,

I do understand that this behavior will have much impact on your business
and I would love to do some further survey to see whether there is anything
I could offer more.

I generate a sample Report with calculated field , however, I was not able
to reproduce it on my side. The data was rendered as number instead of Text
in XLS file.

Would you please show me a sample with SQL Server default data source so
that I could make further research on it? More information, I believe, will
make us closer to the resolution.

Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

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: Export to Excel 2003

Glen Tosco
3/24/2005 6:44:18 AM

Michael,

The data is coming from Great Plains 7.5...would posting the RDL file help
you look into this?

Thanks
Glen

[quoted text, click to view]

Re: Export to Excel 2003

v-mingqc NO[at]SPAM online.microsoft.com
3/25/2005 3:25:28 AM

Hi Glen,

Yes, you may post it here or send it to me direcly v-mingqc@microsoft.com
for security concern.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

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.

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