January 25, 2007 at 1:10 am
Hi,
In my project i want a report. In that report data is getting from more than one data sources(systems). While creating data source view i used named query for both primary and secondary data source. But at the time of crating "Report Model" i am getting below error.
An error occurred while executing a command.
Message: Invalid object name 'Table2'.
Command:
SELECT COUNT(*) FROM (SELECT SerialNum, ModelNum AS com_model
FROM Table2) t
Is there any way to create a report with multiple data sources?
Regards
Suresh
January 26, 2007 at 1:13 am
From the terminology you're using, you seem to be building report models for Report Builder rather than RS reports as such. If so you can indeed incorporate named queries in your model, so I would guess the error lies in the SQL: where does Table2 come from? (You could also try missing off the final 't' as it's not always required for subqueries).
February 28, 2007 at 11:48 am
I'm encountering the same error, trying to add multiple data sources to a single data source view. It appears that regardless of the data source the table is associated with in the GUI (in the DSV), at model generation time it looks for all tables in the primary data source.
Has anyone found a solution for this?
February 28, 2007 at 5:22 pm
I can't say I've run into this problem before, but can you not create the subquery in SQL Server itself (as a view or stored procedure) then SELECT the view or EXEC the SP? That way you'll only have the one data source in Reporting Services.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply