how to pass multiple parameters to a report?
hi,
I have a report that works fine and gets me all data. I need to integrate this report to a vb.net application and instead of getting all the records I will need to pass 2 different paramters (ie, Project_ID and Location) through VB.
the Project_ID can be only one or few but the location in only one. what should I change in my report so it expects these paramters?
sample code or pointing into the right directions would be very helpful
thank you,
Re: how to pass multiple parameters to a report?
Re: how to pass multiple parameters to a report?
actually I was looking for solution at the Crystal report end. my report runs and gets all data in the table. what should I change in the report so it looks for certain paramaters(Id)?
thanks
Re: how to pass multiple parameters to a report?
In vb.net its easy in the open the field explorer window of the report.
left click on Parameter Fields right-click and select NEW and a window popup for you to create a new parameter.
Jorge
Re: how to pass multiple parameters to a report?
this works on VS.Net 2003
VB Code:
Dim oCrystal As New rptYourCrystalReport
Sub SetCRParameters(ByVal oCrystal As CrystalDecisions.CrystalReports.Engine.ReportClass)
With oCrystal
.SetParameterValue("prName", "Vincent")
.SetParameterValue("prAccountNo", "12345")
End With
End Sub
Re: how to pass multiple parameters to a report?