Home | Parse delimited string in a Stored procedure >>

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.

Your comment:



 (will not be displayed)


 
 
 
 

Live Comment Preview:

 
«February»
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
26272829123
45678910

SQL Team Forums..

About
Syndication:

RSS