In this test setup the publisher, distributor, and IIS are the same machine. I'm using the SQL management studio to setup the web virtual directory.

The replisapi dll has a diag...

Awesome, thanks!

The join from Job to Estimates is on Job.JobID = Estimate.JobID instead of the userID, but I think this slight change makes my day.

SELECT

O.OfficeAbbr,

U.Name,

AVG(E.FinalAmount) AS Average,

COUNT(E.EstimateID) AS Number,

SUM(E.FinalAmount) AS...