Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Strange issue with imp...
Microsoft Dynamics CRM (Archived)

Strange issue with imported report in CRM 2015

(0) ShareShare
ReportReport
Posted on by Pete_N 1,695

I have been generating SSIS reports in VS2013 and importing them into CRM 2013 with no problems, however when trying to do the same in CRM2015 I am getting very strange outcomes

I am logged into CRM as the Administrator, and the report is imported in under this profile

The report is a custom invoice report

If the report is generated using this query ;

SELECT  CRMAF_FilteredInvoice.accountidname
FROM [dbo].[FilteredInvoice] AS CRMAF_FilteredInvoice

It  is rendered and shows the accountidname with no problem BUT when using this query;

SELECT  CRMAF_FilteredInvoice.accountidname
,B.new_CompanyName
,B.Address2_Line1
,B.Address2_Line2
,B.Address2_Line3
,B.Address2_StateOrProvince
,B.Address2_PostalCode
,CRMAF_FilteredInvoice.datedelivered AS 'InvoiceDate'
,CRMAF_FilteredInvoice.invoicenumber
FROM [dbo].[FilteredInvoice] AS CRMAF_FilteredInvoice
LEFT JOIN [dbo].[Account] AS B
ON CRMAF_FilteredInvoice.accountid = B.AccountId

I get the following

CRM2015-Report-Error.jpg

*This post is locked for comments

  • Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: Strange issue with imported report in CRM 2015

    Thanks for the help, it was a permissions error ..

  • Verified answer
    mscrmba Profile Picture
    mscrmba on at
    RE: Strange issue with imported report in CRM 2015

    See if this helps:  http://fkbase.info/node/216

    It says:

    Missing Permissions

    Looking at these objects in the database in the Programmability node showed that the objects had no permissions granted. But what permissions should be granted?

    Comparing with another CRM deployment I noted the following permissions were granted (Select or Execute as appropriate for the object):

    ##GRANT to CRMReaderRole  (Database role)

    ##GRANT to Domain\ReportingGroup{GUID} (User)

    Replace Domain with the name of your domain and GUID with the relevant GUID for your ReportingGroup. Use the Search button to lookup the group, if you have more than one ReportingGroup then this means that CRM has been installed multiple times on a server or there is more than one deployment on your network so you must select the ReportingGroup relevant to the Reporting Services server.

  • Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: Strange issue with imported report in CRM 2015

    Hi,

    Tracking this down, im getting the following error in the event log

    Report data set execution failure. Error: The SELECT permission was denied on the object 'Account', database 'xxx_MSCRM', schema 'dbo'.

    Logged in as administrator, I have all the permissions for the entire SQL serve, so im confused as to why I am getting this error

  • mscrmba Profile Picture
    mscrmba on at
    RE: Strange issue with imported report in CRM 2015

    Mmmmmm

    1. you're on the RTM version.  Update 0.1 is out for On premise but it only seems to address the following:

    • Users with Administrative Access Mode are unable to import a solution containing Reports.

    2. Do you have any records that meet the report's criteria?  A report might not run if there are no records.

    3. Is it just you or are others affected?

    4. What browser are you using?

    5. What does the Event Viewer on the Reporting Services server say?

  • Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: Strange issue with imported report in CRM 2015

    Hi Mscrmba.

    That's what is stumping me, I can generate reports in report wizard and view / print. I can view / print any system reports. Importing the report from VS213 works fine when just accessing the filteredview, but as soon as I try a join to accounts I get an error. It makes no sense

  • mscrmba Profile Picture
    mscrmba on at
    RE: Strange issue with imported report in CRM 2015

    Hi Pete,

    Is reporting extensions set up?

    Can you run any report?

    Try following this blog - it's got some good tips/a number of things to check:

    atriosystems.wordpress.com/.../microsoft-crm-2015-the-report-cannot-be-displayed-rsprocessingaborted

  • Pete_N Profile Picture
    Pete_N 1,695 on at
    RE: Strange issue with imported report in CRM 2015

    I am On-Premiseis  Crm 2015 version 7.0.0.3543

  • mscrmba Profile Picture
    mscrmba on at
    RE: Strange issue with imported report in CRM 2015

    Are you online or on-premise 2015 (on-premise has some significant differences/restrictions)?

    Which version of 2015 are you running?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans