Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

How to Format Dates in SSRS Using Custom Expressions

 In SQL Server Reporting Services (SSRS), customizing the date format is essential for improving the readability of reports. SSRS provides the Format() function, which allows for flexible formatting of date fields to meet different reporting requirements.

Implementing Dynamic Filters Using Drop-Down Lists in SSRS for Dynamics 365

 

Introduction

In this guide, we’ll show how to set up dynamic filters using drop-down lists in SSRS reports for Dynamics 365. This method enhances report flexibility and user interaction by allowing end-users to select different fields and date ranges dynamically.

Automating Dynamics 365 Report Generation Using JavaScript

 When working with Microsoft Dynamics 365, you may find yourself needing to automate the generation of reports based on specific criteria or in response to certain actions. This can greatly enhance user experience and efficiency by reducing the number of manual steps required to view important data. This article outlines how to create and use a JavaScript function that dynamically retrieves the GUID of a specific report by its name and then generates that report for a given record ID.

How to Retrieve a Dynamics 365 Report GUID Using the Web API

 In Microsoft Dynamics 365, reports play a crucial role in visualizing and summarizing business data. Sometimes, you may need to programmatically access these reports, for instance, to integrate report links into custom user interfaces or automated workflows. This article guides you through the process of retrieving a report GUID (Globally Unique Identifier) using the Dynamics 365 Web API, which is essential for any automation or integration task involving reports.

Adjusting SSRS Reports to Fit Avery Label Templates: A Practical Guide

 Adjusting SSRS Reports to Fit Avery Label Templates: A Practical Guide

Introduction: Tailoring SSRS reports to fit Avery label templates can be a precise task. This guide provides a step-by-step approach, using a real example to demonstrate how to align your SSRS report with Avery 5961 label specifications.

[TIP] Resolving Connection Issues in SSRS for Dynamics 365

 

[TIP] Resolving Connection Issues in SSRS for Dynamics 365

When working with SQL Server Reporting Services (SSRS) in Dynamics 365, you might come across a peculiar issue where the metadata doesn't appear as expected, or the CRM Login pop-up window fails to display the list of available organizations, even when the option "Display list of available organizations" is checked. The root cause could be the credential settings in the data source of your SSRS project.

How to Install SSRS template of Visual Studio for Dynamics 365/CRM

 How to Install SSRS template of Visual Studio for Dynamics 365/CRM

This article will introduce how to install the SSRS template of Visual studio before you start to create your first SSRS report for Dynamics 365/CRM/CE. 

[TIP] Converting Date/Time Parameters to Text for FetchXML Queries in SSRS Reports

[TIP] Converting Date/Time Parameters to Text for FetchXML Queries in SSRS Reports

Introduction: When working with SQL Server Reporting Services (SSRS) in conjunction with FetchXML queries, you might encounter a scenario where date/time parameters cannot be used directly. This article outlines a practical solution to convert date/time parameters to text type, enabling their use in FetchXML queries within SSRS reports.

[TIP] Workaround for Multi-Select Parameters in SSRS for Dynamics 365

 Workaround for Multi-Select Parameters in SSRS for Dynamics 365