We're in the process of moving from Deltek Vision 5.1 to 6.2, with sights on moving to 7.x later this year. The current go live date is July 1.

Part of the migration is to take a custom version of the Project Detail Report we had done for 5.1 in Actuate 8 and recreate it for 6.2 which uses MS SQL BIDS 2005 to build custom reports. The custom report cost us quite a bit to have developed at the time and management doesn't want to pay for it again. So, the task is in my lap.

Admittedly, I have little experience with databases and reporting, except for Oracle classes in college where we used stock Crystal Reports templates.

We have the original Actuate 8 report designer still installed on a PC and have extracted the SQL statement. Comparing the 5.1 custom SQL statement to the stock 6.2 statement, we see little difference other than multiple custom columns and groups that may have been generated by Actuate 8 for processing purposes.

Comparing the 5.1 custom report output to the 6.2 stock report output, there is little difference. The there seems to be a few columns we need to either remove or relabel. Beyond that, the modifications would be adding Job-to-Date Billing and Job-to-Date Hours columns in the main body of the report, and replacing the Variance Percent column in the Financial Analysis section with a Payroll Multiplier column, which would need to use a variable in it's calculation. The variable comes from a user prompt in the 5.1 custom version, but never actually changes so can be hard-coded for simplicity.

I'm hoping this isn't as complicated as it seems to be and someone can point me in the right direction. We're also open to outsourcing to a consultant if the fee isn't exorbitant.