Add values from two reports

[dasiga222]

Hi

I am using Crystal Reports 10

I am having two reports for discussion

I am using a report which has the fields
employee number , employee name location, division and Bonus

There is another report which has the fields
employee number , employee name location, division and Base salary

For a given employee the total salary is the ( Base Salary + Bonus )
But both the fields are in two different reports
Now my aim is to add the Bonus to the Base Salary
which are in two different reports

All the other fields employee number , employee name location, division are exactly the same in both the reports

For example an Employee with emp no 10 has bonus of 100 dollars in one report
and in another report the same employee with emp no 10 has a base salary of 1000 dollars

then the total salary of that employee with emp no 10
is 1000 + 100 = 1100 dollars


Both the reports contain equal number of records but there are almost 1000 records in both reports

How can I do it

Thanks

 

[Madawc]

I'm not sure I follow what the problem is. Are the reports getting their data from tables? If so, you just need to put both tables in the same report.

Madawc Williams (East Anglia, UK)

 

[IdoMillet]

You are not providing enough detail about data sources, etc, but assuming these are two different data sources, you can link to them from MS Access. Create a UNION SQL query in Access so that each employee ends up with (up to) 2 records, Group BY employee and compute the sum.

Alternatively, if you need to show the details in Crystal, do the Group BY in Crystal.

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com