Hi, before making my question, I'm working with:
VB6
Crystal Reports 9.2.2.693
SQL Server
I need to connect via OLEDB

Ok, I have setup my report all from within the report. The database, the stored procedure, and the fields I'm going to display.

My question is: How can I do to display the report by passing the parameters through VB6?

I already have added Crystal Reports 9 ActiveX Designer RunTime Library and Crystal Reports Viewer 9 to References as well as Crystal Report Viewer 9 to Components.

Hope you can help me figure this out.

Marcelo.

Rport has ParameterFieldDefinitions collection, so you need to set value for every ParameterFieldDefinition in this collection using SetCurrentValue method.

____________________________
If you find the answer helpful, please mark this topic as solved.

Could you please explain to me with some code? I couldn't find any which works with these parameters I described above.

Thanks in advance, Marcelo.

In this section you have many examples how to display report from VB. I believe there is a sticky one that desrcibes in detail.
AS for the parameters, the code should look somethingl ike this

dim prm as ParameterFieldDefinition     for each prm in rpt.ParameterFieldDefinitions         select case prm.name             case "@par1"                 prm.setcurrentvalue somevalue1             case "@par2"                 prm.setcurrentvalue somevalue2             case "@par3"                 prm.setcurrentvalue somevalue3         end select     next

____________________________
If you find the answer helpful, please mark this topic as solved.