Problems displaying "0" data.

[BrettS]

I have three tables - Header, Details, & Budget.
Header and Details have an inner join. Details and Budget have a left outer join.

I want to display Budget.Amount when there are related budget records, however, sometimes there are no budget records. In that case I want to display a 0. The problem is, when there are no related Budget records for a particular Header/Details record, that particular Header/Details record does not show up at all.

 

[dgillz]

Under file, options, make sure you have "Convert null field values to default" checked. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[kenhamady]

What is your selection formula? If it names a field from budget you nullify the outer join. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[BrettS]

Ken
I guess I realized that. Is there any way around this?
Thanks Again

 

[kenhamady]

There aren't any really good options, other than putting in a corresponding budget record for all details. Workarounds include using a linked subreport to get the budget info, or you could take the selection criteria off the budget table and use conditional suppression to not show the records that you don't want. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com