No Data available on Report CRM 2013 when i run on CRM, but can view data when i run on Sql Server Reporting Services
*This post is locked for comments
No Data available on Report CRM 2013 when i run on CRM, but can view data when i run on Sql Server Reporting Services
*This post is locked for comments
Hi,
Can you please send me report query, if this is SQL query (not fetch xml)?
In the SQL query you should use FilterdViews, not SQL tables. CRM reports have access only on filtered views, but from SQL Reporting services you have access to all tables/views.
Hope this helps
Vlad
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,401
Most Valuable Professional
nmaenpaa
101,156