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 …
Tag :Crystal Reports
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 …
Code Golf: Count formula
Time to play a little code golf, where we try to find the shortest possible source code to accomplish a given task. I’m going to be taking on a formula in Crystal Reports that changes a running total {#Count} into a text string to be used as a line label. The string should be formatted …
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.