FORMULA FOR SLA

[DJPAN]

Hi

I am a newbie to this crystal Reports.

My report should read 2 tables viz; call and Asgnmnt

The report should display only the no of records satisfying the condition group by RecdDate

Fld name in Tbl call will be
Callid
RecdDate
status


Fld name in Tbl Asgnmnt will be
Callid
RecdDate
SuppGrp
SeqNo

The sql formula would be something like this:

Select Distintcount(*) from Call,Asnmnt where Call.Callid = (Select min(seqNo) CallId from Asnmnt) and Asnmnt.suppGrp = "Help" and Call.status = "done" and Call.Recvdate = @date

It might be simple but I don't know where to start first.

Can anyone help me pleasssssseee....

 

[synapsevampire]

What version of Crystal?

Your SQL looks formed to only return one callid, though there may be more than one row.

You can use real SQL within CR 9, and you can cheat it within CR 8.5 by using an ADO connection and passing through the SQL using Build.

Through Crystal alone (not pure SQL), you might do this by adding a subreport which contains the select minimum (use a Top N or a record selection group by clause).

Consider posting example data and expected output, along with version info., text posts don't allow for specific results.

Hopefully this describes some feasible solutions well enough.

-k