Processing a Form in a Report

A form is processed and submitted to the server whenever a “submit” action occurs on the form (e.g., 'Submit' button is pressed or an 'onSubmit' script returns “true”). The submission contains a single repletRequest object that includes all form values.

Scripting the onClick Handler

To process the form on the server end, add script to the onClick Handler handler of the Form elements. To do this, open the Form in Report Designer, and follow the steps below:

Select a form element to which you want to add an 'onClick' script.

Note: This is the server-side 'onClick' handler, not the client-side 'onClick' handler described in Creating a Form. You can also edit the server-side 'onClick' handler from the tabbed panel at the bottom of Report Designer window. You can add 'onClick' script to any Form element. (If you add 'onClick' scripts to multiple elements, all of these scripts are executed when the form is submitted, and all have access to the same set of form values.)

Right-click the Form element, and select 'Script' from the context menu. This opens the Script Editor.
Select the onClick tab at the top of the Editor.
Enter the commands to be executed by the report server when the form is submitted. See Server-Side JavaScript below for more details.

More Dashboard Examples

Request a Personalized Demo

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index

Server-Side JavaScript

The server-side 'onClick' script has access to a RepletRequest Object containing all form element values. You can access a particular field value by using the element 'Field Name' as index:

request['FieldName']   or   request.FieldName

Field names must be unique within a form (with the exception of Radio Buttons). If there are multiple “submitting” form elements, use 'request.__eventSource__' to obtain the field name of the element that triggered the submit action. For example:

 if(request.__eventSource__ == 'Choice1') {
    ...
 }
 else if(request.__eventSource__ == 'Button1') {
    ...
 }
 else {
    ...
 }

Note: If the 'onClick' script of a form element on a Parameter Sheet calls the sendRequest() function, the submission from sendRequest() is sent in place of the normal form submission request. If your script modifies element values and needs to refresh the screen, it should call the reprint() or refresh() function. The 'reprint' action causes the report pages to be regenerated without refreshing the data binding. The 'refresh' action forces the report data to be refreshed before the report is reprinted. If the onClick Handler does not change the data or the way the data is bound to report elements, the reprint action is sufficient.

Summary

Style Intelligence offers advanced scripting capabilities that support dynamic report modification without requiring programming. Scripts can be applied to the whole report or to specific elements. Scripts can modify element properties, change data, pass parameters to reports, and more.

More Articles About Reporting

Armament Manufacturer Monitoring Solution - Armament manufacturers operate in a highly regulated and complex environment where precision, efficiency, and compliance are critical. Business Activity Monitoring (BAM) solutions play a vital role in helping these manufacturers manage their operations effectively. Here's how an armament manufacturer might use a BAM solution: 1. Real-Time Production Monitoring Operational Efficiency: BAM solutions provide real-time visibility into the production process, enabling manufacturers to monitor the status of machinery, production lines, and inventory levels. This ensures optimal utilization of resources and minimizes downtime...

BI for Biomedical Engineers - Biomedical engineers utilize business intelligence (BI) applications to analyze various aspects of healthcare systems, medical devices, and biomedical technologies. These applications help them extract insights from large volumes of data to improve patient outcomes, enhance medical device performance, optimize healthcare delivery, and drive innovation. Here are some key areas that biomedical engineers may analyze using a BI application: Clinical Data Analysis: Analyzing clinical data from electronic health records (EHRs), medical imaging systems, and wearable devices to identify trends, patterns, and correlations related to patient diagnoses, treatments, and outcomes. Conducting predictive modeling and risk stratification to anticipate patient health issues, optimize treatment plans, and personalize patient care...

Collection of Database Dashboard Examples - Dashboards offer companies various ways of representing their data. From sales projections, to employee statistics, and even inventory stock, database dashboards are able to easily represent all of the numerical data that your company can hold, into a visually appealing dashboard. This music metrics dashboard example by InetSoft can be easily embedded into applications to help creators find the next hot music genre in certain areas. In the example dashboard, the most important audio features impacting popularity are identified by regression model. Moreover, end user can deep dive into the music fusion by checking simulated decision tree of genre classification...

Dietary Supplement Manufacturer Reports - An analyst at a dietary supplement manufacturer plays a crucial role in gathering, analyzing, and interpreting data to support informed decision-making within the company. The reports created by such an analyst cover a range of aspects critical to the success and compliance of the dietary supplement manufacturing process. Here are key areas that an analyst at a dietary supplement manufacturer may create reports about: Quality Control and Assurance: Monitoring and reporting on the quality control processes throughout the manufacturing cycle...

Obstetrics Practice Dashboards - Identifying Key Performance Indicators (KPIs): The first step was to identify the most relevant KPIs for the obstetrics practice. The clinic focused on the following areas: Clinical Outcomes: Maternal and neonatal mortality rates Rate of Cesarean sections vs. vaginal births Incidence of preterm births Patient satisfaction scores Operational Efficiency: Average patient wait time Appointment no-show rate Bed occupancy rate Resource utilization (staff, equipment, rooms)...

Real Estate Customer Engagement Metrics - An important component of a real estate development project's success is the contentment of its renters and purchasers. A Customer Satisfaction Index (CSI), which is produced from surveys and feedback, is often included in dashboards as a KPI. With the help of this statistic, developers may better understand the client experience and sustain favorable interactions. Lease Renewal Rates Lease renewal rates are a crucial KPI for commercial real estate projects. The dashboard's analytics monitor the proportion of renters who decide to extend their leases. Elevated rates of tenant renewal indicate contentment and may have a favorable effect on the project's overall fiscal soundness...

Previous: Interactive Forms in a Report