Grouping data

[thhakala]

I have a table that has several true/false -fields among other fields. Example:

ID TF1 TF2 TF3 TF4 ...
1 true false true true ...
2 false false true false ...
3 true true false false ...

I would need a report in which the data is grouped by those true/false fields. Example:

TF1:
1
3
TF2:
3
TF3:
1
2
TF4:
1


Any ideas how to do this without changing the table structure?

 

[Rich@ITTC]

Hi thhakala

I don't think you can do what you want within a straightforward report and grouping set up, as this would mean repeating the same record within various groups.

However, why not set up various subreports - so you would have a subreport that was based on TF1 followed by a subreport based on TF2 etc. These subreports would then all be embedded into a main report.

HTH

Rich Gorvin

[This message has been edited by Rich@ITTC (edited 07-20-2001).]