There are three components to executing a Report Grid from Query with Parameters on a page in Arena.
- An Advanced HTML Text module which has a form with parameter input fields.
- A SQL Stored Procedure which uses the parameters.
- A Report Grid from Query module to display the results.
Do you want a custom report (with parameters) that specific users can access which leaves the results in Arena – not using Reporting Services? (Doing this allows you to email, bulk update or do any other core Arena utility with the selected results.) Or do you want to write data back to a custom table quickly and easily to then use it in a report or to drive content for your website? Well, this is the long-long, secret series of posts just for you.
If you’ve ever worked on a page in Arena that has the Person Quick Search module, you’ll notice that it automatically steals the cursor focus. Which also means that it steals the use of the Enter key…at all times.