csv export without headings

Hi,

is it possible to export a report to a csv file without the headings?

at best i have been able to hide the headings in the report, but when exported to csv file it includes a row at the top of commas, then the data follows. I need the file to be just the data.

thank.

Hi,

Most of the elements on a report contain some properties concerning the output format. You can disable/enable certain elements.

For example if you don't want to export the headers of a table, then you need to perform the following actions:

select a cell in the header of the table|||Hi,

thanks for replying, that kind of worked. I am still getting the first row to be a row of commas. do you know how i can get it to omit this first row of commas?

if not, we could have all the column headings, but because it's a matrix, it's not exporting my static column headings. any ideas on this?

Thanks.|||I'm still having trouble with this so if anyone has any ideas i'd love to hear them.

My report has a matrix no it, which has 6 static columns. Above the static columns i've placed a table object. In that table object i've remove the footer and details section and added 6 columns so that the 6 static column in my matric can have column headings.

When i export to CSV the static column headings do not get exported, instead it exports just the columns that seperate the fields. The column headings for the matrix appear after the 6 commas.

I either need to hide this whole first row in the CSV file, or have it populated properly with the static column names.|||

To eliminate column title row that you see before the data, use NoHeader option:

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

You can use it with URL access (add &rc:NoHeader=true to report url), or, for RS 2005, you can configure your CSV rendering extension to always ommit the header row.

CSV renderer doesn't stack data from 2 different data regions, so your trick with table above matrix won't get you the result you are looking for.

|||thank you so much. that has worked!!!!!|||

Hi, Denis

I have been trying for two days to figure out how to export reports in csv without headers. You've explained it but I still can't figure out how to do it. Can you assist me?

1) I'd like to be able to have the user select the csv format and export (from Report Manager) to csv format w/o headers...and

2) in a subscription that will automatically export a report to users in a csv w/o headers format. Can you give me some examples?

thanks!!!

|||

Denis

Specifically, you indicated:

You can use it with URL access (add &rc:NoHeader=true to report url), or, for RS 2005, you can configure your CSV rendering extension to always ommit the header row....

how do I (in RS2005) configure my csv rendering extension to always omit the header row....

|||Hi Chaps

I have a Matrix Report with dynamic column headings
ie headings change subject to date
I cannot get the coulmn headings to export.

Is this possible with a Matrix report ?
any guidance most appreciated.

Regards

JohnJames