BradCustom
IS-IT--Management
Hi all,
The chart is on the main report and presently is in the Report Footer. I also had it in the Report Header. It's a simple bar chart.
The "Change Of" is Work_Center.Work_Center
The "Show value(s)" is @WC Utilization % and is not summarized
Main Report
//WC Utilization %
{@PassWCHours}/{@CapicityHoursWeekDay}*100
Main Report
//PassWCHours
whileprintingrecords;
shared numberVar WCHours;
WCHours
//Subreport formula PassWorkCenterHours
whileprintingrecords;
shared numbervar WCHours := if isnull ({@HoursWorked}) then 0 else Sum ({@HoursWorked}, {Transaction_Detail.Work_Center})
Main Report
//CapicityHoursWeekDay
if GroupName ({Work_Center.Work_Center})="quality" then (({@WeekDaysForDateRange}*9)*3)+ ({@SaturdaysForDateRange}*5) else
if {Shift.Shift_Name}="NIGHT4PM" then ({@WeekDaysForDateRange}*18)+ ({@SaturdaysForDateRange}*5) else
({@WeekDaysForDateRange}*9)+ ({@SaturdaysForDateRange}*5)
Regardless of where I place this chart all I get is the Work_Centers the Utilization percentage doesn't chart. Does anyone have any ideas.
Thanks for your help!
I'm having an issue charting the % of Utilization on my report in Crystal 2011 using an SQL 2008 database
The chart is on the main report and presently is in the Report Footer. I also had it in the Report Header. It's a simple bar chart.
The "Change Of" is Work_Center.Work_Center
The "Show value(s)" is @WC Utilization % and is not summarized
Main Report
//WC Utilization %
{@PassWCHours}/{@CapicityHoursWeekDay}*100
Main Report
//PassWCHours
whileprintingrecords;
shared numberVar WCHours;
WCHours
//Subreport formula PassWorkCenterHours
whileprintingrecords;
shared numbervar WCHours := if isnull ({@HoursWorked}) then 0 else Sum ({@HoursWorked}, {Transaction_Detail.Work_Center})
Main Report
//CapicityHoursWeekDay
if GroupName ({Work_Center.Work_Center})="quality" then (({@WeekDaysForDateRange}*9)*3)+ ({@SaturdaysForDateRange}*5) else
if {Shift.Shift_Name}="NIGHT4PM" then ({@WeekDaysForDateRange}*18)+ ({@SaturdaysForDateRange}*5) else
({@WeekDaysForDateRange}*9)+ ({@SaturdaysForDateRange}*5)
Regardless of where I place this chart all I get is the Work_Centers the Utilization percentage doesn't chart. Does anyone have any ideas.
Thanks for your help!