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.

 All Forums
 Development Tools
 Reporting Services Development
 help please

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -