Link to home
Start Free TrialLog in
Avatar of mco32
mco32

asked on

Crystal Reports - Data not showing on report - Help with linking

Hi There,

I am trying to do a report in crystal that has lots of tables.  I have a lead table which can have one or more additional info details listed so I have the join going from the lead table id to additional info lead id.  I want to display the lead info regardless if there is a matching record in the additional info table.  I have two records in the database for testing.  The first contains a record in the additional info table.  The second record does not contain any additional info record.

This is what happens with linking:

Equal join: Shows only records where data exists in lead table and additional info
Left outer join: Shows  both lead records, but where the record has additional info it hides the subreport and does not show the additional info.  On the second record with no additional info the lead info and additonal info subreport show ( no data in subreport as expected)  
Right outer join: Shows only records where data exists in lead table and additional info

I am new to crystal but surely this should be a left out join but why when I left outer join is it hiding my subreport with data.

Please help.  This is urgent. I am supposed to be going live with this tomorrow morning.
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Is your subreport based on the same table you are adding into the main report?
If so why do you need to do both?

It sounds like you need to check the links from your subreport to your main report, in any case.
Avatar of mco32
mco32

ASKER

I cut the report way down.

On the main report I have leads (Primary Key Lead ID - Auto number generated)

On the sub report I have Leads + additionalInfo (Foreign key - Leadid)

Against 1 lead you can have many additionalinfo records.

I have attached the links - not really sure what I am doing as its all new to me.
Links.jpg
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mco32

ASKER

Thanks mlmcc,  Never thought of that.

This is all new to me.