Recent content by pfheg67

LBass, sorry for the delay but i have been out of the office. I wanted to take the time to thank you for helping me wiht this. You sql stmt worked and I was able to role this into other reports. Thanks again for your diligent efforts. Patrick

LB I think you got it. I have to do some more testing in the am but i will be eternally grateful if this is the resolution. Happy New Year. I will update you tomorrow. Thanks again

my other thought is {table.ResolveOrder} is not read yet so that is why it might be giving us an error. I know when i had tried to using formula's with resolve order it was giving me a message something like "needs to be evaluated later" that in turn had let me to the group selection...

ok - i put this in: (select max(ResolveOrder) from Asgnmnt A where A.CallID = Asgnmnt.CallID) when i got to the 2nd part to put the formula {%Cowner} = {Asgnmnt.CallID} in select expert i get the following message when i try to ok it. "A number is required here." The {Table.CallID} field...

SQL dbase

I am out of the office but I know the 2 tables i am using are Asgmnt and Calllog. They are linked by whatever crystal uses as default link( i would have to verify) and the only linked field is {table.callid} Also - i wanted you to understand my Details listed above is included in GH2 not...

no sweat - thanks again. I will put together the information you requested. Pfheg67

Ok - lets try this again. Category Type Call id Recv Date GH1: GroupName(ex: HELPDESK) GH2: Call id# (ex: 00000300) Detail WIC PC 00000300 11/20/09 what is happenign is the Call id is being pulled under multiple group names. So ticket 00000300 will show...

LB i am working on it. I did some more research last night and found some more specific info in some threads that you had been a part of that might be helpful. I will get back to you asap. I usually am not alloted much time to be working on this so i apologize for the delay in responding Thanks

Slurm, wondering if you ever got this resolved. I am having a similar issue. I want each group to print ie: HelpDesk, Systems, Program, DataComm and then each call id to print under the appropriate group. The issue is some call id#'s appear under multiple groups which should not be the...

Current Open Tickets CallType Category CallID (GH2) Description: WIC (E) PC{calllog.category} Miscellaneous {Calllog.Calltype} 00000102{Calllog.Callid} Description: WIC (E) PC{Calllog.Calltype} PC{calllog.category} 11/20/2009 00000300{Calllog.Callid} Description: WIC (E) PC{Calllog.Calltype}...

Using Crystal XI with ODBC. Trying to create a report that Groups call tickets open for each group. The problem is it is counting tickets multiple times in each group because the call # is not unique. I have 2 GH's GH1 = {Asgnmnt.GroupName} GH2 is {Calllog.Callid} - i have nothing in details...