Recent content by Oscar115

I am using Crystal Reports 2008. In my report, I have a line graph chart that shows the CPU usage percent per month, 6 months is actual values and 6 months are forecasted values. My line graph shows the CPU values per months/year (group of dates-times by month) sequentially (Mar-12, Apr-12...

I am needing to graph the average cpu usage for 12 months. I am graphing 3 different types of servers, Application, Web, and database along with After Hours average and business hours, 6 line graphs in one graph/chart. 6 months of the line graphs are an actual average and the next 6 months are...

My selection criteria for the report is as follows: not ({@Account #} in ["480000", "759000"]) and {glacct.cacctid} like (totext({@Fund Number})+"*") and {glcatg.ccatgtype} like ["*Expense*", "*Other Revenue*", "*Revenue*"] My intention with the array is to compare each value of fundnumber...

Hello LB, The formula 'Fund Number' was given initially. 'fundnumber' is the name of my array. Let me know if this is not what you were wanting to reference. Thanks, Oscar115

Hello LB, This is my selection formula as the fund number is only the beginning part of each account I need to work with. not ({@Account #} in ["480000", "759000"]) and {glacct.cacctid} like (totext({@Fund Number})+"*") and {glcatg.ccatgtype} like ["*Expense*", "*Other Revenue*", "*Revenue*"]...

I am using CR XI. I have a parameter AMP defined which can have multiple values. At the current time to test my array set up, my values for the AMP parameter are: 501, 502, and 510 (in this order) . ubound{?AMP} within the array formula is returning the correct value of 3. However my array is...

Thanks LB. I did as you suggested and the value is not correct. I do appreciate your suggestion. Oscar.

LB, I have created a formula to get the distinct count and inserted it in the crosstab, but the column total was still an issue. This is the formual I used: distinctcount({womain.nwnumber},{lrunit.cAmpkey}) Below is the {@Completed} formula (date complete is not empty...

LB, field to summarize: womain.nwnumber type of summary: Distinct Count Evaluate, Use Formula: {@Completed} = False Rest on Change of Group: Group #2: lrunit.cAmpkey - A Resetting Group: Yes, my rows are the Ampkey values. Yes, I am expecting column totals to sum the counts just as the row...

I have defined the following formula for the record count: distinctcount({womain.nwnumber},{lrunit.cAmpkey}) This gives me the correct row counts. However no matter what I set the summarized field in the cross tab to average, maximum, minimum, weighted average to get the cell values to be...

The sum for all the rows are correct as well as the grand total for the rows(last column). The running totals is actually a district count of records, rest on a group change.

The values being inserted into the report are running totals/counts. As a result, I have no option to choose a summary type.

I am using Crystal Report XI Rel 1. I have created a report with a cross tab. The grand totals for the rows are correct. However the grand totals for the columns are not correct, the vertical grand total per column is resulting in the last non-zero value in the column of values. I have a...

Thanks LB, I appreciate the information!

Crystal XI I have a subreport. The subreport returns a shared numbervar: shared numbervar sumofcode10peramp; sumofcode10peramp := sum({@Billed 10 per code},{lrunit.cAmpkey}) where {@Billed 10 per code} is if ({lrtran.ctrancode} = '10' and {lrtran.crefno} startswith {@Month Number Description}...