Recent content by Kmccormic

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

Hi LBass: It's fine if groups don't appear when they have no data. Maybe I'm not understanding the selected month end date? Or do you mean switch the parameter to a "choose a month"? How could I get the data to load up from the start of the year to the end of that month? Thank you, Kara

Thank you LBass: I looked at the summaries. I was asked for a report which only displays the month of the date range along with the cumulative total for the year. I agree one which displays sum totals for every month and then a year to date summary total at the end would be much simpler...

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

Hi Everyone: I got it to work. I needed to correct the assigned time in this piece of code to reflect my start time of 8:30. This is a wonderful code, thank you to Raja2008 for posting it earlier! //2 AddDayIfHol/Wknd-Close WhileReadingRecords; DateVar Array Holidays; DatetimeVar Target:=...

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

Thank you Turkbear, thank you LB, both of those options work perfectly! Regards, Kara

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

Thank you LB, thank you CoSpringsGuy: I think I'm lost. I can see how declaring the variables and doing the truncating/remainder portion of the code works and is necessary to get it to display as a result in time format. I don't see how this code says "use only the specified queues" but I did...

Hi LB: I averaging in the group level by a date/time field to get output for each month. I want to know the average amount of time callers wait before they hang up, to get that I divide the wait time (a number field showing the number of seconds) by the number of callers who hung up/abandoned...

Hi LB: I thought they were but I see what you mean. I had thought the: If {iApplicationStat.Application} = "Cust_Svc" then If {iApplicationStat.Application} = "VRU_Transfer" then section would automatically add them together, since in my mind I was saying "only inclde this field for for...

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

Thank you LBass, that works.

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