Graph Problems

[Darrick]

Ok, here is the story. I've got a chart that is based off of a formula in my report. Basically the chart is displaying a agents name and their Connects Per Hour which is a division of a field from my sub report and total number of connects. My problem is that when I divide the time by the connects field on my parent report, it works great. But when I tell the graph to graph that field, I keep getting a division by zero error. Which is weird because I don't get that error while simply displaying the information on my report. However, I put in an If statement to catch the division by zero error.
For example:
If {TimeFromSum} = 0 Then
0
Else {TimeFromSub} / {Connects}

Now the graph only charts 0 for all of my agents. For some reason it thinks that the {TimeFromSub} is always = 0 This however isn't true, in fact this field can never be 0

Please Help,

Darrick
darrick3@yahoo.com

 

[kenhamady]

Can't use shared variables in cross-tabs and charts.

Can you include both created and resolved in one data set, and just count them separately? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[rhammond]

Unfortunately, I don't think I can.

The problem is, I have one set of records that were created in a month period. I select them based on the Create Date field = the month I need.

Then, I have to pull records that were resolved in a month period. They may or may not have been resolved in the same month they were created. So I need to then pull records where the Resolved Date field = the month I need.

Any ideas on how to do this within one query? I'm stumped.

 

[kenhamady]

You could do where:

( Resolved Date field = the month OR
Create Date field = the month )
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[rhammond]

I just tried this. Now my problem is, how do I do a comparison (count) of records created in the month vs. records resolved in the month? Only solution I could find was to use Running Total fields, and then I still can't use them in a chart.

Ack - this is insane!

 

[kenhamady]

Write a formula like:

If Resolved Date field = the month
then 1 else 0

then SUM this to get your COUNT.

Do the same for the other field.
These can be charted. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com