Joined: 31 May 2010
Online Status: Offline
Posts: 1
Topic: Crystal Rpt 2008 - Select Stmt in Report Posted: 31 May 2010 at 8:22am
Select
Sum (WAGE_AMOUNT),EMPLOYEE,PAY_SUM_GRP from QUARTWAGE
where
PAY_SUM_GRP in ('REG','HOL')
GROUP
BY EMPLOYEE,PAY_SUM_GRP
I am using the SQL commands above to summarize the wage amount for each employee based upon a pay group. The commands work in SQL Query but not in Crystal 2008. I need to get a summed wage amount for each employee. Please advise.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 01 Jun 2010 at 2:50am
Set your report to group by Pay Sum Grp and then by Employee.
Use the Insert Summary button for the desired field. Set to SUM and put it on the Employee Group Footer.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum