Skip to Content
Former Member
Jul 03, 2007 at 02:55 PM

Missing Data using Select Expert


Post Author: fireman204

CA Forum: General

Fairly new to Crystal, using Crystal 11. I'll do my best to describe my problem, but don't know if I can do it adequately, but here goes.

I have a report with 4 linked tables. I can get all the data with the linking without a problem. A code is entered in a field, and the description for that code is in another table. Within that table, the code is within a particular "category". There are several code numbers within the table that are the same, just the description is different. If I use Select Expert and limit the category, I get the correct descriptions, but not those fields with missing codes. If I don't limit the category, I get all kinds of descriptions that may or may not match. I have the following Basic statement that should handle the missing codes, but it doesn't work at all.

If {EMSAdvanced.complaintcode} = "" Then Formula = "No Complaint Code Entered" Else Formula = {EMSAdvanced.complaintcode}" - "{CodesEMS.descrip}End If

Anybody got any ideas? I've tried to change the joins, and used both left and full outer joins, both enforced both and not enforced. Not sure where to go from here, short of using the "is one of" choice in select expert. If possible, would like to avoid that, because if codes change, the statement would have to change to get an accurate report.

Any ideas are greatly appreciated!