hi,
I have a crystal report that is based on Stored Procedure. in the beginnig the report was called from Enterprise infosotre and runs fine. now, I modified my SP and my report to except parameters but I don't know how to change that in the code. below is my code when calling the report without parameters:
VB Code:
Try If TypeOf Session.Item("CESession") Is Object Then ceSession = Session.Item("CESession") strReportName = "StudyReport" ceEnterpriseService = ceSession.GetService("", "InfoStore") ceInfoStore = New InfoStore(ceEnterpriseService) sQuery = "Select iD, NAME, SI_NAIL From OBJECTS Where SI_NAME = " & "'" & strReportName & "'" ceReports = ceInfoStore.Query(sQuery) If ceReports.ResultCount() <> 1 Then Throw New Exception("The " & "'" & strReportName & "'" & " report cannot be found on the Crystal Enterprise Server") End If ceReport = ceReports(1) CRViewer.EnterpriseLogon = ceSession CRViewer.ReportSource = ceReport CRViewer.DisplayGroupTree = False CRViewer.DisplayToolbar = False Else CRViewer.Visible = False Throw New Exception("no Enterprise session available") End If Catch ex As Exception sMessage = ex.Message Response.Write(sMessage) End Try
my SP expects 4 parameters ProjID,StudyName,SubStudy,Eval
where and how can I set my parameters and pass it to the report?
thanks


Reply With Quote