• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3355
  • Last Modified:

QuickReport - Group subtotals

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
henrylim
Asked:
henrylim
1 Solution
 
ITugayCommented:
Inside groups footer.
----
Igor.
0
 
henrylimAuthor Commented:
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
 
ITugayCommented:
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
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
NetoManCommented:
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
 
lgmmCommented:
Enable the reset after print , that is in the properties of the sum field
0
 
henrylimAuthor Commented:
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
 
ITugayCommented:
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
 
henrylimAuthor Commented:
Hi, Igor,

I see.  Thanks again.

Thanks.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now