if report qty is empty hide all details

[mathanraj76]

Hi..
I have report with all the details
so i use group and sort in the report

How to hide or don't show if my qty and product is empty

for an example

name addr qty product
ryan 123 jln setu 1 fft
joseph 32 jln pr 1 rht
jen 23 jln kow


jen 23 jln kow 2 fhm

the result should be in report
name addr qty product
ryan 123 jln setu 1 fft
joseph 32 jln pr 1 rht
jen 23 jln kow 2 fhm


thanks
mathanraj

[pbaldy]

You can base the report on a query that only includes records you want included.

[mathanraj76]

but my data structure is like this..
i already try in query with using "is not null" but it cannot use for my data structure..

thanks

[pbaldy]

Perhaps a sample db is appropriate?

[June7]

At least post the sql statement of the report query. The WHERE clause should include something like:

WHERE Not qty Is Null AND Not product Is Null