Montana751
Programmer
Crystal XI
1st datasource are SQL tables on Server A
2nd datasource is QuickBooks on Server B
Is there a way to join these (log in, etc.) WITHOUT USING
~ a subreport
~ creating a Crystal SQL query
~ creating a SQL Union
I have 3 fields that are the same in each datasource that need to be the same in order for the correct records to return. I can do it with a subreport, but prefer not to, as I have to create a form with lines and stuff that all have to line up in the Details section. The SQL data is on the left side of the details section and the right side's data is going to come from Quickbooks.
Any ideas??
1st datasource are SQL tables on Server A
2nd datasource is QuickBooks on Server B
Is there a way to join these (log in, etc.) WITHOUT USING
~ a subreport
~ creating a Crystal SQL query
~ creating a SQL Union
I have 3 fields that are the same in each datasource that need to be the same in order for the correct records to return. I can do it with a subreport, but prefer not to, as I have to create a form with lines and stuff that all have to line up in the Details section. The SQL data is on the left side of the details section and the right side's data is going to come from Quickbooks.
Any ideas??