You’re offline. This is a read only version of the page.
Hello,
I have written a custom report with VS2016 with SQL based query with SSRS. All is ok when I run the report or publish it to Reportservices I can see the report and charts.
When I try to copy RDL file and upload into CRM application and run in through there, I get an error:
The report cannot be displayed. (rsProcessingAborted)
In the eventlog I can see an error:
Report data set execution failure. Error: The SELECT permission was denied on the object 'SalesOrder', database 'CRM_MSCRM', schema 'dbo'.
My question is, while I have imported the RDL file in to the CRM, which user is trying to query sql server?
*This post is locked for comments
Just asking, isn't it better to write FetchXML instead of SQL-based query?
I want to be able to sum, add and calculate somenumbers received from the query.
I'm new at creating custom reports with SSRS.
Thanks
Hi
If you give read access to the User in SQL, the user would be able to see all the data.
If you use filtered view then the User would be able to see the data only allowed for the user.
Please refer the following:
Filtered views respect permissions scoping of CRM to the user running the report. If you open up SSRS, instead of looking at the tables on the CRM database, look to the Views. You'll see the regular views, and then the ones listed as "filtered". You can't query it exactly like a table, so you'll have to update your query a little as well.
Hi, Thanks for replies,
After providing the user account of SQL Server Reporting Services (MSSQLSERVER) Read access the SQL database, the report is now showing.
But I'd appreciate any best practice for custom reports if the method I'm using is ok or not.
Hi,
What is a filtered view? I changed it to FilteredSalesOrder but that table does not exist!
Hi
Try with Filtered views (FilteredSalesOrder) instead of the table SalesOrder
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (