Frames - Inclusions, Exclusions & Ignore

[FrunkaBlunka]

Hi,
I am trying to create a report where certain services appear under
headings INCLUDED, EXCLUDED or not at all. I have a thought of a way
to do it with code but it seems like there is any easy solution. Is
there any easy way to do this with a query or do i have to use code?

My table consists of four fields....
QuoteID
Shop Drawings
Scaffold
Site Visit

My form has a frame which looks something like this... (O indicate
unchecked, X indicate checked)
Shop Drawings O IGNORE X INCLUDE O EXCLUDE
Scaffold O IGNORE O INCLUDE X EXCLUDE
Site Visit X IGNORE O INCLUDE O EXCLUDE

I want my report to look something like this....

INCLUSIONS
Shop Drawings

EXCLUSIONS
Scaffold

I am using the default values allocated by the frame in my form:
IGNORE: 1
INCLUDE: 2
EXCLUDE: 3

Does anybody have any easy solution?

Thanks

 

[BruceM]

Try report Sorting and Grouping (View >> Sorting and Grouping). Group by
the field to which the option group (frame) is bound. You can use a group
header or not, depending on the details of how you want the information
presented.
I can't tell how all of this fits into the whole. For instance, is there a
quote table with more information about the quote (customer, date, etc.)?
If so, is the table you described related to the quote table? This may
change how you approach the problem.