Wilkinso

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 

 

 

 

 

 

   

 

 

Outcomes