Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Using the QuickReport TQRExpr Component?

Posted on 2004-08-23
6
Medium Priority
?
1,110 Views
Last Modified: 2013-11-22
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
0
Comment
Question by:shaneholmes
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 11878208
all you need is a groupband and placed the TQRExpr in the groupfooter
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 11878391
btw. welcome back, shane
0
 
LVL 12

Expert Comment

by:esoftbg
ID: 11878406
SUM(DataSet.TotalPrice)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 12

Accepted Solution

by:
esoftbg earned 375 total points
ID: 11878412
or
SUM(DataSet.Qty*DataSet.Price)
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 11880645
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
0
 
LVL 11

Author Comment

by:shaneholmes
ID: 11887474
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
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

604 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