Link to home
Start Free TrialLog in
Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Crystal Reports sub report link

I have a sub report that has fewer records than the main, is it possible to change the link so it returns null but still shows the main report data
(Like a right join in a query)
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Please clarify. Perhaps provide a concrete example of the data you need to show and how you are currently linking the subreport to the main report.
Avatar of HKFuey

ASKER

OK, for example: -
The Main report is a Customer Statement
The sub report links to a table with customer email addresses

The link between the 2 is CustomerCode, but this may not always exist in the sub report data.

My question is: if the sub report has no data will data still show on the main report?
ASKER CERTIFIED SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

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
SOLUTION
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
SOLUTION
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 HKFuey

ASKER

Thanks for the help, I am clearer now!