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

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

Thank you LBass! That worked perfectly. I notice you post many solutions here, thank you for your time and patience! I, and I'm sure everyone else here, really appreciate it.

Here it is: DayOfWeek ({iCDNStat.Timestamp}) in 2 to 6

Thank you LBass: I will try to separate my concerns out in the future. I'm happy to focus on the Parameter or filtering issue for now. I was thinking it was best to use a cascade parameter to filter {Timestamp} by date range then by day of week. I couldn't get the first pass to work...

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