Search results for query: *

MrBillSC Thanks a lot for your suggestion. I've worked on various reports stemming from your idea. One thing I've been having trouble with is narrowing down the ending status to a date range. The report should show items that went to an end state (for example COMPLETED) during a certain date...

By the way, this is the actual code I put into the report: not ( {WA5U999S.EVENT_DATTIM} > CurrentDate-21 and {WA5U999S.WRKTYPE}= "COURTESY" and {WA5U999S.STATCD} in ["INCOMPLETE","REVIEWED","COMPLETED"] and previous({WA5U999S.WRKTYPE}) = "COURTESY" and previous({WA5U999S.STATCD}) in...

I apologize, I had the technical info in my first draft, then deleted them by accident in subsequent ones. I'm using crystal reports 8.5 on WindowsXP connecting to SQL tables. The only question I have for this is if I put the fields in the footer where would I put the group totals? I believe...

Hello and thanks in advance for reading through my question. I'd like a crystal that finds end events ["INCOMPLETE","REVIEWED","COMPLETED"] and compares them to an immediately previous event["REVIEW","INCOMPLETE","REJECTED"]. If the previous event is in that list then the report would show the...

That would work if I just wanted to count the account numbers that went from research to processed. But I need it loose enough to count multiple times if it goes back out of processed back to research and then back to processed by the same person or different person.

I've been working on a report that takes data in the following format: Account Number DateTime Worktype Queue Status USERID The database tracks everything that's done to an item as it gets routed through the company until it's finally resolved. So we may have: 10001 11/11/05 12:00:00PM...