Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.

If I want to tweak the index for reports they need to be added to the LIVE db. Very poor oversight.