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 |
KimberlyB
Starting Member
1 Post |
Posted - 2005-08-17 : 17:10:08
|
Can anyone tell me how to use more than one data set in a data region? I have tried putting a list in a list, table in a table, list in a table....nothing has worked for me. What am I missing? The problem is that I have multiple, multiple datasets for the report that I am working on, and I have data in an area coming from multiple sources. Can this be done without rewriting the stored procedures?Kimberly |
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-17 : 17:28:58
|
I have done something in a very limited way that resembles what you describe. I needed a single value from another DataSet referenced in an expression in a table. To do that, I created a hidden text box on the report layer itself (not contained in any other container) and populated it with the single value. Then in my table, I could reference it using ReportItems!textboxname.But for multiple values, you're basically restricted to one DataSet per container. It then becomes a matter of clever formatting. Or, as you suggested, define you DataSet to contain everything you need.---------------------------EmeraldCityDomains.com |
 |
|
gcowhsu
Starting Member
38 Posts |
Posted - 2005-08-18 : 21:23:21
|
You can try sub reports. But they do not export to Excel properly. |
 |
|
|
|
|