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 |
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
 Posted - 2007-03-09 : 04:30:53
|
| Hi.Is it allowed to use/create more than 1 dataset in report? (Pertaining to Business Intelligence Project)Thanks.-Ron- |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-09 : 13:32:03
|
| Yes. You'll need more than one if you use drop down parameter lists for example, and you can use multiple datasets in a report because every region (eg. table, chart, matrix) in the report can specify a different dataset (each region is limited to one dataset). |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2007-03-09 : 22:56:13
|
| why i am not allowed to create 2 datasets? I got error if i ran the report even i dont use the 2nd dataset. thanks-Ron- |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-10 : 16:04:53
|
| It would be helpful if you posted the error.Tara Kizer |
|
|
|
|
|
|
more than 1 dataset?