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 |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2009-08-25 : 09:43:16
|
| I am working on a report (in SQL Server Reporting Services 2005) that has two data sources, one is Oracle 10g and one is Sql Server 2005. I can make the connections to both data sources, and even create the datasets for each in the data tab. My problem is that the report will be generated when the user selects a sales region (parameter) from the second dataset, which is a sql server table. All the values come from one dataset needs to "feed" the parameters for the second dataset. The first dataset shows all Orders included in a particular sales region. The user must choose the sales code to get all info about the orders. The second dataset has regions and associated sales. Both datasets have a relatable (join-able) field which is the ZipCodes. I cannot figure out how to join the two datasets.Is it possible to create a report in report builder (VS 2005) using two different datasets? How to I create the report if it is feasible? Also as the database is Oracle 10g, when I choose date, I don’t get calendar control when I view the report. The user needs to enter the date in ‘yyyy-mm-dd’ format, which is not liked by all users. How do I get the calendar control in the reports? Does anyone know how achieve these tasks in SSRS 2005? This is urgent. |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2009-08-25 : 17:24:19
|
| Nobody replies ?????????????? Please answer................. |
 |
|
|
|
|
|
Cannot create report with 2 different datasources.