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 |
|
cparker
Starting Member
16 Posts |
 Posted - 2008-10-24 : 12:08:46
|
| Can I specify more than one data set for a report on the SQL 2005 reporting services? If, so, how? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-24 : 12:50:44
|
| did you mean dataset or datasource? you can have multiple datasets and datasources for your report. But each dataset can refer to only a single datasource. you can add datasources by rightclicking solution explorer datasources folder and selecting add new datasource. datasets can be added from data tab by selecting new dataset from drop down. |
 |
|
|
cparker
Starting Member
16 Posts |
Posted - 2008-10-24 : 14:43:10
|
| I need to add another datasource for the report. How can I do that within the SQL 2005 reporting services website? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-25 : 02:32:36
|
quote:
Originally posted by cparker
I need to add another datasource for the report. How can I do that within the SQL 2005 reporting services website?
you can add the datasource to your localproject by expanding solution explorer window and selecting datasources folder,right clicking on it and select add new datasource. the detail window pops up. give a suitable name and type (depends on if you want to connect sql db,oracle,analysis service,..). then select server and db you want to connect to. |
|
|
|
|
|
|
Two data sources for one report