Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2008-08-26 : 00:25:09
|
| Hi Guys,I am having a report and When I export it to the .csv file, I do not want the column headers to be dispayed in the .csv file.I tried this in many ways, but was not able to find the solution.I even deleted the header row in the report and then exported it to the .csv file...But to my surprise, I am still able to see the column headers in the .csv file.So, Is there any way or code that makes the column headers hide or invisible when exported to the .csv file.....Thanks,Raaj... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-29 : 09:15:30
|
Tools -> Option -> Query Results -> SQL Server -> Results to Grid -> "Include co9lumn header..."Tools -> Option -> Query Results -> SQL Server -> Results to Text -> "Include co9lumn header..."
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2008-08-29 : 10:42:19
|
| I don't think Reporting Services can handle this issue. You can save the .csv file first and apply a micro code to the file to remove the headers. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-29 : 10:49:53
|
quote:
Originally posted by Peso
Tools -> Option -> Query Results -> SQL Server -> Results to Grid -> "Include co9lumn header..."Tools -> Option -> Query Results -> SQL Server -> Results to Text -> "Include co9lumn header..."
E 12°55'05.63"N 56°04'39.26"
i think OP was asking for removal of header from report |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2008-08-31 : 01:28:40
|
| Hi Guys,yeah, I do not want the column headers to be displayed when exported to CSV from SSRS.........Any help is really appreciated......Thanks,Raaj... |
|
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
|
|
|
|
|
column headers not displayed when exported to CSV?