Dinakar Nethi Blog

Dinakar Nethi

Exporting blank SRS report to excel does not render the headers

I worked on RS reports for a while and had been confonted with this issue. When the report does not receive any resultset from the datasource it shows up only the header columns in the report manager which is all ok. In our case this particular report was being exported to Excel and strangely the RS did not send anything except a huge textbox with nothing in it.
And our requirement was that the excel spreadsheet should have the header columns even if there was no data. Now I thought of concatenating all the column names and use the NoRows property but that will be exported as 1 column rather than individual columns.

So I found some work-around for that and wrote up an article under SQL Server 2000. Check it out here.

Legacy Comments


Monster
2008-10-13
re: Exporting blank SRS report to excel does not render the headers
Thanks this post

places to stay near Disney World
2011-08-22
re: Exporting blank SRS report to excel does not render the headers
 Your blog is important; the matter is something that not a lot of people are talking intelligently about. I’m really happy that I stumbled across this in my search for something relating to it.

accommodation near Disney
2011-09-10
re: Exporting blank SRS report to excel does not render the headers
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers…

kelina098@ymail.com
2011-09-11
re: Exporting blank SRS report to excel does not render the headers
I will for sure let people know about the tour by posting The Cribs tour banner all over the internet..All the best..

website development Kent
2011-09-22
re: Exporting blank SRS report to excel does not render the headers
I really didn’t know what to look for in that question. I mean I’m still the same guy with the same life, but something in me changed without even trying. Thanks for it.

romantic honeymoon vacations
2011-09-27
re: Exporting blank SRS report to excel does not render the headers
I am really impressed with your recent blog post. I am going to bookmark your website for future references

Azithromycin uses
2011-12-28
re: Exporting blank SRS report to excel does not render the headers
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers…Azithromycin uses

Brain Dumps
2012-01-06
re: Exporting blank SRS report to excel does not render the headers
Just brilliant blog. Thanks a lot.

caplan syndrome
2012-01-12
re: Exporting blank SRS report to excel does not render the headers
Your blog is important; the matter
caplan syndrome is something that not a lot of people are talking intelligently about. I’m really happy that I stumbled across this in my search for something relating to it.

toilet problems
2012-02-04
re: Exporting blank SRS report to excel does not render the headers
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers

Penny Auctions
2012-03-07
re: Exporting blank SRS report to excel does not render the headers
Thanks alot for sharing.Love this site.

Portland Credit Repair
2012-05-23
re: Exporting blank SRS report to excel does not render the headers
Another great post! Thanks.

Phlebotomy Courses
2012-07-05
re: Exporting blank SRS report to excel does not render the headers
Thanks for the wonderful article, it is very appreciateable.

Nike Finland
2012-08-16
re: Exporting blank SRS report to excel does not render the headers
Thank you for sharing, I like it very much, I will study hard, refuel.