Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Problem w/Sorting on Master/Detail datasets

edited October 2001 in General
I have a Master/Detail consisting of CUSTOMER and ORDERS tables and I have
created a report/subreport to match the data.
My data files have the following CUSTOMER_ID values.

When the report prints, it will correctly print the first two invoices, put
all orders for customers from A-MED INC to ALLEN PROV onto the A-MED INC
invoice similar to the following. Then invoices following ALLEN PROV are
printed correctly. The temporary solution has been to remove the dash from
the A-MED INC CUSTOMER_ID value and they will print correctly.

CUSTOMER INVOICE
A & E INC---------A & E INC
A CARING M-----A CARING M
A-MED INC-------A-MED INC
A PLUS MED
A1 OXYGEN
... many others ...
ALLEN PROV
A PLUS MED
A1 OXYGEN
...many other...
ALLEN PROV
AMERI MED------AMERI MED
...many others correct
This discussion has been closed.