sql server reporting services: ASCII and Reporting Services -- sql server reporting services

Re: ASCII and Reporting Services

Vipul Shah
1/21/2005 9:09:05 AM

Even if you render in csv, its not a true csv. If you open up that csv in
excel, all the colums appears in one column, you have to than use that wizard
- Data-> text to column to create true csv. Another avidence of that file
not being ASCII, if you save that file you exported as csv, you will see
UNICODE in your save as dialogue. This has been a problem since day one.
This is the biggest issue why we can't use RS for our reports, because all of
our customer needs true csv and don't know how to use Data -> text to column
wizard of excel.

Thanks
Vipul

[quoted text, click to view]

ASCII and Reporting Services

Helma Schapendonk-Maas via SQLMonster.com
1/21/2005 11:08:26 AM

Can Reporting Services create an ascii file? We are searchring for a tool that can handle with predefinied queries to generate week figures, month figures etc. These figures will be used in paper publications as well as in electronical publications.
Is it better to use DTS?

--

Re: ASCII and Reporting Services

RDC
5/18/2005 1:21:02 PM

You can specify the format ascii as CSV Rendering Device Information Setting
if you add
&rc:Encoding=ASCII to the url generating the export

[quoted text, click to view]

Re: ASCII and Reporting Services

Bruce L-C [MVP]
5/18/2005 3:47:13 PM

Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:

="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"

Very nice and very fast.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

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.