duplicates

[aussiehedge]

I am trying to count the number of records on a report in the footer of two groups. However i need to count the records with the same job number as one. i cannot group these in a query as all 203 records have different information that cannot be combined.

The two groups are
1/Port of loading
2/Mode

I have counted the records by entering [textgroupcount]=1 in the record header and [textgroupcount] in the mode footer. This works and returns the following

1/port of loading CHINA
2/AIR 4 grouped jobs
2/FCL 1 grouped job
2/LCL 11 grouped jobs
These are made up of 203 records.

Now i need to count the grouped jobs in the port of loading group. i also put the [Textgroupcount] in the port of loading footer and got (11) as the total should be 16

 

[llkhoutx]

You're saying what to do. You're just not doing it correctly. it's hadd to give advise without seeing what you're doing.

Maybe count what you're doing with an external query and use that result on you report. There's lots of ways to skin a cat.