Printable View
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!
Its possible to do this? or I need to do 2 reports?
thanks!
Either create a query that joins the tables, or create a new table for reports.
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
Look at this:
http://www.simple-talk.com/sql/learn...rvices-part-4/
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 likeQuote:
Originally Posted by HanneSThEGreaT
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
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