Solved

# Running Total

Posted on 2009-04-28
232 Views
Hello,

I am calculating a count of tickets modified by each Help Desk analyst's by using 3 formulas as below. The issue is I have to do the same thing for almost 60 users. So  creating 60*3 = 180 formulas is too much work. Is there an easiest way to handle this?

Thank you
``````@Yemmy Count

WhilePrintingRecords;

if onlastrecord or {HPD_Search_Assignment_Logs.Incident_Number} <> next({HPD_Search_Assignment_Logs.Incident_Number})  then

(

)

@Yemmy Reset

WhilePrintingRecords;

@Yemmy Footer

WhilePrintingRecords;

``````
0
Question by:angel7170

LVL 100

Accepted Solution

One way would be to group by the user name and use summary functioins in the group footer.

You could also use your basic formulas with the reset in the group header and dislay in the group footer.

Using groups you don't have to have variables for each user.

You could also use a crosstab report with the rows being the user and the column being the tickets changed.

mlmcc
0

Author Comment

Thank You!
"You could also use a crosstab report with the rows being the user and the column being the tickets changed."

This works perfectly. What I did is grouped it by field {HPD_Search_Assignment_Logs.Last_Modified_By_2}

But I am wondering if I have complex formulas for count of  "Assigned", "Escalated" by each analyst then how am I going to it.

``````@Assigned Count

WhilePrintingRecords;

Global NumberVar TotalAssigned;

if ({@Assignee History} like "adeni001" or  {@Assignee History} like "NA") and

({HPD_Search_Assignment_Logs.Submit_Date2} in {?Start Date} to {?End Date})

Then

if onlastrecord or

{HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number})

then

(

TotalAssigned := TotalAssigned + 1;

TotalAssigned

)

@Escalated Count

WhilePrintingRecords;

Global NumberVar TotalEscalated;

if {@Assignee History} like "adeni001" and not ({@Assignee History} like {@Assignee})

then

if onlastrecord or

{HPD_Search_Assignment_Logs.Incident_Number} <> next ({HPD_Search_Assignment_Logs.Incident_Number})

then

(

TotalEscalated := TotalEscalated + 1;

TotalEscalated

)
``````
0

## Featured Post

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…