Toad World® Forums

Question about Report Prompts

I’m new to Toad for Data Analysts but used to other tools like Cognos. I’m developing a fairly simple query and want the user to specify many of the parameters. To do this in Cognos I would create what’s called a prompt page.

As an example, I want the user to be able to specify whether the report should return data on Males, Females, or both.

I appreciate in advance any assistance!

Just use bind variables in your SQL.

Select * from table where col = :a

The presence of the colin will prompt the user for the value prior to execution. This bind variable behavior works throughout the app, editor, query builder and data reports.