?
Solved

quick report 3

Posted on 2001-09-06
4
Medium Priority
?
150 Views
Last Modified: 2010-04-06
Hi there

Giving an expression:

expr1:= a1*b2;

why we can not write

expr2 := sum(expr1.value); // as total
expr3 := sum(expr2.value); // as grand total

best regards.

Med

0
Comment
Question by:medhome
  • 2
4 Comments
 
LVL 6

Expert Comment

by:Jaymol
ID: 6461279
What are you actually trying to do?

John.
0
 
LVL 10

Accepted Solution

by:
Jacco earned 400 total points
ID: 6466540
You can write

expr = sum(a1 * b2)

QR3 does not allow expressions because they did not implement an solver for the order in which expressions are solved. (Excel and MathLab has such a solver). Such a solver is quit difficult to make and allows for circular references like

expr1 = sum(expr2)
expr2 = sum(expr1)

To solve the order in which expressions are solved requires complex analysis of all interdependancies of the expressions.

Aggregate expressions are treated differently in QR3. I think it is even so that an aggregate expression must start with the aggregate function and can nu have other parts. For example:

expr1 = sum(a3) * 5
expr2 = 5 * sum(a3)

Are not allowed to my knowledge.

Regards Jacco
0
 
LVL 10

Expert Comment

by:Jacco
ID: 6466543
In a QuickReport to have total and grandtotal you have to use the "reset after print" property of the aggregate expression.

eGroupTotal = sum(...) "ResetAfterPrint = True" printed on GroupFooter
eGrandTotal = sum(...) "ResetAfterPrint = False" printed on Summary

Regards Jacco
0
 
LVL 17

Expert Comment

by:geobul
ID: 9295666
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

accept Jacco's comment as answer

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

geobul
EE Cleanup Volunteer
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
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…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

593 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