🚀 go-pugleaf

Hi,

I need help on how to make a Report with TQReport.
All data is stored in *one* table, and this is the
imaginary layout:

------------------------------------------
ID  F1      F2     F3      F4      F5
------------------------------------------
ID1 FIELD11 AAAAAA FIELD13 FIELD14 FIELD15
ID2 FIELD21 BBBBBB FIELD23 FIELD24 FIELD25
ID3 FIELD31 BBBBBB FIELD33 FIELD34 FIELD35
ID4 FIELD41 AAAAAA FIELD43 FIELD44 FIELD45
ID5 FIELD51 CCCCCC FIELD53 FIELD54 FIELD55
ID6 FIELD61 BBBBBB FIELD63 FIELD64 FIELD65
ID7 FIELD71 AAAAAA FIELD73 FIELD74 FIELD75
ID8 FIELD81 CCCCCC FIELD83 FIELD84 FIELD85
ID9 FIELD91 CCCCCC FIELD93 FIELD94 FIELD95

I want the Report to look like this:
(Grouped by F2, and further, if possible,
sorted by the value of ID)

AAAAAA
-----------------------------------
ID1 FIELD11 FIELD13 FIELD14 FIELD15
ID4 FIELD41 FIELD43 FIELD44 FIELD45
ID7 FIELD71 FIELD73 FIELD74 FIELD75

BBBBBB
-----------------------------------
ID2 FIELD21 FIELD23 FIELD24 FIELD25
ID3 FIELD31 FIELD33 FIELD34 FIELD35
ID6 FIELD61 FIELD63 FIELD64 FIELD65

CCCCCC
-----------------------------------
ID5 FIELD51 FIELD53 FIELD54 FIELD55
ID8 FIELD81 FIELD83 FIELD84 FIELD85
ID9 FIELD91 FIELD93 FIELD94 FIELD95

I have no clue of how to start or what SQL to use
for this.

Any help would be appriciated:

   * What SQL to use
   * What related QR components to use

Till now I made only the most simple Reports with QR.

Do you think it would be smart to make a Temporary
Table which will Hold only the values of F2:

   SELECT * FROM MY_TABLE GROUP BY F2

... and further work with two tables insted of one?

-- 
Best regards,
Vladimir Stefanovic