ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Crystal Reports General Issues >> Combined data from multiple sources
http://www.istechforum.com/YaBB.pl?num=1078946091

Message started by David Waldmann on 03/10/04 at 11:14:51

Title: Combined data from multiple sources
Post by David Waldmann on 03/10/04 at 11:14:51

I know how to use two data sources in one report, and how to insert one report as a subreport on another. What I'd like to be able to do is be able to make a formula that uses numbers from two different reports - for instance the labor from payroll and the labor on workorders - or figure out a way to put unlinked data on one report.

Or is that not possible?

Title: Re: Combined data from multiple sources
Post by aricon on 03/10/04 at 11:28:42

What version of Crystal?

Title: Re: Combined data from multiple sources
Post by kevind on 03/10/04 at 12:58:56

David,
One way to get data in a formula from another unlinked table is to access the desired data in a subreport, and return that value to the main report throught a linked paramiter.

Put the subreport in a suppresed section so that it does not print.