Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Changing output to csv Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 8:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 06, 2013 4:05 AM
Points: 3, Visits: 13
Hi

My report is outputting as UTIF-8 but the bank is complaining about that. They say to use DOS, by which I assume they mean csv. I can see that I should be able to modify the url of a report to over-ride the global config settings by using '&rc:OutputFormat = csv'. But where/how do I do that?

I am using Report Builder, not BIDS. Is it possible to do that there?

Thanks in advance,
Post #1406785
Posted Tuesday, March 05, 2013 8:27 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:57 PM
Points: 443, Visits: 822
Flybridge (1/14/2013)
Hi

My report is outputting as UTIF-8 but the bank is complaining about that. They say to use DOS, by which I assume they mean csv. I can see that I should be able to modify the url of a report to over-ride the global config settings by using '&rc:OutputFormat = csv'. But where/how do I do that?

I am using Report Builder, not BIDS. Is it possible to do that there?

Thanks in advance,



UTF-8 is a unicode standard. The alternative to using Unicode is the old ASCII.

I suspect this stackoverflow answer is what you need, but be aware that changing the RSReportserver.config file (on the report server itself) will apply to all reports. If you have unusual characters in your reports or you use multiple languages (particularly unusual languages such as Thai) then you really do need to output in unicode.


In that Stack Overflow link, LachlanB shows an answer for adding new export options.

As for the URL override, that is just a way of extending the URL.

e.g if this is the link to your report
http://reportmanager.com/reports/report.aspx?ItemPath=ReportName

then the override option would be something like this
http://reportmanager.com/reports/report.aspx?ItemPath=ReportName&Format=CSV

But it's not. The way to see what the URL would be is to run the report, chose the save as CSV option and then quickly copy the address from the web browser. Supplying this URL link directly to your client would let them render and open a CSV file directly.

I suspect, however, that your client might not have direct access to the report manager website and you are sending them reports, so the URL option is not necessarily what you want. You would still have the problem that the CSV will be rendered in unicode unless you make the config file changes as above.
Post #1427140
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse