Reporting Services 2005 - export to CSV with no header

I have a very simple table report. I need to be able to export it as a CSV, but I can not have the first line being the header. I need just the data and no header. Is there a way to do this? I tried working with the Output tab on the tables properties, but I only seem to be able to include or exclude columns not the column headers.

I look forward to you response.

FredZilz

Hello,

To do this you need to set the DeviceInfo parameter "NoHeader" to True:

http://msdn2.microsoft.com/en-us/library/ms155365.aspx

-Chris

|||

Excellent, I can now get my results using URL Access.

Can, I set Device information settings as the default for a particular report (not at the server level but at the report)?

Thanks

|||

Hello,

DeviceInfo parameters can be set 1) via URL access, 2) when rendering with the SOAP API, or 3) set in the report server config file for the entire server (all reports).

However, they cannot be set as default for particular reports.

-Chris

Reporting Services 2005 - CSV - ASCII - ￡(Pound symbol)

Hi

We are having problems getting Reporting Services 2005 to export to an ASCII CSV file and correctly produce a ￡(GBP sign).

I have changed my report server .config file to read:

<Extension Name="CSV1" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-8</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-8</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV2" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - UTF-7</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>UTF-7</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
<Extension Name="CSV3" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<OverrideNames>
<Name Language="en-UK">CSV - ASCII</Name>
</OverrideNames>
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>

And so far so good I get the three options to export to,

If I Export using the ASCII Rendering my pound signs come out as question marks (?) and subsequently loads into Excel as a general data type and is not sum-able.

If I Export using UTF-8 Rendering my pound signs come out as a weird character followed by a pound sign, again opened in excel loads as a General data type and is not summable.

If I export using UNICODE rendering, by file sizes are doublesd as you would expect, and then when you open in excel it is all bunched up in column 1, both un-acceptable.

Interestingly enough If I take the UTF-8 file I have and convert it to ASCII using Ultraedit, notepad or wordpad, everything works fine, the ￡ is correctly encoded, Excel loads it OK and it is summable, result, but I can not use get my end users to perform this "kludge" for an export.

Any help would be appreciated

Thanks

Tim

Hi Tim,

Excel, for some reason, has a problem opening comma separated files with Unicode encoding. This is why you are seeing all of the columns smashed together. In order to get Excel to properly open a Unicode file you should switch to using a tab delimiter. Unfortunately due to a product issue, tab delimiters are not settable in the server configuration file. They are settable when rendering using the URL. Example:

http://server/reportserver/?/myreport&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

As for the pound symbol being interpreted as text, I find that if I switch my machine to a en-UK locale this works fine. I can repro your issue when my machine is en-US. Can you verify this?

Thanks,
Chris

|||

Thanks for the pointers here.

Unicode is not ideal for us due the doubling of file size, and we are not using the URL method of rendering so tab delimited is out.

So on to your other comments, I have been trying all morning to make it not produce a ? (question mark)

1. The Local of the machine is definately en-UK, this is the only loaded local
2. The language property of the report in Report designer was set to English (United States), thought I had found it : )

But this changed to English(United Kingdom) re-deployed IIS reset and re-run, exactly the same ? instead of ￡ when exporting to ASCII, and odd character then ￡ in UTF-8

Out of interest the way we have forced the display of the ￡ symbol is using the Format property in report designer setting it to : ￡#,##0.00;(￡#,##0.00)

I am interested how you have managed to re-create by changing the locale ?

Thanks for your help

Tim

Reporting Services 2000 Export Excel Issue

Hello All,
I am currently creating a Reporting Services report whose total
page width is 33in. I use three data tables to simulate one very large table.
My issue is:
When I export this data to the EXCEL format, tables two and three are not
visible past the first sheet. Is there something that I should do to ensure
that all three tables are visible on every Excel WorkSheet?
Thanks
EricOn May 3, 2:52 pm, Eric <E...@.discussions.microsoft.com> wrote:
> Hello All,
> I am currently creating a Reporting Services report whose total
> page width is 33in. I use three data tables to simulate one very large table.
> My issue is:
> When I export this data to the EXCEL format, tables two and three are not
> visible past the first sheet. Is there something that I should do to ensure
> that all three tables are visible on every Excel WorkSheet?
> Thanks
> Eric
I'm not sure about the maximum width of a report; however, you can try
adding all 3 table controls into a single rectangle control. This
should conserve width space. Also, make sure that the properties of
the table controls include 'Fit table on one page if possible.' Sorry
I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Reporting Services - Export to PDF problem with links

Hi,

After exporting a RS report to PDF the links(Jump to Report) are removed. Is there anyway to keep the links?

We moved to reporting services about a year ago and have been migrating reportings from our old platform webfocus which when we exported to PDF would retain the links.

Thanks in advance

Dave

*Bump* anyone?|||

Please anyone!!! We just migrated from webfocus to MSRS and you could get links working in PDF export in Webfocus... Can RS do this yes or No

anyone?

thanks

dave

|||

Daveycur,

This should work. I have a link to a document in one of the report and when exported to PDF the links is still active and I am able to open the document from PDF. So, links should work when exported to PDF. See if it has to do with the version of Reporting services you are using and also makre sure that there are nothing else that is blocking this.

|||

Thanks for the reply techquest

I am using RS2005. Can't find anything that would stop the link appearing in the PDF. When i export a webfocus report on the same machine the links work. Is there a reporting services options i need to check?

Thanks again

Dave

|||

What service pack are you on?|||

Hmm it seems you can do a jump to URL, but not a jump to report link.

So i guess the only around this would be by formulating a URL using the other report name and passing its params with it.

Thats a b*ll ache! especially when the report jumps to about 30 other reports!

thanks

Dave

Reporting Services - Export to PDF problem

We are facing some problem while exporting the SSRS (SQL Server 2005 SP2 installed on win2K3) Report to PDF format, problem is when we export report to PDF format all the data after 80 columns gets wrapped to next page which not only increases no. of pages in the reports but also disturbs the report format for example if a report contains only one page and 320 columns of data and if we export it to PDF format then the PDF file will have 4 pages each having 80 columns of date. Has anybody faced the similar issues? would appreciate if you can give solution for this problem or forward any link which discusses the same.

That is a common problem, you are exceeding the width of a sheet of A4. With 80 columns your column width would have to be tiny to fit them all on one page. You can get yourself a little extra width on the page by having it render in landscape mode, just swap over the width/height values under the PageSize parameter for the report. You can also reduce the margin sizes. These techniques will not get you a lot of extra space, if you still need more then the only way to get it is to redesign the report (more tables) or select less data (narrow the parameters or filter the returned data).

sql

Reporting Service on MAC

Is it possible to export report on a Mac ?
Which configration minimum (OS, Navigator...) ?
I try on a old Mac and nothing append. I can't modify parameters (in a text
box). I can't export. I can only actualize the report.
Can you Help me plese ?We are aware of some bugs when the report viewer is displayed on a Mac.
Unfortunately, there is currently no workaround.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:CBCE16EC-E245-47A1-9474-7F274620BD78@.microsoft.com...
> Is it possible to export report on a Mac ?
> Which configration minimum (OS, Navigator...) ?
> I try on a old Mac and nothing append. I can't modify parameters (in a
text
> box). I can't export. I can only actualize the report.
> Can you Help me plese ?
>

Reporting Service 2000 Rendering Extension. Changing Default Opti

Hi Everyone,
I'm having an issue with the CSV export in Reporting Services. The default
encoding for CSV doesn't work the best in Excel. I would like to change the
default encoding type for CSV to ASCII. It this possible?
Thanks
ChadYes it is. You need to alter the RSReportServer.config file for the CSV
rendering extension.
By default, the CSV export is in unicode, to export as ASCII then you'll
need to add some deviceinfo for the CSV rendering as follows :
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
Hope this is what you were looking for.
Phil
"Chad" wrote:
> Hi Everyone,
> I'm having an issue with the CSV export in Reporting Services. The default
> encoding for CSV doesn't work the best in Excel. I would like to change the
> default encoding type for CSV to ASCII. It this possible?
> Thanks
> Chad

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.

Reporting Servers - Export to Multiple tabs in Excel

I need to create a Reporting Services report that contains multiple result sets. I want each result set to export to a different tab in Excel. I want to be able to name the tab. I would also like the headings in Excel to show up in the Header section of Excel, rather than in the body of the spreadsheet. Is there a way to accomplish this task.

Put multiple tables in your report and then put page breaks before them. Each manual page break becomes a new tab.

For headers, you need to use a Excel DeviceInfo setting, SimplePageHeaders (see http://msdn2.microsoft.com/en-us/library/ms155069(en-US,SQL.90).aspx). If you want this to be the default, you can add it to the RSReportServer.config file (see http://msdn2.microsoft.com/en-us/library/ms156281.aspx).

|||Is there a way to specify the name of the Excel tab, instead of Sheet1?|||

I would like to do this also. Is there any way to name each Sheet?

|||Unfortunately no, you cannot control the sheet naming.|||

Thanks for answering Mike.

Do you know if there are any plans to add this capability?

|||

I can find no reference to this in the documentation and it appears to be ignored - presumeably this is RS 2005 only? (I'm using 2000 SP2).

Would this get round my current problem of having lots of additional columns/merged cells to accommodate all the header layout when exported to Excel? Ideally I want the data structure in Excel to be a straight forward matrix of the data values in the report table which isn't feasible when exported to Excel with our default headers which contains a lot of labels containing context information.