reporting against PI AF with SSRS

Discussion created by Wilkinso on May 22, 2013
Latest reply on May 22, 2013 by Asle Frantzen

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!


David Wilkinson


Yorkshire Water, Bradford UK