How to create a report only group Totals
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
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
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
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