you mean dont use tables in the DE of my ReportS?

>You should always let a cursor drive a report, and not a table directly.

>Select somefields from yourtable into cursor curReport where ...
>If _tally>0
>   Report form...
>Else
>   Messagebox('No match')
>Endif

>
>>Hello!
>>i have this form with two option groups so i use the two of them to help me formula a report
>>name OG status and OG design both hav four option groups
>>
>>so my code is somethin like this
>>

>>Do case
>>      case thisform.OGstatus.value=1
>>                  Clientstat="A"
>>      case thisform.OGstatus.value=2
>>                  Clientstat="b"
>>      case thisform.OGstatus.value=3
>>                  Clientstat="c"
>>      case thisform.OGstatus.value=4
>>                  Clientstat="d"
>>&&A,B,C and D being values in a table
>>endcase 
>>
>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=1
>>report form report1 for vclient.acc=clientstat preview
>>
>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=2
>>report form report1 for vclient.acc=clientstat preview
>>
>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=3
>>report form report1 for vclient.acc=clientstat preview
>>
>>Case thisform.ogstatus.value<5 and thisform.ogdesign.value=4
>>report form report1 for vclient.acc=clientstat preview
>>

>>this works fine. but just that i cant think of a statement in the event there is no A,B C or D in the data base. SO if i select OGStatus and the table has no "A" the report only flashes :( im trying to think of a statment to stop that