HOW TO CREATE SUBREPORTS IN SQL SERVER REPORTING SERVICES (SSRS)?

  • A Subreport is a report item that displays another report inside the body of a main report.
  • It is basically used to embed a report within a report.
  • Any report can be used as a Subreport.
  • We can pass the parameter into Subreport from Main report.
  • We can place a Subreport in the main body of the report, or in a data region.
  • If you place a Subreport in a data region, the Subreport will repeat with each instance of the group or row in the data region.
(more…)

Continue ReadingHOW TO CREATE SUBREPORTS IN SQL SERVER REPORTING SERVICES (SSRS)?

HOW TO CREATE PARAMETERS IN SQL SERVER REPORTING SERVICES (SSRS)?

Parameters in SQL Server Reporting Services (SSRS) add a level of interactivity to reports. Parameters can be utilized for everything from criteria in a query to filters for a Tablix to controlling visibility of objects on a report. Furthermore, they can be populated from a set of constant values, or they can be based off the results of a data set query. Parameters are the main component of any interactive reporting tool.

(more…)

Continue ReadingHOW TO CREATE PARAMETERS IN SQL SERVER REPORTING SERVICES (SSRS)?

HOW TO CHANGE DEFAULT FONT PROPERTIES OF EMAIL BODY IN DYNAMICS 365 USING JAVASCRIPT?

The email configuration experience enables users to be more effective and efficient when using email to communicate with customers. To change the default font properties of email body, we can use an existing web resource file (JScript) by the following approach:

  1. Configure the web resource file
  2. Enable the RTE control in the email form

(more…)

Continue ReadingHOW TO CHANGE DEFAULT FONT PROPERTIES OF EMAIL BODY IN DYNAMICS 365 USING JAVASCRIPT?

HOW TO GET AND SET LOOKUP FIELD VALUES USING JAVASCRIPT IN DYNAMICS 365?

There may be cases where you need to set one lookup field value into another lookup field on the form using JavaScript in Dynamics 365 .

What is Lookup field?
A Lookup field type represents the relationship attribute on the related entity.
(more…)

Continue ReadingHOW TO GET AND SET LOOKUP FIELD VALUES USING JAVASCRIPT IN DYNAMICS 365?

HOW TO SEND EMAIL TO SECONDARY EMAIL ADDRESS USING PLUGINS IN DYNAMICS 365?

SCENARIO:

By default, CRM will send E-mail to “Primary Email Address” for Accounts, Contacts and Leads. Sometimes we may need to send the E-mail to “Secondary Email Address” (or) “Third Email Address”.
Let us see how we will achieve this with some customizations and Plug-in. To achieve the above requirement, we need to follow below mentioned steps:
(more…)

Continue ReadingHOW TO SEND EMAIL TO SECONDARY EMAIL ADDRESS USING PLUGINS IN DYNAMICS 365?

HOW TO FORMAT CHART LABELS IN DYNAMICS 365?

A chart is a graphic representation of data from multiple records of an entity. Charts interact with the views and filters which are currently applied to the view and a chart is refreshed each time you change your view.

SCENARIO:

Let us see how to remove decimals using custom label format into CRM chart Xml.

(more…)

Continue ReadingHOW TO FORMAT CHART LABELS IN DYNAMICS 365?

HOW TO SETUP SLA ESCALATIONS IN DYNAMICS 365?

In an ideal world, it would be great to not have any escalations at all. Escalations can crop up due to a bunch of reasons like miscommunication with agents, technical delays, missed service level agreements (SLAs), and more. And managers must be at the forefront to pacify customers in such situations. It is, therefore, essential to set up the right processes and mechanisms to effectively manage escalations and prevent them from getting in the way of a good customer experience. 

(more…)

Continue ReadingHOW TO SETUP SLA ESCALATIONS IN DYNAMICS 365?

HOW TO APPEND MULTI SELECT OPTION SET IN DYNAMICS 365 USING MICROSOFT FLOW?

Multi Select Option Sets were introduced in version 9.0 of Microsoft Dynamics 365 CRM. D365CE Multi Select Option Sets are a great new capability. The way to apply business rule functions to a Multi Select field is to use JavaScript.

Multiselect Option Sets are also limited in the case of Workflows. We can not select these fields in a condition nor modified in an update record step. The field will not even appear on the update record form. However, the field can still be selected as a trigger for the workflow.

(more…)

Continue ReadingHOW TO APPEND MULTI SELECT OPTION SET IN DYNAMICS 365 USING MICROSOFT FLOW?