Search results for query: *

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}...

Using Crystal XIr1 I have defined the following formula Percent Paid: {@sum of code 11 per amp}/({@Sum of code 01 per amp}+ {@sum of code 10 per amp Variable})*100 where @sum of code 11 per amp is: sum({@Paid 11 per code}, {lrunit.cAmpkey}) and @Paid 11 per code is: if ({lrtran.ctrancode} =...

LB, This is not what I am referring to. I was able to locate other threads in which you had provided direction to others. Basically, initializing the variables in the group header, incrementing each running total when the condition is met, and then create a display formula for the variable and...

With my running total using formula: {@Date Range Array Variable} in {lrunitst.start_dt} to {@enddatetime} and {lrunitst.cdesc}='Downtime' I am getting error: A running total cannot refer to a print time formula Details: @Date Range Array Variable and with a distinctcount attempt...

I have a main report that establishes a date array based upon date range parameters (prompted). I am sending the value of the date array to a subreport contained in the details of the main report (Date Range Array Variable). I am evaluating whether the date array value is within the start and...

LB, I went back to where I left off last night. I defined the Date Range Array as you have indicated, removed all other groups from the main report, added and suppressed the date field as you suggested. I created the group based upont he formula. I inserted the subreport and linked the array to...