How to create a report only group Totals

edited 6:21AM in FastReport 3.0
Hello.

Im currently showing the records and group them via "jobcode"... Im computing total salaries of every group (by the job code field)... Everthing is well but except the page cound. Report is total 150 page. Can i show only the group totals in this report. I mean i only need the total saalies in footer and group header. How to achieve this.

Regards

Comments

  • edited 6:21AM
    Why are you doing this in a header/footer. You should be doing this in your query. Look at your SQL Manual for things like Count(), Sum(), Min(), Max(). If you are using ADO going to something like SQL Server this is rather easy to do.

    Wayne
  • edited 6:21AM
    Quietman wrote:
    Why are you doing this in a header/footer. You should be doing this in your query. Look at your SQL Manual for things like Count(), Sum(), Min(), Max(). If you are using ADO going to something like SQL Server this is rather easy to do.

    Wayne
    Hello Wayne.

    Yes after the post i have think about that method and do it with success..

    Thank you for proposall...

    Im so busy these days and sometimes my brain is stopping.

    King regards
  • edited 6:21AM
    Yes after the post i have think about that method and do it with success..

    If you are using SQL Server write something that looks like this:

    <span style='font-family:Courier'>
    SELECT worker = (SELECT SUM(salary)
    FROM employee
    WHERE emp_type = 'WORKER'),
    manager = (SELECT SUM(salary)
    FROM employee
    WHERE emp_type = 'MANAGER'),
    janitor = (SELECT SUM(salary)
    FROM employee
    WHERE emp_type = 'JANITOR')
    </span>

    There are several ways to do what you are wanting to do but the problem is you are trying to get Fast Reports to do something that needs to be handled in your query.

    Hope this is clear and helps.

    Wayne


Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.