Getting Started with New Report Creation

To create new reports, your profile option Blitz Report Access must be set to either Developer or System. This profile setting is necessary because it makes the Setup button visible on the Blitz Report run window, which opens the setup interface.

The basic steps involve five key actions: 1) You must enter a unique report name and an optional description. 2) You then enter the main extraction SQL query. 3) Next, you define optional parameters along with their corresponding SQL text or WHERE clauses. 4) You must test the report thoroughly by clicking the Run button. 5) Finally, you set up the user access rights (Assignments) to make it available to business users.

The report extraction SQL must start with either select or with. If you enter the SQL directly through the form, the input is limited to 32767 characters. For queries larger than that limit, you must use the Upload Large SQL functionality from the tools menu.

A new version number is added and stored automatically only for each report SQL update. Other setup modifications, such as changing the report name, description, or parameter settings, are not tracked in the version history.