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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2008-04-04 : 09:06:18
|
| Hi all,I have a 150 procedures in a database. Basically each procedure will have a different layout. i got all the procedurename from the queryselect object_name(id) as ProcName from sysobjects where xtype = 'P'.How do i get the datasets to dynamically generate the columns based on each procedure on the header of the layout.thanksVic |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-04 : 12:29:01
|
| You cant have a dataset that takes data dynamic from different procedures. You need to define seperate datasets one for each procedure and use them in reports. Inside report you can have different containers to display data from different datasets and can conditionally hide/show them by using expressions in their visibility property. |
 |
|
|
|
|
|
Dynamic Datasets