?
Solved

QuickReports Question ...

Posted on 2003-02-28
3
Medium Priority
?
353 Views
Last Modified: 2013-11-22
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.
0
Comment
Question by:wimmeyvaert
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Author Comment

by:wimmeyvaert
ID: 8041395
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.
0
 
LVL 6

Author Comment

by:wimmeyvaert
ID: 8200798
The answer lies in using TQRGroupbands.
I used 2 of them and everything works fine now.
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 8201022
User resolved; points refunded and question closed.

Netminder
EE Admin
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month9 days, 11 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question