Combining two reports from different databases

[jizzycrystal]

Hi
Is there any way to add two reports together? They have the same format but are from two different data sources.
Can I use sub reports to do this?
Thanks

 

[dgillz]

Please define "combine". Do you want to show the 2 reports one after another or do you want to combine and total the data in groups?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[jizzycrystal]

Hi
I want to add the data together. I am doing profit and Loss accounts so I want to add all amounts that have the same nominal code(field)
Thanks

 

[kskid]

Should not be a problem. I've been able to bring both databases into a Crystal XI report.

 

[jizzycrystal]

so how do I do it? Do I need to use sub reports or do I set it up in the database expert section? Please explain, Thanks

 

[satinsilhouette]

I would suggest a subreport and then using shared variables to include the numbers you need from the subreport to add to the main report to get your desired profit and loss data.

Thanks so much!
satinsilhouette

 

[jizzycrystal]

shared variables...ahhh!!!whats that! am an amateur crystal report developer!!!

 

[MarsianStar]

From the Crystal XI help file
"Shared variables use the same memory block to store the value of a variable throughout the main report and all of its subreports. Thus shared variables are even more general than global variables. To use a shared variable, declare it in a formula in the main report as in the following example:

Shared NumberVar x := 1000;

and declare it in a formula in the subreport as in the following example:

Shared NumberVar x;

In order to use shared variables, the variable must be declared and assigned a value before it can be passed between the main report and the subreport.

 

[jizzycrystal]

Is there anyway I can just use database expert and linking options....e.g left outer join etc.
There is one common field to both databases

 

[mwake]

You cannot use the database expert and linking options to solve your problem. I have a similar problem, because we are going live with SAP on 7/1 and need to combine Q1 and Q2 data from our old ERP system with Q3 data from SAP. You need to create a report from the first data source, then insert it into your report from the second data source. By using shared variables, you can use values from the first report for totals in the second report.