$PBExportHeader$d_graph_salaries_by_department.srd $PBExportComments$2-D Pie Chart: Showing Total Salaries by department using a shared Datawindow Buffer excluding Terminated Employees. release 4; datawindow(units=0 timer_interval=0 color=16777215 processing=1 print.documentname="" print.orientation = 0 print.margin.left = 0 print.margin.right = 0 print.margin.top = 0 print.margin.bottom = 0 print.paper.source = 0 print.paper.size = 0 print.prompt=no grid.lines=0 ) header(height=1 color="536870912" ) summary(height=1 color="536870912" ) footer(height=1 color="536870912" ) detail(height=5 color="536870912" ) table(column=(type=number name=department_dept_id dbname="department.dept_id" ) column=(type=char(40) name=department_dept_name dbname="department.dept_name" ) column=(type=char(20) name=employee_emp_lname dbname="employee.emp_lname" ) column=(type=char(4) name=employee_state dbname="employee.state" ) column=(type=char(1) name=employee_status dbname="employee.status" ) column=(type=decimal(3) name=employee_salary dbname="employee.salary" ) column=(type=date name=employee_birth_date dbname="employee.birth_date" ) retrieve="PBSELECT(TABLE(NAME=~"department~" ) TABLE(NAME=~"employee~" ) COLUMN(NAME=~"department.dept_id~") COLUMN(NAME=~"department.dept_name~") COLUMN(NAME=~"employee.emp_lname~") COLUMN(NAME=~"employee.state~") COLUMN(NAME=~"employee.status~") COLUMN(NAME=~"employee.salary~") COLUMN(NAME=~"employee.birth_date~") JOIN (LEFT=~"department.dept_id~" OP =~"=~"RIGHT=~"employee.dept_id~" )WHERE( EXP1 =~"( ( ~~~"employee~~~".~~~"status~~~"~" OP =~"=~" EXP2 =~"'T' ) )~" ) ) " sort="department_dept_id A employee_emp_lname A " ) group(level=1 header.height=1 trailer.height=1 by=("department_dept_id" ) header.color="536870912" trailer.color="16777215" ) graph(band=foreground height="817" width="1166" graphtype="13" perspective="2" rotation="-20" color="0" backcolor="12632256" shadecolor="8355711" range= 0 border="5" overlappercent="0" spacing="100" elevation="20" depth="100"x="1" y="2" sizetodisplay=1 category="department_dept_name" values="sum(if (employee_status <> 'T' , employee_salary , 0) for graph)" title="" title.dispattr.backcolor="12632256" title.dispattr.alignment="2" title.dispattr.autosize="1" title.dispattr.font.charset="0" title.dispattr.font.escapement="0" title.dispattr.font.face="Arial" title.dispattr.font.family="2" title.dispattr.font.height="1" title.dispattr.font.italic="0" title.dispattr.font.orientation="0" title.dispattr.font.pitch="2" title.dispattr.font.strikethrough="0" title.dispattr.font.underline="1" title.dispattr.font.weight="700" title.dispattr.format="[General]" title.dispattr.textcolor="0" title.dispattr.displayexpression="title" legend="1" legend.dispattr.backcolor="12632256" legend.dispattr.alignment="0" legend.dispattr.autosize="1" legend.dispattr.font.charset="0" legend.dispattr.font.escapement="0" legend.dispattr.font.face="Arial" legend.dispattr.font.family="2" legend.dispattr.font.height="1" legend.dispattr.font.italic="0" legend.dispattr.font.orientation="0" legend.dispattr.font.pitch="2" legend.dispattr.font.strikethrough="0" legend.dispattr.font.underline="0" legend.dispattr.font.weight="700" legend.dispattr.format="[General]" legend.dispattr.textcolor="0" legend.dispattr.displayexpression="category" pie.dispattr.backcolor="536870912" pie.dispattr.alignment="0" pie.dispattr.autosize="1" pie.dispattr.font.charset="0" pie.dispattr.font.escapement="0" pie.dispattr.font.face="" pie.dispattr.font.family="0" pie.dispattr.font.height="1" pie.dispattr.font.italic="0" pie.dispattr.font.orientation="0" pie.dispattr.font.pitch="0" pie.dispattr.font.strikethrough="0" pie.dispattr.font.underline="0" pie.dispattr.font.weight="0" pie.dispattr.format="[General]" pie.dispattr.textcolor="0" pie.dispattr.displayexpression="if(seriescount > 1, series,string(percentofseries,~"0.00%~"))" series.autoscale="1" series.displayeverynlabels="0" series.droplines="0" series.frame="1" series.label="(None)" series.majordivisions="0" series.majorgridline="0" series.majortic="3" series.maximumvalue="0" series.minimumvalue="0" series.minordivisions="0" series.minorgridline="0" series.minortic="1" series.originline="0" series.primaryline="1" series.roundto="0" series.roundtounit="0" series.scaletype="1" series.scalevalue="1" series.secondaryline="0" series.shadebackedge="0" series.dispattr.backcolor="536870912" series.dispattr.alignment="0" series.dispattr.autosize="1" series.dispattr.font.charset="0" series.dispattr.font.escapement="0" series.dispattr.font.face="Arial" series.dispattr.font.family="2" series.dispattr.font.height="1" series.dispattr.font.italic="0" series.dispattr.font.orientation="0" series.dispattr.font.pitch="2" series.dispattr.font.strikethrough="0" series.dispattr.font.underline="0" series.dispattr.font.weight="400" series.dispattr.format="[General]" series.dispattr.textcolor="0" series.dispattr.displayexpression="series" series.labeldispattr.backcolor="553648127" series.labeldispattr.alignment="2" series.labeldispattr.autosize="1" series.labeldispattr.font.charset="0" series.labeldispattr.font.escapement="0" series.labeldispattr.font.face="Arial" series.labeldispattr.font.family="2" series.labeldispattr.font.height="1" series.labeldispattr.font.italic="0" series.labeldispattr.font.orientation="0" series.labeldispattr.font.pitch="2" series.labeldispattr.font.strikethrough="0" series.labeldispattr.font.underline="0" series.labeldispattr.font.weight="400" series.labeldispattr.format="[General]" series.labeldispattr.textcolor="0" series.labeldispattr.displayexpression="seriesaxislabel" series.sort="1" category.autoscale="1" category.displayeverynlabels="0" category.droplines="0" category.frame="1" category.label="Department" category.majordivisions="0" category.majorgridline="0" category.majortic="3" category.maximumvalue="0" category.minimumvalue="0" category.minordivisions="0" category.minorgridline="0" category.minortic="1" category.originline="0" category.primaryline="1" category.roundto="0" category.roundtounit="0" category.scaletype="1" category.scalevalue="1" category.secondaryline="0" category.shadebackedge="1" category.dispattr.backcolor="536870912" category.dispattr.alignment="2" category.dispattr.autosize="1" category.dispattr.font.charset="0" category.dispattr.font.escapement="0" category.dispattr.font.face="Arial" category.dispattr.font.family="2" category.dispattr.font.height="1" category.dispattr.font.italic="0" category.dispattr.font.orientation="0" category.dispattr.font.pitch="2" category.dispattr.font.strikethrough="0" category.dispattr.font.underline="0" category.dispattr.font.weight="400" category.dispattr.format="[General]" category.dispattr.textcolor="0" category.dispattr.displayexpression="category" category.labeldispattr.backcolor="553648127" category.labeldispattr.alignment="2" category.labeldispattr.autosize="1" category.labeldispattr.font.charset="0" category.labeldispattr.font.escapement="0" category.labeldispattr.font.face="Arial" category.labeldispattr.font.family="2" category.labeldispattr.font.height="1" category.labeldispattr.font.italic="0" category.labeldispattr.font.orientation="0" category.labeldispattr.font.pitch="2" category.labeldispattr.font.strikethrough="0" category.labeldispattr.font.underline="0" category.labeldispattr.font.weight="400" category.labeldispattr.format="[General]" category.labeldispattr.textcolor="0" category.labeldispattr.displayexpression="categoryaxislabel" category.sort="1" values.autoscale="1" values.displayeverynlabels="0" values.droplines="0" values.frame="1" values.label="Total Salary" values.majordivisions="0" values.majorgridline="0" values.majortic="3" values.maximumvalue="250" values.minimumvalue="0" values.minordivisions="0" values.minorgridline="0" values.minortic="1" values.originline="1" values.primaryline="1" values.roundto="0" values.roundtounit="0" values.scaletype="1" values.scalevalue="1" values.secondaryline="0" values.shadebackedge="0" values.dispattr.backcolor="536870912" values.dispattr.alignment="1" values.dispattr.autosize="1" values.dispattr.font.charset="0" values.dispattr.font.escapement="0" values.dispattr.font.face="Arial" values.dispattr.font.family="2" values.dispattr.font.height="1" values.dispattr.font.italic="0" values.dispattr.font.orientation="0" values.dispattr.font.pitch="2" values.dispattr.font.strikethrough="0" values.dispattr.font.underline="0" values.dispattr.font.weight="400" values.dispattr.format="[General]" values.dispattr.textcolor="0" values.dispattr.displayexpression="value" values.labeldispattr.backcolor="553648127" values.labeldispattr.alignment="2" values.labeldispattr.autosize="1" values.labeldispattr.font.charset="0" values.labeldispattr.font.escapement="900" values.labeldispattr.font.face="Arial" values.labeldispattr.font.family="2" values.labeldispattr.font.height="1" values.labeldispattr.font.italic="0" values.labeldispattr.font.orientation="0" values.labeldispattr.font.pitch="2" values.labeldispattr.font.strikethrough="0" values.labeldispattr.font.underline="0" values.labeldispattr.font.weight="400" values.labeldispattr.format="[General]" values.labeldispattr.textcolor="0" values.labeldispattr.displayexpression="valuesaxislabel" )
File: d_graph_salaries_by_department.srd
Size: 9519
Date: Tue, 22 Aug 2017 17:30:57 +0200
Size: 9519
Date: Tue, 22 Aug 2017 17:30:57 +0200