FEP 2010 - "No Data" and "Error: Subreport could not be shown".

Hi,

Yesterday I visited a smaller customer that had decided to do the implementation of FEP 2010 them self. Nothing wrong in that, but somewhere a long the way something had gone terrible wrong with the installation.

 

Error

The FEP 2010 reporting (SQL reporting services) component didn't show any data. I just stated "No Data" and "Error: Subreport could not be shown".

 

After doing some troubleshooting I found that I couldn't access the Microsoft SQL 2008 Analysis services using the Microsoft SQL Management studio. None of the customers services accounts had access to connect to the service.

 

We decided to reinstall the FEP 2010 reporting component after re-installing the Microsoft SQL 2008 Analysis service. After completing the installation everything worked.

 

 /Peter Dahl

 

Tags: ,

blog comments powered by Disqus