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.

posted @ Wednesday, March 28, 2007 2:47 PM

Print

Comments on this entry:

# Malhotra

Left by Shrawan at 7/8/2008 6:39 AM
Gravatar
Hi,
i am shrawan kumar malhotra. i am software engineer in Amplesys Technologies pune.

# re: Exporting blank SRS report to excel does not render the headers

Left by Monster at 10/13/2008 12:08 PM
Gravatar
Thanks this post

# re: Exporting blank SRS report to excel does not render the headers

Left by north face jackets on sale at 10/23/2010 8:45 AM
Gravatar
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.

columbia jackets | snow boots | snow boots for women | columbia sportswear | columbia sportswear outlet | cheap north face jackets | the north face outlet | mac makeup | cheap makeup

# re: Exporting blank SRS report to excel does not render the headers

Left by sex toys at 7/17/2011 7:40 AM
Gravatar
thankyou, i agree with everything here the coding was correct.

# re: Exporting blank SRS report to excel does not render the headers

Left by places to stay near Disney World at 8/22/2011 10:40 PM
Gravatar
 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.

# re: Exporting blank SRS report to excel does not render the headers

Left by accommodation near Disney at 9/10/2011 3:59 AM
Gravatar
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers…

# re: Exporting blank SRS report to excel does not render the headers

Left by kelina098@ymail.com at 9/11/2011 7:49 AM
Gravatar
I will for sure let people know about the tour by posting The Cribs tour banner all over the internet..All the best..

# re: Exporting blank SRS report to excel does not render the headers

Left by website development Kent at 9/22/2011 3:08 AM
Gravatar
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.

# re: Exporting blank SRS report to excel does not render the headers

Left by romantic honeymoon vacations at 9/27/2011 12:34 AM
Gravatar
I am really impressed with your recent blog post. I am going to bookmark your website for future references

# re: Exporting blank SRS report to excel does not render the headers

Left by ideal sohbet at 11/3/2011 5:25 PM
Gravatar
arada sallamak güzeldir, ama SRS report edince kötüdür:)

# re: Exporting blank SRS report to excel does not render the headers

Left by Azithromycin uses at 12/28/2011 2:05 AM
Gravatar
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers…Azithromycin uses

# re: Exporting blank SRS report to excel does not render the headers

Left by Brain Dumps at 1/6/2012 11:08 PM
Gravatar
Just brilliant blog. Thanks a lot.

# re: Exporting blank SRS report to excel does not render the headers

Left by caplan syndrome at 1/12/2012 12:28 AM
Gravatar
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.

# re: Exporting blank SRS report to excel does not render the headers

Left by toilet problems at 2/4/2012 12:59 AM
Gravatar
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers

# re: Exporting blank SRS report to excel does not render the headers

Left by Penny Auctions at 3/7/2012 9:10 AM
Gravatar
Thanks alot for sharing.Love this site.

# re: Exporting blank SRS report to excel does not render the headers

Left by nexium vs prilosec at 3/12/2012 8:37 AM
Gravatar
Thanks a lot for making us an easy understanding of Complex Regional Pain Syndrome…It will really helpful to all your readers .
nexium vs prilosec

# jeremy scott adidas

Left by jeremy scott adidas at 5/23/2012 1:20 AM
Gravatar
resulting to retailers having very fierce competition. jeremy scott shoes

# re: Exporting blank SRS report to excel does not render the headers

Left by Portland Credit Repair at 5/23/2012 2:24 AM
Gravatar
Another great post! Thanks.

# re: Exporting blank SRS report to excel does not render the headers

Left by Phlebotomy Courses at 7/5/2012 1:31 PM
Gravatar
Thanks for the wonderful article, it is very appreciateable.

# re: Exporting blank SRS report to excel does not render the headers

Left by Nike Finland at 8/16/2012 12:30 AM
Gravatar
Thank you for sharing, I like it very much, I will study hard, refuel.
Comments have been closed on this topic.
«July»
SunMonTueWedThuFriSat
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789