parameter select on detail table

[koolskins]

Crytal 10 running on an Informix database...I am basically selecting header records based on several parameters but have one parameter looking for either ALL, Y or N from a column in a detail table that is outer joined to the master table via this select statement, "(if {?image status} = "ALL" then true else {?image status} = {dc_image_887.active})". However, there isn't a one to one relationship of records between the two tables and I'm only getting records returned where the detail table has a corresponding record. What would be the correct syntax to return any header record as long as there is either a detail record matching the parameter or else no record exists in the detail row?

 

[Turkbear]

Hi,
Try adding the details in a subreport instead of linking to the header table...When you apply criteria to the leftmost table in a left-outer join, the join becomes an EquiJoin instead.

You could Group on some Header field and place the sub in the Details for that Group - All the header records will be returned and all matching details that satisfy the selection formula ( if none, the details for that header record will be empty).




To Paraphrase:"The Help you get is proportional to the Help you give.."