passing a parameter value to Oralce Query

[gayadeen]

Hello,

How do you pass the user's information to your SQL query when developing your Crystal Reports? I know how to pass paramater values to a PL/SQL procedure and to a SQL query but when I implement my SQL query into a Crystal Report, I have no idea how to do this. Can I get some help?

 

[TedLiu]

Hi,

First of all, you need to create parameter fields to pass the values you need, then go to report tab >> select expert to create select statements.

After finish, you can take look in show sql query and edit selection formula, Crystal Report combine them to generate recordset.

cheers!

Ted

 

[gayadeen]

Ted thanks a lot, it works!