>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

If it were me, I would push the problem back in a reasonable way.
Say you need a fake version of data - that somebody familiar with the real data can validate the results.