Crystal Reports 9.0 report gives comepletely different data in enterpr

[chrislarkin]

Using AS400 (DB2), the report uses a number of variables and a single sub report... Totals are fine in Crystal Reports but when put on server lots of errors with division by zero. Put formulas in to test for 0, now get lots of blank forumlas...


Any thoughts?

 

[synapsevampire]

You're probably pointing at different data sources or have different permissions.

Test by setting the same joins in a generic report and returning counts and sums of some fields. If they differ, then the datasource differs.

-k

 

[chrislarkin]

Hi, found the answer, and it is a silly mistake.

When adding a range of values to a parameter, Crystal Reports defaults to including both ends of the range and Crystal Enterprise (e-portfolio) defaults to not including them.

Thanks for your time!

 

[synapsevampire]

No, they both default to including them. There would be a whole loot more posts here with this concern if that were the case, so check again...

In fact there are check boxes to explicitly state whether you include them or not.

-k