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)

Syed Ibrahim 6,257 on at

Like (0)

Report

Is the report working with admin account while running in visual studio?

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Can you try running the report from within SSRS?

That should probably give you more information about the error.

Log in to SSRS and run the report from there. As credentials you will need to enter the user id and organization id from the system user table.

Once you run the report, you will see a full description of what the error is, and that way you will be able to resolve it.

Hope this helps.

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

Like (0)

Report

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
Suggested answer

Bhaargavi Bodapati 115 on at

Like (0)

Report

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

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

Syed Ibrahim 6,257 on at

Like (0)

Report

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
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

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
P NOUSHAD 1,821 on at

Like (0)

Report

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
Syed Ibrahim 6,257 on at

Like (0)

Report

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

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

Like (0)

Report

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