I assumed your were joining on the account number and since that was not in the GL it would be null for that outer join.
basically what I would do is place all of the fields on the detail row and then use those to figure out what values exist and don't (after your joins were applied). From there you should be able to tell which fields you can use to cue from. Likely something like this:
if isnull({pmf.pmf_display}) then
(
If table.pmf_id='AGG' then 'Aggr' else if table.pmf_id='CRN' then 'Crane'
)
else {pmf.pmf_display}
Edited by DBlank - 26 Jan 2012 at 6:31am
IP Logged
