How to make a report with multiple datasources?

[RH+]

Im designing a report with reporting services (not crystal) I add a table drag some fields to that table and that works great, now I need to add another table component and drag fields from another query (in the same dataset).
When I try to test it it says:
A data source instance has not been spplied for the data source Dataset1_SP1 (this is the second query).
Is there a way to do this?
I need to list first elements from one query and then from another.
Thanks!

[RH+]

Its possible to do this? or I need to do 2 reports?
thanks!

[dglienna]

Either create a query that joins the tables, or create a new table for reports.

[RH+]

I have 2 Stored procedures, I use one to fill the first table and want to use the seccond to fill a seccond table (when I talk of tables im refering to the table control of the reports).
When I add the elements of the seccond SP to the seccond table control it gives me that error.
Thanks

[dglienna]

Look at this:

http://www.simple-talk.com/sql/learn...rvices-part-4/

[HanneSThEGreaT]

I agree with post #3 ( although I'm not a database guru, I have done this before ).
The best solution would be to create either a query that joins the tables ( a junction table )and use that for your source

[RH+]

I agree with post #3 ( although I'm not a database guru, I have done this before ).
The best solution would be to create either a query that joins the tables ( a junction table )and use that for your source

Yes, but...they have different number of columns and datatype, I need something like
receipt1 value code descriptcion
.
.
.

-------
dollarSerial dollarValue
.
.
.

I need to have the data in same page but with different titles/number of columns/number of rows.
This cant be done with join table...or im wrong?
thanks

[dglienna]

Join the table BEFORE you put it into the report. Then, you can create sub-reports using ONE TABLE. More work, but the only way to do it