SSRS Archives - Microsoft Business Intelligence

Add custom fonts in SSRS Report

Adding custom fonts in SSRS or SQL Server Reporting Services is a powerful way to personalize and enhance the visual appeal of your reports. This process involves selecting a distinct typeface that aligns with your brand identity and integrating it seamlessly into your SSRS environment. Let’s explore how the addition of a custom font can… Continue reading Add custom fonts in SSRS Report

Microsoft Business Intelligence: SSRS > Shared Dataset > Not detecting NEW fields > a simple fix

For many reasons, we may feel the need of bringing additional fields to the SSRS dataset. A common issue faced when using SSRS i.e. Microsoft Business Intelligence shared datasets is when we change the backend query to bring additional fields for reporting, the dataset fails to recognize this change. Let us try to regenerate this… Continue reading Microsoft Business Intelligence: SSRS > Shared Dataset > Not detecting NEW fields > a simple fix

Automatically schedule the SSRS Report and send it as PDF attachment with the email in Microsoft D365 CE/CRM

The Microsoft D365 CE/CRM provides the feature to run the selected SSRS reports manually. But I had the requirement to schedule the execution of report on a user-specified frequency like daily, weekly or monthly and send the report to the user via email as an attachment. But I did not find any OOB feature in… Continue reading Automatically schedule the SSRS Report and send it as PDF attachment with the email in Microsoft D365 CE/CRM

SSRS – How to handle multi tenants in single instance?

Problem Statement: We have different SQL databases for different tenants(or clients), and we want the same SSRS report to fetch data from different databases based on the user who is executing the report. To achieve this, we can have a data source that is dynamic by using an expression-based connection string. Below is a quick explanation… Continue reading SSRS – How to handle multi tenants in single instance?

SSRS – Delete specific RDL files from Report Server in one go

Introduction Earlier, we wrote a blog to download the multiple report files (.rdl files) at one go. You can find it here. Today, following readers’ requests, I will share a simple handy script which will help you to delete specific report files at once. Implementation SSRS uses SQL Server to store it’s details and the Catalog and DataSource tables are… Continue reading SSRS – Delete specific RDL files from Report Server in one go

Juggling with .net & sql

Technology expert, Vinay gets excited when it comes to writing about Dot Net, SSRS and SQL Server. Be it complex concepts or complex problems, Vinay has explained everything in simple and easy steps. To learn more, click on the link below and follow his posts.

Inkey’s ability pond

‘‘INKEY’s ability pond” is your one stop shop to learn more about the services offered at INKEY. Here, our authors discuss on some of the topics like Microsoft SQL Server, Microsoft Dynamics CRM, Microsoft Business Intelligence, Microsoft Power BI, Microsoft Office Add-ins, Mobile Development, and Custom Application Development.