TABLE FILE EMPLOYEE SUM DED_AMT AND GROSS BY DEPARTMENT BY PAY_DATE ON DEPARTMENT RECAP DEPT_NET/D8.2M = GROSS-DED_AMT; WHEN PAY_DATE GT 820101 ENDThis message has been edited. Last edited by: Kerry,
App Studio Version 8202 windows Platform SQL Server 2008/2012
April 15, 2010, 04:41 PM
GinnyJakes
Open it in the Report Painter, right-click and choose options to style it. Here is a quick one that I did:
TABLE FILE EMPLOYEE
SUM
DED_AMT
GROSS
BY DEPARTMENT
BY PAY_DATE
ON DEPARTMENT RECAP
DEPT_NET/D8.2M = GROSS - DED_AMT;
WHEN PAY_DATE GT 820101;
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=RECAP,
BY=1,
SIZE=12,
COLOR='RED',
STYLE=BOLD,
$
ENDSTYLE
END