Visual Basic 6 Parameter to Crystal Report 8.5 parameter

ivc1883
ivc1883 used Ask the Experts™
on
I need to do a query to my report, but i use a combo that provide me the autonumber of the drawings from one specific project, and i am declaring  for example


dim rptdib as string

rptdib=combo1.boundtext


the rptdib is the parameter which i want to use to do the query to my report, but i don't know how to do that.

could anyone give me a suggest to do that.


Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
How are you calling the report?

You can do it without a parameter.

If you are using the RDC you can "add" a where clause to the query for the report.

REPORTOBJECT.RecordSelectionFormula = "{QUERYNAME.DRAWINGNUM} = '" & Combo1.boundtext & "'"

A full example is at
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/simpledemo.zip.asp

mlmcc

Author

Commented:
It works, thanks.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
glad to help

mlmcc

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial