Combining running total formulae from two reports 1

[maddyyikes]

Hi,
I have two different reports that have the following outputs: (Crystal Reports 8.5 & Proprietary DB))

First Report: (open incidents)
AgentName No. of Open Incidents Total of all
over SLA Incidents

Mike Parker 2 10

Selection criteria for the first report to check whether open incident is over SLA or not:
({probsummarym1.severity.code} startswith "1" and (datediff("h",{probsummarym1.open.time},currentdatetime)-1>0) or
{probsummarym1.severity.code} startswith "2" and (datediff("h",{probsummarym1.open.time},currentdatetime)-2>0) or
{probsummarym1.severity.code} startswith "3" and (datediff("h",{probsummarym1.open.time},currentdatetime)-4>0) or
{probsummarym1.severity.code} startswith "4" and {probsummarym1.assignment}startswith "EUS" and (datediff("h",{probsummarym1.open.time},currentdatetime)-80>0) or
{probsummarym1.severity.code} startswith "4" and not({probsummarym1.assignment}startswith "EUS") and (datediff("h",{probsummarym1.open.time},currentdatetime)-8>0) )

Second Report: (closed incidents)
AgentName No. of Closed Incidents Total of all
over SLA Incidents

Mike Parker 5 10

Selection criteria for the second report to check whether closed incident is over SLA or not:
({probsummarym1.severity.code} startswith "1" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-1>0) or
{probsummarym1.severity.code} startswith "2" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-2>0) or
{probsummarym1.severity.code} startswith "3" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-4>0) or
{probsummarym1.severity.code} startswith "4" and {probsummarym1.assignment}startswith "EUS" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-80>0) or
{probsummarym1.severity.code} startswith "4" and not({probsummarym1.assignment}startswith "EUS") and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-8>0) )

These two reports work fine individually, however I need to combine both of the above selection criteria and generate a single open/closed report that shall contain the following output:

AgentName *No. of Incidents Total of all
over SLA Incidents

Mike Parker 7 10

*Note: This column represents the total no. of open & closed incidents put together, over the SLA.

The report is an urgent requirement and any help in this regard is highly appreciated. Thanks in advance!
~Maddy

 

[synapsevampire]

Crystal outputs to a proprietary database?

If the databases, and the links are the same, why not use:

(
({probsummarym1.severity.code} startswith "1" and (datediff("h",{probsummarym1.open.time},currentdatetime)-1>0) or
{probsummarym1.severity.code} startswith "2" and (datediff("h",{probsummarym1.open.time},currentdatetime)-2>0) or
{probsummarym1.severity.code} startswith "3" and (datediff("h",{probsummarym1.open.time},currentdatetime)-4>0) or
{probsummarym1.severity.code} startswith "4" and {probsummarym1.assignment}startswith "EUS" and (datediff("h",{probsummarym1.open.time},currentdatetime)-80>0) or
{probsummarym1.severity.code} startswith "4" and not({probsummarym1.assignment}startswith "EUS") and (datediff("h",{probsummarym1.open.time},currentdatetime)-8>0) )
)
or
(
({probsummarym1.severity.code} startswith "1" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-1>0) or
{probsummarym1.severity.code} startswith "2" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-2>0) or
{probsummarym1.severity.code} startswith "3" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-4>0) or
{probsummarym1.severity.code} startswith "4" and {probsummarym1.assignment}startswith "EUS" and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-80>0) or
{probsummarym1.severity.code} startswith "4" and not({probsummarym1.assignment}startswith "EUS") and (datediff("h",{probsummarym1.open.time},{probsummarym1.close.time})-8>0) )
)

-k

 

[maddyyikes]

Thanks much!!! I tried the same thing before but it did not work...guess I placed the parantheses incorrectly! Thanks a million once again!