grouping problems

jozicas

I have a report with 2 master data (2 different data sets and ref-cursors). They all have a field WORKER_ID. It is like that:

TICKETSDataSet: WORKER_ID, TICKET_CODE, CATEGORY, CURRENCY, AMOUNT

COUPONDataSet: WORKER_ID, COUPON_CODE, KIND

I need a report that looks like this:

WORKER 1

Tickets:
TICKET_CODE CATEGORY CURRENCY AMOUNT

Coupons:
COUPON_CODE KIND

WORKER 2

Tickets:
TICKET_CODE CATEGORY CURRENCY AMOUNT

Coupons:
COUPON_CODE KIND


What sould I put into GroupHeader condition when there are 2 different datasets inside 1 group. Should I use nay other bands beside GroupHeader and MasterData?

Thanks,

Jozica.

gordk

hi
first
Grouping works with the single result set of a query across joined tables to
give the appearance of a master detail subdetail report. it is dependant on
the order clause of the query. So your report will have a number of group
header bands 1 mdband and a number of group footer bands, and the order
clause of the query should have the fields in the order of the group
header's conditions. Fr does not do the sorting for you you must give it
sorted data.
read the chapter on where and
when the bands print, coupled with the fr25?\demos\reports\frdemo you will
get a better understanding of the concepts. You need to grasp the concept
that master detail and sub detail bands of Fr do not
necessarily have anything to do with the master detail sub detail
relationship of how the tables were originally constructed, they are really
just place holders on the report design page.
read mdband as data of first level
detailband as data of second level (belongs to current rec of first level and so on)
you can use grouping on a table but the table must be sorted in advance.

from your explanation i would connect the tables in a master detail relationship
based on an indexed field and use a mdband and a detail band in the report.
regards