Passing parameters to Crystal

I have started using Crystal Reports (version 5 professional) within a VB6 app. by using a Crystal Control.

I can call stand-alone reports quite successfully, however I need to pass parameters to certain reports programatically (Dates, ID's etc)

I know this is possible if I use the Crystal API, but I don't have experience with this. Is it possible with the crystal control without having to set the quirky Crystal SQL statement ?

I would be very grateful for any sample code you may offer.
Thanks in advance.
John
johnoneillAsked:
Who is Participating?
 
JagarConnect With a Mentor Commented:
Just set the SQLStatement property.  You don't have to use Crystal's quirky syntax you can pass it just a regular plain old SQL statement.  One word of caution make sure that the SELECT part contains all the same fields as the report was created with and in the same order.
0
 
johnoneillAuthor Commented:
Thanks for the advice, but I need to pass parameters (business logic of the supporting/calling program).

I have since discovered how to pass parameters to Crystal.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.