Friday, March 9, 2012

Inconsisten Crystal Report

Hiya,

Been putting a report together in Crystal Reports X, and its giving inconsisten results.

I have 3 charts that are being created over a set of data, 2 are fine, but 1 is being inconsistent.

Its using a formula with a global array to store sales figures for the next 12 months (its something with the dataset), doing a bunch of calcs for current months sales, and rolling those figures forwards.

When you first run the report, it comes up with a set of values that bear no relation to the actual data.

If you then go in and just add a blank line to the formula and refresh it, the report runs exactly as expected.

Very strange, and totally repeatable, kinda clueless on what to do with it.Can you post the formula you used?
Also make sure you verify database everytime the table schema changes

No comments:

Post a Comment