GCI Power Tools for LiveReports

The Livelink® LiveReports module enables users to create and work with Livelink items called LiveReports. LiveReports are powerful tools that allow direct access to the RDBMS underlying Livelink via Structured Query Language (SQL) statements. You can set up LiveReports to return lists of items that meet certain criteria, to report statistical information about the database contents (such as a pie chart showing the proportion of items owned by each user), or to change information in the database (for example, re-assign all tasks of a user who left the organization). For example, you can run a LiveReport that lists all items that you have reserved. This report shows you what proportion of space each user takes up, or that transfers item ownership from a user who left your organization to their successor.

However, because LiveReports can only run a single SQL statement you are left with only two choices for displaying data:

1. You can create an extremely complex SQL statement to retrieve all the data in a single statement. This can be difficult to get the SQL correct and when you do a number of complex joins against multiple tables the statement can take a long time to run.
2. Or, you have to click through reports to display all the data. The problem with this is that you cannot see all the data on a single page and how each piece of data relates to each other piece.

GCI Power Tools for LiveReports (PTLR) allows you to create multiple simple SQL select statements to gather data from multiple tables in Livelink and display all that data together for the end user to see. Being able to show all the data in a single report allows the end user to see the relationships between the different data elements.

PTLR also uses XML and XSL to create the final display of the data to the end user. Because these are programming standards, there is no need to take a proprietary training class to learn how to create the custom display of the data. XSL contains programming capabilities which allow for complete manipulation of the data returned from the SQL statements. This makes it easy to do mathematical computations on the data as well as date and text manipulation.

Please download the GCI Power Tools™ for LiveReports info sheet , and for more information or to arrange a demo please contact us at info@globalcents.com.

<< back