Multiple DataSources on a DataSourceView

I have added multiple tables from different data sources to a dsv. When I try to make a model from that DSV, it throws an error, saying that it can't find any of my tables that are not the primary tables. Is this a bug or am I missing something that I should be doing?

TITLE: Microsoft Visual Studio

An error occurred while executing a command.
Message: Invalid object name 'dbo.CategoryID'.
Command:
SELECT COUNT(*) FROM [dbo].[CategoryID] t

BUTTONS:

OK

Thanks!

Nathan

I have done a bit of research on the issue and I am now thinking it may be a problem w/ my databases, but I am not sure. What I do need is to confirm that someone has used DSV's that contain multiple datasources with success. Thanks!

Nathan

Multiple DataSources on a DataSourceView

I have added multiple tables from different data sources to a dsv. When I try to make a model from that DSV, it throws an error, saying that it can't find any of my tables that are not the primary tables. Is this a bug or am I missing something that I should be doing?

TITLE: Microsoft Visual Studio

An error occurred while executing a command.
Message: Invalid object name 'dbo.CategoryID'.
Command:
SELECT COUNT(*) FROM [dbo].[CategoryID] t

BUTTONS:

OK

Thanks!

Nathan

I have done a bit of research on the issue and I am now thinking it may be a problem w/ my databases, but I am not sure. What I do need is to confirm that someone has used DSV's that contain multiple datasources with success. Thanks!

Nathan

Multiple datasources in SSRS 2005 reports

Hi,
Is is possible to have multiple analysis Services datasources for a single
report? I want to be able to display measures from both cubes on the same
report with a common dimension without having to redesign my cubes.
Thanks!
BrianThe short answer is yes, but you won't be able to display the measures
side-by-side in the same region if this is what you are after. That's
because you cannot join RS datasets. That said, you can have two regions,
each bound to its own dataset. If you have a virtual cube and your MDX query
pulls data from both cubies than you should be OK.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Brian Madden" <bmadden@.gmail.com> wrote in message
news:756074632671466407265129@.msnews.microsoft.com...
> Hi,
> Is is possible to have multiple analysis Services datasources for a single
> report? I want to be able to display measures from both cubes on the same
> report with a common dimension without having to redesign my cubes.
> Thanks!
> Brian
>

Multiple Datasources in one report

I am very new to crystal so please excuse if this is a basic request...

We are using Crystal 9.2. I have two datasources, one in oracle and the other in sqlserver. I need to join the two datasources together with the full outer join option, but that option is grayed out in the Links tab in the Database expert window. I basically need to do a UNION ALL between the two datasources, I want to display all the rows from both datasources. Is this possible? What am I missing? Do I need to use a subreport? I need to do grouping/totaling between the two datasources.

What would be ideal, is if I could create a view between the two datasources (using the union all option) and then use that view as the datasource for the report. Is there anything like this available?

Any pointers would be greatly appreciated!Migrate data and keep them in a single datasource

Multiple datasources

Hi,
I've written a report that uses a matrix to display some data that all
comes from a funky select statement. The report is month based, so
there is a where clause specifying the month in the select
The user now wants to add a Year to Date column. Because of the data
structure of the data i don't believe it is possible to pull the YTD
figure in the same statment.
Is it possible to have one of the columns in a matrix (or any other
control) that is based on a different dataset which takes a parameters
from the matrix row?
I'm guessing theres not, but I just want to make sure, theres alot of
smart people out there :)
Thanks
AndrewWhat you want to do is to investigate subreports. You can embed a subreport
into a column (I have done this). If the subreport returns multiple rows
then that column would go down multiple rows. In your case you will only be
returning a single row. You will want the subreport to be very simple
(obviously) since you are embeding it. Note that the subreport is called for
every row. What I do in this case is hide the report in list view so users
don't see it when selecting a report to run.
To develop a subreport you develop it like a normal report with parameters.
Make sure it works. Drag and drop the report into the column you want (add
an extra column/field that is blank and drop it into it). Then do a right
mouse click on the embeded subreport and select parameters to map the
subreport parameters to the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ajharvey@.gmail.com> wrote in message
news:1114049920.896557.185450@.o13g2000cwo.googlegroups.com...
> Hi,
> I've written a report that uses a matrix to display some data that all
> comes from a funky select statement. The report is month based, so
> there is a where clause specifying the month in the select
> The user now wants to add a Year to Date column. Because of the data
> structure of the data i don't believe it is possible to pull the YTD
> figure in the same statment.
> Is it possible to have one of the columns in a matrix (or any other
> control) that is based on a different dataset which takes a parameters
> from the matrix row?
> I'm guessing theres not, but I just want to make sure, theres alot of
> smart people out there :)
> Thanks
> Andrew
>|||Thanks,
I'll give that a try