scottostanek
Programmer
Just a head's up note: I have a report that I am building the guts of the data using Excel query into several sets of differing types of database files. It runs nightly to update and also uses vba script to change each row of multiple fields into multiple rows for summary reports in crystal. (all this to explain why not using crystal directly) It works well enough. (Cr8.5, Excel via ODBC, original data from Progress Database via ODBC)
The caveat is that the same report (crystal) gives differing grouped results (duplication of lines with wrong summary values) for the one user in the company running Office 2000 than for any other machine using Office 97. _And of course_ he is the accountant that runs the report each month. Nobody had mentioned the problem --assuming I knew of it-- and didn't wonder until one of the other managers made a quote off a copy he'd run himself.
The report is called Cost Trend and is used to quote prices to our customers for bulk chemicals --ie lots of money difference for a small change in price here, this affects the bottom line.![[medal]](/data/assets/smilies/medal.gif "[medal] [medal]")
So after getting grilled over the result, I have the accountant running his book/published version through Citrix which has Office 97 (he is afraid to back track from Office 2k as the files aren't backwards compatible).
The caveat is that the same report (crystal) gives differing grouped results (duplication of lines with wrong summary values) for the one user in the company running Office 2000 than for any other machine using Office 97. _And of course_ he is the accountant that runs the report each month. Nobody had mentioned the problem --assuming I knew of it-- and didn't wonder until one of the other managers made a quote off a copy he'd run himself.
The report is called Cost Trend and is used to quote prices to our customers for bulk chemicals --ie lots of money difference for a small change in price here, this affects the bottom line.
So after getting grilled over the result, I have the accountant running his book/published version through Citrix which has Office 97 (he is afraid to back track from Office 2k as the files aren't backwards compatible).