Link to home
Create AccountLog in
Avatar of robthomas09
robthomas09

asked on

Crystal Reports 11 - pulling independent data from two separate tables

Hello experts,

I am relatively familiar with Crystal Reports, but have a basic fundamental design question, sadly, and want to make sure I begin designing this report correctly from the start.

I have data in two separate tables that are entirely exclusive to each other.  They share no common fields or keys.  I need to pull data from both tables onto one crystal report, based on different selection criteria among the two separate tables.  How can I accomplish this?

My initial thought was to use subreports.  I would create both reports as separate subreports, but I am unsure of what report sections they should live.  Do I throw them both in the Details section?  I assume that two subreports on the same details section will not display well

Example:

Table 1:
ID:          Name:          
001        Smith
002        Doe
003        Jones

Table 2:
Txt:          Order:          
ABC         1
DEF          2
HIJ           3

Crystal Report Result in Detail section:
ID:          Name:      Txt:    Order
001        Smith       ABC   1
002        Doe          DEF   2
003        Jones       HIJ    3

Please note - the first two columns in the above example are a subreport, and the second two columns are a separate subreport.  

Will this work?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Michael Knight
Michael Knight
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Yeah... what is the front end to this data? I mentioned CSV/XLS not knowing if there's true server access or if the db(s) are proprietary (non SA access). What exactly are we dealing with?
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of robthomas09
robthomas09

ASKER

Thanks all - sounds like 2 reports is the best way to go indeed.