×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating a chat on passed value

Creating a chat on passed value

Creating a chat on passed value

(OP)
Hi all,
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!

RE: Creating a chat on passed value

Charts happen before subreports so you can't really chart on a formula that involves shared variables coming from subreports.

There is a workaround that works in some cases. You do the calculation and chart in the subreport:
1) Go into the subreport that currently calculates the shared variable
2) Add a parameter to that subreport called CapicityHoursWeekDay
3) Use that parameter to do the main report calculation, but in the subreport (without variables).
4) Use that calculation do the chart in the subreport.
5) Link the new subreport parameter to the formula in the main report

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks
http://www.kenhamady.com/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close