Friday, March 23, 2012

how to create crystal report

hi all, i need help about seagate crystal report8.5 with vb 6.0.
i want to pass parameter after selecting from combobox and clicking a button
to crystal report.
so that report should be according to value like name selected
from combo box. please any one reply me soon.

i would be thankful for quick and useful reply

thanks
umarCR.parameters(0)="value"|||thanks madhi plz tell me in little detail where to put this code either in vb form or in report parameter field properties. thanking you|||Put that code at VB code where you call the report|||thanks madhi, but when i run by clicking button it asks value of my parameter field (car) and i give it and it works fine.
but when i give code for parameter as
Report.ParameterFields(1) = "corola"
it gives this property not supported or parameter out of range

but i want to give via code by selecting from combo box and then clicking the button how that is possible ?

This is my first project and i need ur help.
thanking you
bye|||Parameter(1) refers to the second parameter
Try this

Report.ParameterFields(1) = '" & combobox.list(combobox.listindex) & "'|||sorry for disturbance but i m unable to find result.
i adder one parameter field in the report and sets the report source as
"select * car where car_make ='" & {?car} & "'"
and in button click event i give

Report.ParameterFields(0) = "' & combo1.text & '"
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Screen.MousePointer = vbDefault

error occur "subscript out of range"

thanking you

No comments:

Post a Comment