I have to agree, there is no real difference with the calculations except in the interpretation by the system. Int divide by Int = Int which causes incorrect values. Simpler...

Thanks for the advice Grant, I will look at starting to implement this today and see how we go.

Re-architecting is not a problem providing we can leave the existing structure as a data warehouse and have the data flow into the new structure through triggers and stored procedures.

Fully aware of that and I honestly do want to update everything to a proper Relational Database system but at this time the implications are just far too great and...

Having checked output from Crystal against the problems we were having from RS it seems it could actually be Excel 2007's handling of xls(97-2003) format files. Both Crystal and RS...

We are using SQL version 9.0.3073.

I notice that in CU10 the excel rendering DLL has the version 9.0.3294.0. Could this fix the issue we are having or was there no...

Sorry about being vague in the earlier post. The error happens every time but the process only needs to happen on certain days of the week.

The problem is with the...