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.
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.
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.
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.