How to setup start date and end date in Dynamics CRM 2016 on-prem SSRS report.

(0) Share

Report

Posted on by Datadvancer

353

Using SSRS report in my CRM system report, how to set up that: when the user inputs the start date and end date the report will list all the record in this period?

Much appreciated any suggestions!

Categories:

Enterprise Service Settings

All responses (3)

Answers (0)

Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (0)

Report
RE: How to setup start date and end date in Dynamics CRM 2016 on-prem SSRS report.

Hi Datadvancer,

You will need to download the Microsoft Dynamics CRM Report Authoring Extension to to design and preview FetchXML based reports in SQL Server Data Tools, but you do not require it to build SQL reports.

You can choose the report display area from the report settings in Dynamics CRM.
Datadvancer 353 on at

Like (0)

Report

RE: How to setup start date and end date in Dynamics CRM 2016 on-prem SSRS report.

Thanks Adrian.

Now I have two more questions enaccount.

1. When I set up the data source, there are no "Dynamics CRM Server/Dynamics CRM Fetch". I'd like to use T-SQL based query to build report. Do I also need to download Report Authorization Extension? Or some reason I was not connecting the my CRM instance with VS?

2. If I want to show the Report button on the crm Sitmap, How to do that?

Thanks.
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to setup start date and end date in Dynamics CRM 2016 on-prem SSRS report.

Hi Datadvancer,

This article will teach you how to create an SSRS report with date parameters.