display records even if the long description field is null

[MaximoQ]

I have multiple tables linked together. My failureremark table is linked to my long description table by a left outer join from ldkey to ldkey. I want the long description on the failureremark table to display records even if the field is null. Here's my formula...
{@Plant} = {?Plant} and
Not(IsNull({@Problem})) and
{workorder.targcompdate} in ({?From date} to {?To date})

 

[IanWaterman]

If your long desc is in Workorder table then this filter effectively over rides the left outer join

{workorder.targcompdate} in ({?From date} to {?To date})

change to

(isnull({workorder.targcompdate}) or {workorder.targcompdate}in ({?From date} to {?To date}))

Ian

 

[kenhamady]

The IsNull rule is not a good way to deal with filtering outer joins. It won't work in all cases. This article explains in more detail:

http://kenhamady.com/cru/archives/1489

But it doesn't sound to me like he is even doing an outer join to the WorkOrder table, but is doing it instead to the "FailureRemark" table. MaximoQ, when you go into join properties and look at the top line of the window, is the table with your long descriptions sitting on the right side of the arrow? Do any of the formulas in your selection formula use fields from the Long Description table? Unless you want to move the report to a command you can't usually filter on any fields that come from the optional (outer) table.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/