I am trying to create a report that gives me the total $$ on items created for the current year. The problem is the $$ are in two distinct databases, one database is for items that are open and being worked on and the second database is for items resolved/closed. In addition, the $$ have to be grouped by customer number. What would be the best way? I am using Cystal Report 8.5.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Totaling Amounts from Two Databases
- Thread starter davidmo
- Start date
Trainingjason
Instructor
Add the second database as a nonlinked subreport, then create a shared variable. This can be used to pass a value from the subreport to the main report.
The values can then be added. Takes a little playing around to get working
Jason
The values can then be added. Takes a little playing around to get working
Jason
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question