SSRS Report Archives -

Tag Archives: SSRS Report

Download SSRS report as a PDF with Power Automate – Part 2

In this blog, we will see how to extract the value for PdfDownloadUrl so we can load it into another request and get our PDF.

Run/Enable Customer Engagement SSRS Reports on Mobile App Android / iPad

Customer Engagement apps running on a web browser on an iOS or Android tablet provide a similar experience to using it with a web browser on your desktop or laptop computer. However, some features are not available on the mobile app or mobile web browser out of which one is running SSRS reports. Let’s say … Continue reading Run/Enable Customer Engagement SSRS Reports on Mobile App Android / iPad

Creating Document Map in SSRS

Document Map makes navigation is easy to navigate through table in SSRS In our case we have dataset which contains Product and Product Subcategory. We created the 2 parent groups on Product key and Product Subcategory key. We have to go in the Parent group(ProductCategoryKey) >Advanced > Document Map and select the column used for … Continue reading Creating Document Map in SSRS

Work Hours in CRM

Posted On September 3, 2018 by Admin Posted in Tagged in ,

In this article, we will learn how we can leverage the work hours in Reporting. The calendar entity stores data for customer service calendars and holiday schedules in addition to business. Each calendar is set for a specific time zone. A calendar describes the availability of a service or a resource. Calendars are related to calendarrule records, … Continue reading Work Hours in CRM

Row Numbering Issue for Grouped Data in SSRS

Issue: In SSRS if we are using an aggregate function in a group at the Tablix level, then you may realize that the simple row numbering function does not give a current sequential ranking. Using the function RowNumber(Nothing) gives something like this. Using RowNumber(“GroupName”) would also give an incorrect row numbering and look something like … Continue reading Row Numbering Issue for Grouped Data in SSRS

Print Custom Size Report using Document Routing in D3FOE

Introduction: Recently I was working on Cheque Report. I created a custom size Cheque design and it was working fine while downloading it. Then the task was to print the cheque and test but the printout was off size. In this blog I will guide you how the custom size report prints using document routing … Continue reading Print Custom Size Report using Document Routing in D3FOE

Fetch Parameter name from ID for SSRS Report in D365 Operations

Introduction: I was stuck in an issue recently where I was working on SSRS report with multiple filter parameters. In multiple parameter, one parameter was Brand ID and in report I had to display the Brand name instead of its ID. In this blog article, we will see how we can get the name of … Continue reading Fetch Parameter name from ID for SSRS Report in D365 Operations

Set SSRS Report Parameter to allow null values in D365 Operations

Introduction: Reports are used to see summary of data.  We also set parameter to filter data but at times we don’t want to filter using a parameter and keep it as blank. By default, parameter values are always mandatory in D365 Finance and Operations, Enterprise Edition. In this blog article, we will see how we … Continue reading Set SSRS Report Parameter to allow null values in D365 Operations

Secured By miniOrange