Search results for query: *

I am using Crystal 8.5 and need assistance with a formula. I am trying to create a report that displays helpdesk calls grouped by assignment. There are many assignment groups in this company, but I only want to see 3 groups: Calls closed on Initial (in other words, calls not escalated) Calls...

Wease7, if you read this, i'm curious as to how you made out w/the install and aftermath. I am currently using 8.5, thinking of going to 11... Christine

i apologize... i'm having a problem with the @diff formula, particularly the {table.group} piece... i don't understand what should be there... you mean something like this? sum({@Closed},GroupName ({incidentsa3.assignment})) - sum({@Other},GroupName ({incidentsa3.assignment})) sorry :(

I have a report that displays total calls logged by a Hotline, grouped first by Month, then Assignment (where the calls were escalated to). The first assignment group listed is 'Closed on Initial' (calls closed right away). The remainder assignment groups display below that. So it looks like...

Heeeyyy.... how come my mail didn't notify me you wrote. hmmm... Good news, I figured out what i was doing wrong. Instead of making my record selection on the Group 'Assignment', I made the selections on the COI formula I'd created and dragged over to where the Assignment Group was posted...

Thank you for your quick responses. The problem still exists. My formula for 'Closed on Initial' (@COI) works by itself and your suggestion about the record selection also works by itself. However, when i use the two sets of criteria together, any kind of record selection where I list even...

Ok, this is what is happening. Right now I have 2 sets of criteria in this report: I have the formula I first mentioned that gives me 'Closed on Initial Calls'. I also have the criteria you had me post in the Report | Edit Selection Formula | Record area. Your suggestion worked; the groups...

I'm sorry, that does not appear to be working correctly. Was I supposed to create a new formula (which I did) or should that be part of my old formula? As a new formula, what it displays now (next to the group name) is True or False. Thanks for your patience, I am a novice at this.

I have created a report displaying calls logged to a Helpcenter. The calls are grouped by assignment. Calls closed immediately by the Helpcenter are listed first as 'Closed on Initial'. I use the following formula (from lbass) to get this info: If isnull ({incidentsa3.assignment}) or...

you guys are a wonderful. thank you thank you thank you.

When I use the corrected formula from kskid, it seems to work (thank you!). LBass, when i use your last suggestion (just to compare), i get the error 'remaining text does not appear to be part of the formula'. I probably have it in the wrong place.... a. What is the difference between your...

Thank you, but the formula is not working correctly. Calls not closed are still displaying w/no timeframe and the timeframe is off on calls that *are* closed, i.e. Call#: Status: Opened: Closed: Duration: 123 closed 2/20 22:23 2/20 22:23 1 day, 12 hrs, 7 min 456 updated...

Thanks to both of you for the quick response. The formula works perfect for calls that are closed. But I need to include the same kind of information for calls still open (sorry, I forgot to mention that detail earlier). i *think* the formula would say something like this: if...

I would like to display the amt of time passed between a call being opened, then closed. I would like this displayed in days, hrs, minutes: (i.e., 2 days, 3 hrs 10 mins) i found the (wonderful!) formula posted in faq767-3543, so i'm halfway there; i just need help fine-tuning. Below is that...

lbass thank you for this, i have taken this verbatim and tried creating the running total piece as you suggested. Below is an excerpt from above. I have marked in caps (at the very bottom) where i'm having the problem: "First, you could create a series of running totals that define each "cell"...

Thank you everyone, I am asking assistance once again with this same report. My report currently displays the total # of calls logged by the hour. It is then grouped into calls that were fixed immediately and calls that were escalated. Next to each sum, i have it displayed in % also. For...

This is informational for myself so just respond if you have the time... but i'm trying to understand these formula's so i don't have to ask again... This formula you had me use: weekdayname(dayofweek({table.date}),true) i went into Crystal Help to see if i could try to understand it better...

YOU ROCK!

Can i pls use this same thread to ask assistance w/the second part of this report. I need to add the total calls specific to each day of the month,i.e. Week 1: Mon 102 calls Tues 400 calls Wed 500 calls Week 2: Mon 208 calls Tues 300 calls Wed 100...

Thank you it worked! I am a rookie and never used crosstab before.