Continued from part two.
In this last part we’ll look at the Crystal Report and how we schedule it in Logicity. I’m hoping this project serves as an example of why, with the exception of very simple reports, I generally prefer to do my data processing in stored procedures, and only use Crystal for presentation.
I shudder to think what would be required to make this report happen using only Crystal. How many subreports and shared variables would you need? Instead, we have two somewhat complex but relatively manageable scripts that provide all the data we need to populate a very simple report. It wouldn’t be difficult to read through those two scripts and figure out how they work. If you put all that into the report itself, it would take days or weeks to get your head around what it’s doing.
Continue reading →