LabVantage offers several different options when it comes to designing your report output. One option is to use Studio from Jaspersoft. This 2-day reporting class includes instruction for how to use the design tool to build a new report. Additionally, you will learn some of the concepts surrounding the LabVantage data model.

Prerequisites and Target Audience

A basic understanding of SQL (structured query language) is recommended but not required. By the end of this class, you will understand how to create a new report design or modify an existing example using Studio to suit the needs of your LabVantage data reporting requirements. Note that Studio is supported with LV7 and above.

01 Installing and Configuring Studio: Getting started with the Jaspersoft Studio designer tool requires some installation steps. This chapter shows you what is required to install and configure Studio for use with a LabVantage database.

02 Creating Your First Report Using the Wizard: With Studio, a basic simple report is easy to create using the wizard.

03 Basic Report Developer Features: Looking at the Studio developer interface, the features might not seem obvious at first. But before you know it, this will become second-nature.

04 Datasets, Queries, Parameters and Variables: Designing a report means you need to anticipate what the user will want to see as output and what kind of input they will give you to use as a filter.

05 Report Display Types: What will be the overall layout for your report? Is it a chart or a graph? Will you include summary data along with the details? Maybe include a subreport? How often will columns wrap on one page?

06 Elements: Adding lines, rectangles, barcodes and other report elements increases the usability and acceptance of your design.

07 Charting: Learn the tricks to adding pie, bar, line and other charts to your report.

08 Installing a Report in LabVantage: Now that your report is perfect, you want people to be able to execute your report. With LabVantage’s built in Jasper Reports Server, all you have to do now is register the report in the LabVantage application and your users can see the output in their browser!

09 Running a Report from a Button: Executing a report from LabVantage can be as simple as clicking a button. Learn how to add a button using the LabVantage Web Page Designer so that the button will call your report.

10 Reports with Parameters: Some reports require input from the user. This establishes the criteria for the data on the report such as a date range or a record identifier. Here, you will learn how to configure the report to accept this input, configure LabVantage to prompt the user for this input, and pass the user’s response to your prompt from LabVantage to the reports server.

11 Report Events: Some reports generate output that is used to make important business decisions. These types of reports contain data that, if changed, could have an impact on further downstream processes. Learn how LabVantage can track the execution of a report to include a possible reprint.

12 Advanced Crosstab and Subreports: Report output is often desired in a grid fashion with column headers and row headers resulting in a datapoint being displayed as an intersection. Subreports are another way to establish a query that uses the data from another query as criteria.