I'm working in a a place so locked down they want me to use SSRS to extract some data and export to another system but .

I can't have access to the data or even a test version.

A quote

yes but thinking about it we shouldn’t have copies of finance data anywhere apart from live or test servers! you may have to develop “blind” and then ask the DBA team to deploy to UAT for you to test?

WTF