Link to home
Start Free TrialLog in
Avatar of wimmeyvaert
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.
Avatar of wimmeyvaert
wimmeyvaert

ASKER

Damn, Bad Font in EE-Comment windows !!

If you want a nicer layout of my question, Paste it into Notepad and make use of Courier (New) - Font

The Mayor.
The answer lies in using TQRGroupbands.
I used 2 of them and everything works fine now.
ASKER CERTIFIED SOLUTION
Avatar of Netminder
Netminder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial