Solved

QuickReport - Group subtotals

Posted on 2000-04-19
8
2,981 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
8 Comments
 
LVL 9

Expert Comment

by:ITugay
Comment Utility
Inside groups footer.
----
Igor.
0
 

Author Comment

by:henrylim
Comment Utility
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
Comment Utility
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
 
LVL 2

Expert Comment

by:NetoMan
Comment Utility
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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Accepted Solution

by:
lgmm earned 10 total points
Comment Utility
Enable the reset after print , that is in the properties of the sum field
0
 

Author Comment

by:henrylim
Comment Utility
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
Comment Utility
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
Comment Utility
Hi, Igor,

I see.  Thanks again.

Thanks.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now