Like many other institutions, The Morgan Library and Museum utilizes TMS to generate reports using templates prepared in Crystal Reports. But the reports and forms we desire most – loan agreements, condition reports, and exhibition checklists – need to be highly dynamic. Instead of typesetting each block of text or every checkbox, the Morgan leverages …
Category :Business Intelligence
Highlight Alternate Rows in Crystal Reports
I’m sure there are many of us who remember the green bar continuous form paper that spewed out of the old dot matrix printers. The horizontal green bar assisted the reader with following a line of text across the page. Often a horizontal line is used in Crystal Reports for the same purpose. But there …
Giving Users More Than an Empty Report
Occasionally, using an INNER JOIN or selection criteria in Crystal Reports, can result in an empty recordset and a blank report. For instance your user may be trying to run an accessioning report on unaccessioned objects, or a valuation report on records that have never had values entered into the system. These scenarios could create …
Advanced Crystal Reports: Techniques for compiling Annual Reports and other statistics
The interplay between Crystal Reports and TMS can help database administrators streamline reporting needs, and provide powerful statistical updates to museum administrators. This presentation covers some techniques for building such valuable reports.
Check, mate: Creating a checkbox in Crystal Reports
Museum checklists and databases use boolean values, but, currently, there is no way to graphically represent this information in Crystal Reports. Here’s a quick work around to display checkboxes. In this example we will create a graphical checkbox to display if the object record is set for public access.