Using the QuickReport TQRExpr Component?

I am trying to use the QuickReport TQRExpr Component, to sum a Calculated field column in my dataset on my report.

I have a "Qty" field and a "Price" field, which is multiplied and stored in a calculated field "TotalPrice", using the table's OnCalcField event.

I now want to sum all those TotalPrice's into a GrandTotal using the TQRExpr.

Anybody know what I need. I tried using the expression


however, it seems it is only summing the first record .

LVL 11
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

all you need is a groupband and placed the TQRExpr in the groupfooter
btw. welcome back, shane
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shaneholmesAuthor Commented:
Kretzschmar -  I do not know how to use the groupband and group footer.

I have the following bands in order:
 PageHeader (Company Logo & Address)
 Title (Report Title)
 ColumnHeader (Field Descriptions)
 Detail (Master Table)
 SunDetail (Child Table)
 Summary   (Company Shipping Information)
 PageFooter (Page Numbering)

At the top of the Summary band is where I currently have the TQRExpr component.

ESOFTBG - I have tried your suggestions , SUM(Options.TotalPrice) AND SUM(Options.QTY * Options.Price)  , and I get nothing in return.

shaneholmesAuthor Commented:
Oh well.... because of a Time Constraint, I used a Query

 Select SUM(Qty * Price) as TotalPrice from Options

Which works

Im giving ESOFTBG the points beause his suggestion action pointed me towards the SUM(Options.QTY * Options.Price)  which ultimately led me to my Query indirectly.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.