Dynamic CRM 2013 Learning Notes (29) Reporting Service FAQ

Source: Internet
Author: User
Tags sql server management sql server management studio microsoft dynamics

In the report development process, often encounter a variety of problems, such as the cannot be displayed. (rsprocessingaborted), there is no meaningful hint, there is a paging problem, often we want to put a record on one page, the next record on another page, rather than tightly connected to the back of the previous record; sometimes we also get the upload report times wrong: an error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If This problem persists, the contact your system administrator, is also no hint. Here are some examples of how to solve these common mistakes.

First, Each piece of data does not appear on one page, and the next record's head is tightly attached to the previous recording

Sometimes you want each record to appear in one row, select the entire Tablix, and set the paging inside, no matter how:

In fact, the above settings are all lines before or after the page break. It should be set on the group:

The final effect, each page is a new record:

second, the Operation report error: The report cannot is displayed. (rsprocessingaborted)

This error is probably the most error that has occurred.

First check whether the table in the query statement does not start with filteredxxx;

Then check the permissions:

1. Open SQL Server Management Studio;

2. Expand security->logins;

3. Right-click the account running SQL Server Reporting service (e.g. PrivReportingGroup, ReportingGroup);

4. Select User mapping–> YOURORG_MSCRM database to specify the following permissions

Problem solving

Third, upload report error

Sometimes when uploading a report, this error is reported: An error occurred while trying to add the reports to Microsoft Dynamics CRM. Try adding the report again. If This problem persists, contact your system administrator

In general, if the network is not a problem, the report itself is a problem, you can first run in the Reports builder, no problem before uploading

Dynamic CRM 2013 Learning Notes Series Rollup-ongoing updates

Dynamic CRM 2013 Learning Notes (29) Reporting Service FAQ

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.