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

  SUM(TotalPrice)

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

Shane
LVL 11
shaneholmesAsked:
Who is Participating?

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

x
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.

kretzschmarCommented:
all you need is a groupband and placed the TQRExpr in the groupfooter
kretzschmarCommented:
btw. welcome back, shane
esoftbgCommented:
SUM(DataSet.TotalPrice)
CompTIA Cloud+

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

esoftbgCommented:
or
SUM(DataSet.Qty*DataSet.Price)

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.

Shane
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.


Shane
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
Delphi

From novice to tech pro — start learning today.