Connecting multiple databases with the same Tables 2

[GuiNNeSS982]

Do to connectivity problems with our Canada location, we installed a seperate SQL server. I now need to run reports that includes the same data from the US SQL server and the Canadian one. Is there anyway to combine using sub reports or anything else so that the x-tab will combine the two locations.

Thank you

 

[synapsevampire]

First you should post your software version in any post.

I suggest that you create a View in one of the SQL Servers to UNION the data into a single datasource, or at least link the required data into the other database.

Check with your dba, if they can't handle this, hire a qualified one.

-k

 

[GuiNNeSS982]

Ok well the Verison We are running is 9.0 on the server and 9.0-10.0 on workstations

What I am getting from my DBA is that we can not combine the data bases because we would get duplicate RMA records from records that were recorded before the connectivity issue.

 

[synapsevampire]

I hadn't suggested combining databases.

As suggested, if they don't understand what I mean, hire someone that does.

-k

 

[Turkbear]

Hi,
a UNION statement ( at least in most database engines) will eliminate duplicates..

UNION ALL would include them..
Is this not the case with SqlServer?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[GuiNNeSS982]

The main problem I am having is that my Metrix person is not really the DBA and the person who is works in our France location and does not hand over access to his servers very easily. So with that being said; is there anyway at all using Crystal, to search one data source and then another with out having to change data sources.

I am obviously new to this so be kind in your response

 

[synapsevampire]

I can't think of a means to do this readily within Crystal, however if your dba isn't helpful, an alternative is to use MS Access, link (not import) each of the tables within it, and then create a Query and do the UNION within that.

Then use the MS Access query as your data source for the report.

An alternative within Crystal would be to group by whatever it is that you need, then create a subreport to the other data source within the subreport and return the values that the crosstab is to produce using shared variables, in essence you are creating a crosstab by hand.

So if a subreport is in the group footer you might have a formula something like :

whileprintingrecords;
shared numbervar MyValue := sum({table.value},{table.group})

Then in the main group footer you can call the values, as in:

whileprintingrecords;
shared numbervar MyValue

And of course add it to values in the main report.

-k

 

[hilfy]

I have done this through sub-reports. But you have to display and sort the data separately - it can't be combined in the details.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.