Writing custom prompts
In the reporting tool I use now I write custom prompts in VB6 (.ocx files) which the user running the report will be prompted to select exactly the information or values they need, and we replace placeholder values in the SQL (we call them prompt tokens) with the user selected values from the prompt everytime the report is ran.In this design we can have as many prompts as we want or return any type of value we want.
I know Reporting Services already comes with simplistic prompts built in so we do not have to write our own, but the prompts are not flexible enough for what we need.I really only need to know if it is possible to custom write our own custom prompts instead of using the default prompts, and if so where can I find some information on this?
Thanks!
