Print Page | Close Window

Crystal Rpt 2008 - Select Stmt in Report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10144
Printed Date: 05 May 2024 at 1:21pm


Topic: Crystal Rpt 2008 - Select Stmt in Report
Posted By: cjord
Subject: Crystal Rpt 2008 - Select Stmt in Report
Date 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.

-------------
cjor


Replies:
Posted By: FrnhtGLI
Date 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.

-------------
|< /\ '][' ( )


Print Page | Close Window