Have you ever desired to store user data directly within a Jet Reports report while in report mode? This innovative feature empowers report viewers to create and edit data seamlessly, a departure from the traditional temporary nature of report mode modifications. By designating specific sections as editable areas using the STORED USER DATA function, you can enable users to input and modify data that persists even after report refreshes or reruns. This capability proves invaluable for scenarios requiring user-defined data input, such as updating sales figures or adding comments. It's crucial to note that proper configuration of the STORED USER DATA feature is essential for determining editable sections and data management.
Procedure
To illustrate this, let's create a basic list of G/L expense accounts with current budget information.
Step 1: Creating the Report
Construct columns for account number, account name, current balance, and budget.
Employ appropriate Jet Reports functions to populate these columns with data.
Step 2: Enabling User Data Input
Introduce a column for projected balance.
Utilise the "Data" keyword to designate cells where users can input data.
Define a unique key for each data point using the "Key" and "Keyname" keywords. The G/L account number serves as the key in this example.
Step 3: Data Persistence
Any modifications made to the projected balance by users will be preserved, even upon report reruns or returning to design mode. This is achieved through the STORED USER DATA functionality.
Conclusion
By effectively utilising the STORED USER DATA feature in Jet Reports, you can significantly enhance report interactivity and data collection capabilities. Empower your users to contribute directly to the report, improving data accuracy and decision-making processes.
onpoint is here to help you with all your Jet reports needs.