Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > Reporting Services
Password Reminder
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Reporting Services SQL Server Reporting Services. Please specify which version.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Reporting Services section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 12th, 2008, 09:57 AM
Registered User
Join Date: Jun 2008
Location: Colorado Springs, CO, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Multiple Datasets from multiple Data Sources

I am working on a report (in SQL Server Reporting Services 2005) that has two data sources, one is Oracle 10g and one is DB2. I can make the connections to both data sources, and even create the datasets for each in the data tab. My problem is that one dataset needs to "feed" the parameters for the second dataset. The first dataset shows all products included in a particular catalog. The user must choose the catalog code to get all of the products (run-time parameter). The second dataset has all the costs associated with making the products. Both datasets have a relatable (join-able) field which is the product ID. I cannot figure out how to join the two datasets. When I try to put a parameter on the second dataset using the values populated from the first dataset, I get errors. Same with Filters. Does anyone know how achieve this task in SSRS 2005? Also, for reasons too complex to explain here, it is not possible to create a combined dataset at the database level (UG!!).
Reply With Quote
  #2 (permalink)  
Old June 18th, 2008, 02:25 PM
Friend of Wrox
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc

I do not think it is possible for you to accomplish this task. You may have to create a custom assembly, then pass the parameters to the assembly, then call the assembly with the parameter in the report.

Jaime E. Maccou
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Joining data from multiple data sources ClaesR BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 August 28th, 2006 09:30 AM
Deal with multiple sources Hind XSLT 2 June 5th, 2006 07:16 AM
Query from multiple data sources billmedd BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 September 27th, 2004 10:46 AM
one record set multiple data sources jack1234 Classic ASP Professional 1 October 17th, 2003 12:50 PM

All times are GMT -4. The time now is 07:01 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.