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 |
|
Spence23
Starting Member
10 Posts |
 Posted - 2005-04-13 : 08:39:16
|
| Hi,I am wondering if this is possible and/or how it can be done.I am looking to run 2 separate queries from within the same report, that when exported to excel, Sheet 1 as the results from one query and Sheet 2 as the results from the other. I am looking to do this as both the result sets are closely related and users would like them separated but within the same excel file.Any suggestions? |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-13 : 09:35:51
|
You cant do this in RS but you can maniupulate in a client application such as VB or VB.netThe excel object model can easily handle this. The problem with RS is that most of the time it is one way, itis a simple reporting tool but writing code like that against it is currently not an option.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
Report that uses 2 excel sheets when exported