Reports

Reporting Services - Unable to connect to the remote server

  • Posted on: 11 July 2015
  • By: feridun

I installed SQL Server 2012 Database services and Reporting Services and selected the option to configure reporting services instead of doing the configuration manually.

The installation succedeed but I noticed that Reporting Services had configured binding for port 80 and https on port 443 as well. I didn't have an SSL certificate so in Reporting Services Configuration Manager I removed the bindings for port 443 for both reports and the reports manager.

FetchXML Field Types in SSRS

  • Posted on: 15 May 2014
  • By: feridun

When creating reports that use FetchXML, some field types are returned with two fields, the name of the field and the name of the field with Value appended, fieldValue.

The table shows the field types that I found that have a Value version. Other CRM field types only return one field and are of type String.

Scheduling Reports in Microsoft Dynamics CRM

  • Posted on: 31 October 2013
  • By: feridun

Scheduling Reports in Microsoft Dynamics CRM

Reports in Microsoft Dynamics CRM can be configured to run on a scheduled basis from within the CRM application. For example, if a sales report is needed on a weekly basis, you can schedule the report so that it is automatically available at the required time.

Email Subscriptions

If you have Microsoft Dynamics CRM On-premises you can create an email subscription to the snapshot in SQL Reporting Services Report Manager.

Custom Sorting in SSRS Reports

  • Posted on: 18 October 2013
  • By: feridun

To sort rows in a dataset you can choose a column in the dataset in the properties of the tablix or other report element.

Or if you need a custom sort where the sorting isn't alphabetical or numerical you can add code to the report and then call the code in an expression in the sorting property of the tablix.

However, custom code is not allowed for reports that run in Microsoft Online.

An example not using custom code is to use an expression like this:

Unable to validate SQL Server Reporting Services Report Server installation

  • Posted on: 22 July 2011
  • By: feridun

When trying to install the SSRS Data Connector you may encounter the error:
"Unable to validate SQL Server Reporting Services Report Server installation".
There are many reasons why this might happen but I came across a rather obscure one where a 32-bit SQL Server was installed on a 64-bit Windows server. It seems that this combination is not supported as per this article:
http://support.microsoft.com/kb/2223769

Pages