I am producing SSRS reports against a PI AF database using MS Visual Studio 2005.
I can test them OK in VS and deploy and run them to a reporting server in a QA environment. However after deploying the reports to a Production environment I get no data returned from the reports but no error messages returned to the report.
I am having trouble finding out if we have a permissions issue. I can run the same SQL in PI SQL Commander 2012 and the query returns data as expected.
Is there a log file I can view on the Reporting server?
Any links to the use of SSRS reporting with PI would be appreciated, too!
Yorkshire Water, Bradford UK