wimmeyvaert
asked on
QuickReports Question ...
Hi Experts,
I'm using Delphi 5 Ent, SQL Server 2000, Windows NT Workstations
I have a DB with following tables (table-definitions) :
Table PICKLIST
Fields ListID
ListType
FromNr
ToNr
Table PICKLIST_DETAIL
Fields DetID
ListID
Group
Upholstery
Nr
************************** ********** ********** ********** *******
Example of data in these 2 tables :
PICKLIST
--------------------------
| 1 PickList 1 |
| 2 PickList 2 |
| 3 PickList 3 |
| ... |
--------------------------
PICKLIST_DETAIL
-------------------------- ---------- --------
| 1 1 Group1 Leather 1 |
| 2 1 Group1 Leather 3 |
| 3 1 Group1 Leather 5 |
| 4 1 Group1 Anholt 6 |
| 5 1 Group1 Anholt 7 |
| 6 1 Group1 Vinyl 9 |
| 7 1 Group2 Leather 10 |
| 8 1 Group2 Leather 12 |
| 9 1 Group2 Anholt 11 |
| 10 1 Group2 Vinyl 2 |
| 11 2 Group1 Leather 1 |
| 12 2 Group1 Leather 3 |
| 13 2 Group1 Leather 5 |
| 14 2 Group2 Anholt 6 |
| .... |
-------------------------- ---------- --------
************************** ********** ********** ********** *******
Now I want to create a Report with following lay-out :
-------------------------- ---------- --------
| PickList 1 |
| |
| Group1 |
| - Leather 1 3 5 |
| - Anholt 6 7 |
| - Vinyl 9 |
| |
| Group2 |
| - Leather 10 12 |
| - Anholt 11 |
| - Vinyl 2 |
-------------------------- ---------- --------
-------------------------- ---------- --------
| PickList 2 |
| |
| Group1 |
| - Leather 1 3 5 |
| |
| Group2 |
| - Anholt 6 |
| .... |
-------------------------- ---------- --------
So, what it comes down to is that I want to be able to combine some detail-records into 1 line on my report !!
I don't have much experience with reports, therefor I beg for your help !
Hopefully there is someone out there that knows the thruth ... ;-)
Oh yeah, I wat to make use of the QuickReports.
I also have Crystal Reports Version 9, but never used it so far in Delphi.
Anyone can help me ?
Best regards,
The Mayor.
I'm using Delphi 5 Ent, SQL Server 2000, Windows NT Workstations
I have a DB with following tables (table-definitions) :
Table PICKLIST
Fields ListID
ListType
FromNr
ToNr
Table PICKLIST_DETAIL
Fields DetID
ListID
Group
Upholstery
Nr
**************************
Example of data in these 2 tables :
PICKLIST
--------------------------
| 1 PickList 1 |
| 2 PickList 2 |
| 3 PickList 3 |
| ... |
--------------------------
PICKLIST_DETAIL
--------------------------
| 1 1 Group1 Leather 1 |
| 2 1 Group1 Leather 3 |
| 3 1 Group1 Leather 5 |
| 4 1 Group1 Anholt 6 |
| 5 1 Group1 Anholt 7 |
| 6 1 Group1 Vinyl 9 |
| 7 1 Group2 Leather 10 |
| 8 1 Group2 Leather 12 |
| 9 1 Group2 Anholt 11 |
| 10 1 Group2 Vinyl 2 |
| 11 2 Group1 Leather 1 |
| 12 2 Group1 Leather 3 |
| 13 2 Group1 Leather 5 |
| 14 2 Group2 Anholt 6 |
| .... |
--------------------------
**************************
Now I want to create a Report with following lay-out :
--------------------------
| PickList 1 |
| |
| Group1 |
| - Leather 1 3 5 |
| - Anholt 6 7 |
| - Vinyl 9 |
| |
| Group2 |
| - Leather 10 12 |
| - Anholt 11 |
| - Vinyl 2 |
--------------------------
--------------------------
| PickList 2 |
| |
| Group1 |
| - Leather 1 3 5 |
| |
| Group2 |
| - Anholt 6 |
| .... |
--------------------------
So, what it comes down to is that I want to be able to combine some detail-records into 1 line on my report !!
I don't have much experience with reports, therefor I beg for your help !
Hopefully there is someone out there that knows the thruth ... ;-)
Oh yeah, I wat to make use of the QuickReports.
I also have Crystal Reports Version 9, but never used it so far in Delphi.
Anyone can help me ?
Best regards,
The Mayor.
ASKER
The answer lies in using TQRGroupbands.
I used 2 of them and everything works fine now.
I used 2 of them and everything works fine now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
If you want a nicer layout of my question, Paste it into Notepad and make use of Courier (New) - Font
The Mayor.