Introduction to Report Scripting with Style Intelligence

Many reporting environments require dynamic report customization and implementation of specialized business logic. These needs can range from simply changing text colors based on field values to creating hyperlinks and drilldowns between reports. Style Intelligence provides a complete scripting environment to support such dynamic report behavior.

The Style Intelligence scripting language is based on the ECMA-262 (JavaScript) standard. The scripting environment provides full access to all report elements, and can be used to perform actions on report initialization and loading, as well as handling ongoing user interactions.

The following sections introduce you to the basics of JavaScript programing, and explain how to apply JavaScript in the reporting environment. Since there are many publicly available JavaScript resources, the Report Scripting Guide concentrates mostly on the Style Intelligence host environment, and provides extensive examples of report scripting.

Introduction to JavaScript Programming

The purpose of this section is to provide a broad overview of JavaScript programming, and to explain how JavaScript works within reports.

The JavaScript Language

Netscape originally introduced JavaScript as the scripting language for its Navigator web browser. This scripting language allows code to be embedded in HTML pages and executed inside a browser, which acts as the host environment for the scripts. The browser exposes HTML page elements and browser controls to the scripts as host objects and functions. By manipulating these host objects, JavaScript is able to control the behavior of the browser and add interactivity to the web pages.

Since the release of Netscape Navigator 2.0 and Microsoft Internet Explorer 3.0, JavaScript has established itself as the standard browser scripting language. Subsequent standardization efforts have produced the specification known as ECMA-262, which is the standard implemented in Style Intelligence.

As a standardized scripting language, JavaScript provides an excellent foundation for report scripting needs. Its origin as a web scripting language makes it ideal for the reporting environment. The integration of JavaScript with Style Intelligence therefore combines two powerful paradigms for report generation and gives developers maximum flexibility in controlling reports and user interactions.

More Articles About Reporting

Complex BI Applications - Now let's talk about why are BI applications still quite complex? Well, the crux of the matter is that there is a big difference between data and information. Take for example the banking crisis, why could banks not foresee the crisis? They had all the data, but not the information. That's precisely what business intelligence and analytics are all about. It is about translating that raw and meaningless data, those bits and bytes that you can't really make sense by looking at them in raw form. You need to translate data into meaningful, insightful, useful information that can help you make the decisions using BI. One of the problems with traditional BI implementations is that there are just so many BI tools...

Good Company Report Designer - Report templates are created using the visual Report Designer. Report Designer supports creating elements, changing their attributes and controlling all aspects of element presentation and layout. All attributes and related information is saved in a template file in XML format. The Designer also supports visually building queries against multiple types of data sources and specifying data grouping, summarization and element data binding. Dynamic behavior can be associated with elements using Script capabilities...

Highlights: Custom Shape Chart Software - For shape charts, the end users can now upload custom shapes for their own shape charts instead of relying on an administrator. For candle charts, we have a change to the default settings that are more in line with common usage. For pie charts, We now have an option for more precise control over pie chart sizing, which is great for dashboards with multiple pie charts...

Managing Performance as a Corporate Process - Another important aspect that I mentioned earlier is that we want to move from simply reporting performance to controlling individual's behaviors to effectively managing performance as a corporate process. It involves all levels of the organization in setting the goals and achieving those goals. We want to improve the effectiveness of resolving unsatisfactory performance...

Patient Throughput Metrics - Effective patient flow is a vital component of emergency room operations. Various KPIs and analytics are used by ER dashboards to monitor and improve patient flow. These consist of: Door-to-Provider Time The amount of time it takes for a patient to see a doctor after arriving at the emergency room is called the "door-to-provider time." This KPI aids in evaluating how well early evaluations and triage are done...

Requirement Coverage KPI - The degree to which the stated requirements cover the whole scope of the project or product is known as requirement coverage. Making ensuring that no important details are missed throughout development is crucial. Key KPIs and Analytics: Requirement Coverage Percentage: This KPI calculates the percentage of requirements that the project has successfully handled. When the coverage % is high, it means that the project is in line with the original specifications...

Previous: Report Scripting