Group on Fields and Report

rbuser

Hi,

I have a Purchase order table.
This table have a field "OrderType" and two other fields "RepairOrder" and
"WarrantyClaim" (check boxes in the application).
The two last fields can have the value "T" or "F".
I want to group the report on these fields.
In other words, if both of the "two other" fields are "F" the group is
"Purchase Order" otherwise the group should be "Repair Order" or "Warranty
Claim" depending on the the fields flag "T" or "F".

Tried to set this on the GetText property but it doesn't work.
Any suggestions?

/Ronny.

nicocizik

Hi Ronny,

Are these "Purchase Order", "Repair Order", or "Warranty Claim" groups
simply a matter of changing the text of a label at the top of the detail
band? Do you wish to assign these actual report groups? I am unclear why
you need to use the OnGetText event to accomplish this. Please elaborate a
little on what you are trying to ulitmately accomplish.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

Yes, I want to group these different order types and print the label with
Phurchase Order, Repair Order, Warranty Claim respectively in the group
band.
The detail band has all the items on each order number.
In other words I want to show all items connected to the different order
types.

I tried with a group on which I change the label text with the labels
OnGet text event.

So the "simple" question is, how can I group records based on the value
of three fields in the table.

/Ronny

nicocizik

Hi Ronny,

Unfortunately there is no way to group on multiple fields in your database.
Have you considered ordering your dataset in a fashion that would allow you
to group on only one of the fields and still get the same result?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Nico,

Might give it a try.

/Ronny