Hi All,

Can someone please help me with following:

I grouped the records per order and put a summary field on this grouplevel
to count the distinctvalues of field1.

however, it counts also an empty field as 1, but i want to exclude this.

does anybody know how to do this?

the new summary will be put in the Group header.

example:
Group 1 : Order

             FIELD1:
record1:    A
record2:    A 
record3:    B
record4:    C
record5:  
record6:    D
  
distinctcount of FIELD1 on Grouplevel1 and exclude empty fields.

so, value should be 4 in this case.

regards,
Memoli 

you're welcome Dblank.
I appreciate your great input on this forum.

by the way,interesting comment about sub-reports.

I am most of the time creating reports and put it in one
blank report as 'sub-reports'.
no linking or summaries at all.

but is it possible to do the following:

create a mainreport

create sub-report A

create sub-report B

and link them together.(How you should do this i dont know)

and do for example a summary in sub-report A and put this value in the main report?
and also the same for sub-report B?

I use multiple files in database expert but can't find a way to logically
link them together.
example:
Some files are on order level/ some on order-line level/ some on packaging-level etc.
multiple order-lines in one packaging or vice versa.

regards,
Memoli