1,771
Hi,
I am getting the following error when create and run reports from CRM. When I click on Try again button, I am getting second error Invalid argument. Please help me to find solution.
I tried below solution but it is not working.
. In my case it was that the Reporting Services service user wasn't a member of groups PrivUserGroup and PrivReportingGoup in Active Directory.
*This post is locked for comments
Hi Noushad,
You can check this link..
http://www.inogic.com/blog/2012/05/solutions-to-issues-with-reports-in-dynamics-crm-2011/
Hope this helps
Thanks
Hi,
IIS was not installed on server where Microsoft Dynamics CRM Reporting Extensions installed. but SQL reporting service configuration was done and I am able to generate reports the which was created by SSRS. But the original reports and reports were created by CRM report wizard is not working.
I browsed the directory by Report manager URL and found the below issue.
I am able to browse to below directory.
When I click on MSCRM_Datasource under SSC_MSCRM where SSC_MSCRM is company database name
When I click on MSCRM_DataSource I got the following details in xml format
- <DataSourceDefinition>
<Extension>SQL</Extension>
<ConnectString>Data Source=CRM-DB;Initial Catalog=SSC_MSCRM;Integrated Security=True;Min Pool Size=2;Connect Timeout=150;Workstation ID=CRM.mmc</ConnectString>
<UseOriginalConnectString>False</UseOriginalConnectString>
<OriginalConnectStringExpressionBased>False</OriginalConnectStringExpressionBased>
<CredentialRetrieval>Integrated</CredentialRetrieval>
<Enabled>True</Enabled>
</DataSourceDefinition>
When I click on Custom Reports or other system reports. I got the following error. Cannot connect to data source 'CRM' rserroropeningConnection as shown below screen.
The CRM trace log sometimes gives more details about why report execution failed. If I was you I would temporarily turn on the trace then run the report and see if it provides any relevant information
This article provides instructions to turn it on support.microsoft.com/.../how-to-enable-tracing-in-microsoft-dynamics-crm
Note after you configure the registry keys for tracing I think you need to do an apppool recycle or iisrestet for the settings to apply
pls check your sql trace for detailed error info. Pls share the log for further suggestion
Hi,
Thanks for your reply. CRM is on premise. I did check the access on sql server of CRM database. Let me know if there any other access I need to check. It is an access issue only since new report by report wizard also not working with system admin role.
Thanks and regards,
Noushad
Hi,
It seems like the problem with you Reporting Service configuration. If you open deployment manager, do you see any error/ warning message there? something like "Reporting is not enabled"
www.interactivewebs.com/.../crm-2013-reporting-is-not-enabled-message-in-crm-deployment-manager
Hope this help
Yes the user need permission the in the Reportserver.
if you are on premise pls chk the user has access to the following groups.
PrivReportingGroup
ReportingGroup
SQLAccessGroup
If OnLine Please check the user has full rights as below
hope This helps
Hi,
Even I created new report for just testing. I created new report just to display account name from account entity but giving same error. It looks likes some permission error. if the report generate from report wizard directly, does it require SSRS. Please find a solution.
Regards,
Noushad
Hi Noushad,
Please check if the required parameters are passed properly while running the report. Or check if they are actually available (as in deleted or not ) in the default solution. Hope this might push you in the right direction in solving the issue.
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 (