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

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

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

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

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

Using Crystal XI, I would like to group my data for each date in the date range. This is something I have never done nor have I worked much with crystal arrays, just trial and error. I have defined a datetime date range parameter, Date Range, using any date range. This instance my date range is...

I have been asked to retrieve a date value from a string db field, field name is {HCOMMENT.CLOB} A sample string value looks like the following: LEASE APPT SCHEDULE BY PHONE / APPT IS FOR 2/17/2010 2:30PM. I am attempting to get the date 2/17/2010 from this string. I have defined the...

For some reason I have a difficult time creating a crosstab formula that can be inserted into the crosstab. An apartment complex's accounting system, There is a description field dstatusno that indicates the month the the rent/payments/adjustments are associated with, example 02Rent(February...