?
Solved

QuickReport - Group subtotals

Posted on 2000-04-19
8
Medium Priority
?
3,206 Views
Last Modified: 2013-11-22
Hi,

QuickReport is used to produce a grouped list report, but it doesn't generate a subtotal for each group.  How can I do this?
0
Comment
Question by:henrylim
[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
8 Comments
 
LVL 9

Expert Comment

by:ITugay
ID: 2729895
Inside groups footer.
----
Igor.
0
 

Author Comment

by:henrylim
ID: 2729958
Hi, Igor,

I tried the group footer with a QuickReport expression sum(datafield) before, but the returned value was not for the individual group.

Thanks.
0
 
LVL 9

Expert Comment

by:ITugay
ID: 2729980
Did you try  TQRExpr.Reset in your groups headers?
------
Call Reset from any event handler during report generation for the value of an expression to be reset to 0. This is useful when having aggregated expressions and you want manual control of when the calculations should restart.
-----
Igor.
0
Industry Leaders: 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!

 
LVL 2

Expert Comment

by:NetoMan
ID: 2731552
In the groupheader expression put the field that will rule the kind of detailed agrupation (ej, country if you want to group employees by country and count it in footer).

also you have to reset the expression  value in the footer like ITugay say.


NetoMan :)
0
 

Accepted Solution

by:
lgmm earned 20 total points
ID: 2731955
Enable the reset after print , that is in the properties of the sum field
0
 

Author Comment

by:henrylim
ID: 2733673
Hi, Igor,

Thanks for your tips.  I reset the Expression in the group footer, but not as you said in the group header.  I believe it was a typing error.

L. Henry
0
 
LVL 9

Expert Comment

by:ITugay
ID: 2733709
Hi Henry,
You can reset expression before printing group in group header, or after printing group in group footer with the same result. But usually I make initialization before do something, instead after. I hope you too;)
Best regards,
Igor.
0
 

Author Comment

by:henrylim
ID: 2733722
Hi, Igor,

I see.  Thanks again.

Thanks.
0

Featured Post

Independent Software Vendors: 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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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 this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

771 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