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
|
Shrawan
2008-07-08 |
Malhotra Hi, i am shrawan kumar malhotra. i am software engineer in Amplesys Technologies pune. |
|
Monster
2008-10-13 |
re: Exporting blank SRS report to excel does not render the headers Thanks this post |
|
north face jackets on sale
2010-10-23 |
re: Exporting blank SRS report to excel does not render the headers 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 |
|
sex toys
2011-07-17 |
re: Exporting blank SRS report to excel does not render the headers thankyou, i agree with everything here the coding was correct. |
|
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 |
|
ideal sohbet
2011-11-03 |
re: Exporting blank SRS report to excel does not render the headers arada sallamak güzeldir, ama SRS report edince kötüdür:) |
|
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. |
|
nexium vs prilosec
2012-03-12 |
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 . nexium vs prilosec |
|
jeremy scott adidas
2012-05-23 |
jeremy scott adidas resulting to retailers having very fierce competition. jeremy scott shoes |
|
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. |