Expr in Report

Posted on 2005-03-23
Medium Priority
Last Modified: 2010-04-05
How can i make it that a report displays the final total of a table's contents. Like in HireOut table i have a column that displays the entire total of the record, then i want to add all the records' total column and display it.  Like a total sales report.  When i use QRExpr on the QReport tab and make it Sum(tblHireout.totalsales), then when i run pgm, it doesnt give a value.  Using Delphi 5.
Question by:mystramagic
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
LVL 11

Expert Comment

ID: 13611517
There is a problem with positioning your QRExpr on the bands...
You shoul position it on a summary band
LVL 11

Accepted Solution

calinutz earned 150 total points
ID: 13611522
you should paste some code ... maybe dfm too

Author Comment

ID: 13612489
i just have a simple query that joins the primary keys of two tables, because im calling other data in my report as well that is related to it.  then i have 3 bands, title, detail, summary.
On detail is different costs, the datasets set to querytotalcosts.  the report as well
then expr is sum(tblHireout.sales) + sum(tblHireout.extracost) etc.  (adding other costs to this to get the total sales)

Author Comment

ID: 13612600
its ok i have it.  i called hireout in sum expr instead of querytotalcosts
Thanx :)

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

752 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