Report group problem

Kaitsu
Kaitsu Member Posts: 22
I have two tables:
Statement
---------
Statement No
Flight No

Payment
-------
Statement No
Type of Payment
Amount

The tables are linked with Statement No field.
I would like to group the data in the report first with Flight No and then with Type of Payment. For some reason data is also grouped with the link field Statement No. Is there a way to prevent this?

Comments

  • alwaysguna
    alwaysguna Member Posts: 45
    Hi
    Give Flight no in the key for data item table view and add the same in group total fields
    do the same for other data item

    Hope this willl solve your issue

    Regards
    Guna
    Guna