Crystal Reports 11 & Stored Procedure Issue?

[blakemckenna]

Ok,

My last post was answered and I figured out how to incorporate a SP into a CR. This report will eventually have multiple SP's in this report. Three of the SP's are almost identical, however, they produce different results as I have already tested it within SQL Server. My problem is that they are producing the same results. I pass 1 parameter from a VB.Net app into the CR. The 3 SP's in question all contain the same parameter...but again, they produce different results according to the query. What could I be doing wrong? I've created 2 of 3 formulas so far. Here is what they look like.


Formula 1
Dim cnt1 as Number

cnt1 = Count ({prcSelectGASR_NewIR;1.groupName})

If cnt1 = 0 Then
formula = "New Incident Requests for " & {prcSelectGASR_NewIR;1.groupName} & ": " & Replace (ToText (cnt1), ".00" ,"")
Else
formula = "New Incident Requests for " & {prcSelectGASR_NewIR;1.groupName} & ": " & Replace (ToText (cnt1), ".00" ,"")
End If



Formula 2
Dim cnt2 as Number

cnt2 = Count ({prcSelectGASR_ClosedIR;1.groupName})

If {prcSelectGASR_ClosedIR;1.groupName} = "" Then
cnt2 = 0
formula = "Closed Incident Requests for " & {prcSelectGASR_ClosedIR;1.groupName} & ": " & Replace (ToText (cnt2), ".00" ,"")
Else
formula = "Closed Incident Requests for " & {prcSelectGASR_ClosedIR;1.groupName} & ": " & Replace (ToText (cnt2), ".00" ,"")
End If

Thanks