Hello,
We have built a custom entity in our CRM database which includes fields that I would like to build a report from. Using BIDS (Visual Studio) I have been able to link to our CRM as a data source, and was able to locate our custom entity in the Dataset's folder. I have access to all of the fields needed to create my port, which I have partially completed. Running the report from Visual Studio works great, it pulls the data as expected and generates a proper report.
I saved the working report as an .RDL file, went to CRM through my web browser and created a new report in my workplace. I select "existing file" and browse to the created .RDL file, which brings the customized report into CRM as a report. All out of the box reports work just fine, but when I try to run my custom one (that works in visual studio just fine) it gives me the below error;
Reporting Error
The report cannot be displayed. (rsProcessingAborted)
Here is the log that is thrown in SQL server
"webserver!ReportServer_0-4!fcc!05/20/2011-09:36:35::
e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An error has occurred during report processing. --->
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An
error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Query execution failed for dataset 'DataSet1'. --->
Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException:
System.Data.SqlClient.SqlException:
The SELECT permission was denied on the object 'new_testinspection', database
'Blackhawk_MSCRM', schema 'dbo'. --->
Microsoft.Crm.Reporting.DataExtensionShim.Common.ReportExecutionException: The
SELECT permission was denied on the object 'new_testinspection', database
'Blackhawk_MSCRM', schema 'dbo'."
So my question is, are we going about this correctly to achieve our goal of creating a report from a custom entity?
We did try another angle, using the XML fetch string instead of my above process - but this won't give us access to our custom entity so we're not able to build a form with the fields needed. Is this the proper way of doing this?
Please let me know if more information is needed, and thanks in advance!
Any info provided is greatly appreciated!!
