Do you have multiple, nearly identical queries that differ only in selection criteria like region, department, and date range? If this is the case, runtime prompts are for you. Runtime prompts help you stay organized by allowing different users and departments to run the same views, but return unique, tailored results.
One way to improve those runtime prompts is with variables. By using variables, you can narrow your scope when pulling data and be as specific as you want to be.
During this webinar, our product expert will share how variables add flexibility to your views, reports, tables and scripts to prompt for criteria at runtime. Beyond creating variables, we will cover:
- Using a default value both as a constant and as an expression
- Adding a filter to a drop-down list
- Demystifying the use of quotes and ampersands with variables
HelpSystems strives to develop powerful business intelligence tools for your organization. The more you know about the finer details, the better set up for success you and your business users will be.
We’ll show you how data access software like Sequel makes it possible for you, your business users, and your executives to quickly, securely access important data—making business intelligence easier than ever.