GCI Power Tools for Reports & Views
By Global Cents (GCI Live LLC)

GCI Power Tools for Reports & Views (PTRV) allows you to create multiple simple SQL select statements to gather data from multiple tables in the OpenText Content Server and display all that data together for the end user to see.
PTRV 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.
Details
In addition to the standard features of PTRV, Version 2 also includes the ability to:
- Create custom views for Search templates & results
- Create custom reports for Transmittals
- Intermix SQL searches with content searches\
- Push and pull content through different databases with Open Text Workflow
- Have a workflow step execute a LiveReport automatically and save the results.