Toad World® Forums

can I setup Toad to work with Crystal Reports parameters?

Hey guys, I’m working with a ton of Crystal reports at the moment that are using lots parameters. In the crystal SQL you will see something like select * from team where teamname={?Team}. The “{?Team}” is crystal syntax for the parameter. Now the actual queries I’m working with are massive with tons of parameters in the SQL which is making it very difficult to run in Toad. I have to find and replace all the Crystal parameters with values to run the queries.

So my question is: is it possible to setup “{?*}” as a custom parameter type in Toad so that I will get a popup to fill in the parameter details when I try to run these scripts? I’m on Toad for Oracle version 10.5.1.3.

Many thanks for the help!