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.
I’m going to dissect an EventÂ TransactionÂ Export tool I made for our Finance Team for this example.Â This tool has four primary components which I will cover in separate posts.
- An over-view page to see all exported transactions that has a form with filters forÂ dates and event names.
- A small module which inserts new rows to the custom table.
- A pop-up window with input fields to update rows on the custom table.
- Variations on everything above to use this tool for monthly bank reconciliation.
AsÂ a bonus, once I’ve finished up this series of posts, I’ll show how you can use these techniques to drive website content.
All posts related to thisÂ will use the category namedÂ Event Transaction Export ToolÂ so they canÂ be viewedÂ together.Â Let’s get started!