CRM Report error

(0) Share

Report

Posted on by P NOUSHAD

1,821

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

I have the same question (0)

All responses (12)

Answers (0)

Suresh Sorde 1,077 on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
P NOUSHAD 1,821 on at

Like (0)

Report

RE: CRM Report error

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.

Was this reply helpful? Yes No
Joseph McGregor Mac... 597 on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
Syed Ibrahim 6,257 on at

Like (0)

Report

RE: CRM Report error

pls check your sql trace for detailed error info. Pls share the log for further suggestion

Was this reply helpful? Yes No
P NOUSHAD 1,821 on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
Suggested answer

Syed Ibrahim 6,257 on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
P NOUSHAD 1,821 on at

Like (0)

Report

RE: CRM Report error

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

Was this reply helpful? Yes No
Suggested answer

Bhaargavi Bodapati 115 on at

Like (0)

Report

RE: CRM Report error

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.

Was this reply helpful? Yes No
P NOUSHAD 1,821 on at

Like (0)

Report

RE: CRM Report error

Hi,

I am creating this report directly from report wizard not using SSRS. Please check error and help to solve this issue.

Regards,

Noushad

Was this reply helpful? Yes No