Search results for query: *

Hi There: Is there a way to have a report show 1 date range of values in the mail report, then a separate date range for a crosstab? Essentially, I want to report on the current month's data, then have a crosstab in the footer with data for the last calendar year for comparison purposes. All...

Crystal Ver. 2008 Thank you in advance for any help you can lend. I’m trying to get a parameter-dependent formula to work to count the number of entries in a month. Then I need to list year to date information on the same report. The parameter is type Date and allows ranged values. What I...

Good Afternoon: I’m trying to calculate the time to resolve tickets during business hours in (hh:mm) format. I can’t seem to get the formula right. I am excluding weekends, holidays, and non-business hours. Tickets can arrive 24x7, and may be resolved outside of business hours. Business...

Good Afternoon: I'm pretty sure I'm missing some syntax error in here. I'm using Crystal 2008. I have 4 fields, I want to display one of the fields when the others are empty (null), then I want to group based on that output, but that comes later. The results only give me output when...

Good Afternoon: I am running into a duplicate row appearing. I need to sum the values of that record without including the duplicate items. I can't use "suppress if duplicated" for the fields (choosing that option for just 1 field doesn't work) because that will suppress other, legitimate...

Hi There: I'm sure there is something simple I'm missing here. I want to take a number field (total number of seconds) divide it by a another field (number of calls) to get an average amount of time per call, displaying in hours, minutes and seconds. I keep getting the error "division by...

Good Afternoon: I'm using a cascading parameter prompt. I've set up the following script: DayOfWeek ({iCDNStat.Timestamp}) in 2 to 6 and {iCDNStat.Timestamp} = {?Enter Date Range} and DayofWeek ({iCDNStat.Timestamp}) = {?Day of Week #} This {?Enter Date Range} allows me to enter a...

Good Afternoon: Having problems getting cascade parameters to work. The parameter doesn't seem to filter at all and I can't think why. Possibly I'm approaching this the wrong way for what I want to accomplish? I'm trying to do trend analysis on call volume, so I'm using cross-tabs in Crystal...

Hi: I'm trying to create a formula to either include only weekdays in a crosstab report, or exclude weekends. I want to trend call volume for staffing purposes. I have my data set up to have the data grouped by date (rows) and hourly by time of day in specified orde where I have sorted all the...