feridun

Service Accounts for SQL 2012

SQL 2012 can use Managed Service Accounts and Virtual Local Accounts as described here: http://msdn.microsoft.com/en-us/library/ms143504%28SQL.110%29.aspx#New_Accounts Installing CRM 2013 works with the default virtual local accounts created when installing SQL 2012. However, installing Reporting Extensions reports an error that a local account is used for Reporting Services and this must be changed to a domain account.

Service Accounts for SQL 2012 Read More »

FetchXML Field Types in SSRS

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

FetchXML Field Types in SSRS Read More »

Multi-series charts

When you create a chart with multiple series, the chart editor insists on adding a secondary y axis scale. This is probably something that you don’t want because if you have two or more series comparing similar items the scaling will be different for each series. There is no way to remove the secondary y

Multi-series charts Read More »

Reporting and Data Visualization in Dynamics 365 and Power Platform

Here are some reporting and data visualization tools to get all that data out of Dataverse: SQL Server Reporting Services (SSRS) – Use the Report Wizard in model-driven apps for simple reports. For more complex reports, you’ll need to use Visual Studio and learn FetchXML. Nick Doelman has written how to get started at https://readyxrm.blog/2021/01/23/ssrsdataverse2021/.

Reporting and Data Visualization in Dynamics 365 and Power Platform Read More »