how to pass multiple parameters to a report?

[waely]

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,

[Asgorath]

Hi,
See this example http://www.codeproject.com/Purgatory...parameters.asp
Jorge

[waely]

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

[Asgorath]

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

[vincentg]

this works on VS.Net 2003

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

[waely]

thank you