How to create a report only group Totals

Comments

• Quietman

  June 2006 edited 7:27AM

  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
• ikutluay

  June 2006 edited 7:27AM

  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
• Quietman

  June 2006 edited 7:27AM

  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