1,942
Hi all,
I have two custom SQL based reports, when i uploaded these reports to CRM application it shown up blank data. I have checked in visual studio and report server and in both cases it is working.
Do i need to give any additional permissions here ?
*This post is locked for comments
1. Check what the service account of the reporting service is. Is it a domain account or network service?
2. Run this query in SSMS and note down the details: select dbo.fn_FindUserGuid(),SUSER_NAME()
3. Run this query in SSMS: select SystemUserId,FullName from SystemUser where SystemUserId in (select dbo.fn_FindUserGuid())). Does this produce any rows?
4. Open new query tab and run "execute as user = 'AD ACCOUNT FROM STEP 1'
5. Run query in step 3 again
6. Now run the query that powers the report. Check if it gives any permission errors.
7. Run this query to rollback the user impersonation on the current SSMS tab: revert
This should give you some direction on what the underlying error is.
Hi Vighnesh,
If you use filtered views, add the user to PrivReportingGroup group in your Active Directory.
See: missdynamicscrm.blogspot.in/.../crm-2011crm-2013-filtered-view-return-nodata.html
Are you using SSO?
How about the report generation in the report server's browser instead of client's browser?
Hi Vighnesh,
Have you tried different browsers?
Hi,
Are you using filtered views for fetching data ?
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (