Thank you for the replies and advice.  Much appreciated! 🙂  I have more digging to do.

Thanks for the reply. Still researching, but transactional replication does seem like a good option.

Figured out the answer to one of my questions. Found the Report Header/Footer menu items, added a footer and added ="Page " + CStr(Globals!PageNumber) + " of " +...

Thanks for the reply. We'll add her to db_owner to facilitate this development.

Also, she's developing her views and procs on a reporting server/database, not our production OLTP db.

Thanks!

Gary