Hello ,
I have created a custom report (SSRS), i'am using an embedded datasource & embedded dataset .
I'am using sql connexion.
The report is developed in visual studio .
My problem is when i'am testing in vs I can see my data , but once i deploy the report in the CRM,i cannot see any data.
I'am Admin,So any ideas?
Thank you in advance .
Best Regards
*This post is locked for comments
Would just add to what Mayur wrote above.. You should likely be using filtered views either way. I believe even a CRM admin won't have access to the non-filtered views/tables by default. But, on the other hand, if you did not have access when running that report in CRM, you would probably see some error in the report, so it's back to that question of what do you, actually, see (is it just no data, or is it some kind of error?)
Hi,
Are you using fecthxml or sql query?
So report is running but no data and with no error message, right?
When you are running report in Visual Studio the report might be running in Admin Account context, hence records are visible.
In CRM did you tested report with logged in as Admin?
Check what views/tables you are used in sql query. If you want all records to be displayed user new_entityname view or base tables(new_entitynameBase). Filtered view only shows records which are under user/team ownership.
PS. Admin can see all the records.
the problem is that i have to use the shared datasource MSCRM_datasource & not and ambedded datasource.
Thank you
Have you added the data connection string within the report?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (