?
Solved

QuickReports Question ...

Posted on 2003-02-28
3
Medium Priority
?
357 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
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

569 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