Microsoft Dynamics 365 | Integration, Dataverse...

Custom SSRS report

(0) Share

Report

Posted on by alexyou

385

Hello,

I'm pretty new to the whole building SSRS reports in visual studio report designer. I was able to produce a first report, upload it to dynamics 365 and run (and get results too!)

But I can not figure out how I'm doing "filter" to the report. For example, the report will run only on a specific customer that user selects.

The Filter button does not appear in the report.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

You should enable prefiltering for your report - exptechsolutions.blogspot.com/.../d365-ssrs-report-prefiltering.html

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (1)

Report

As well as enabling pre-filtering in the report query (as per the previous post), you will also need to specify the related entity type(s) for the report when you upload it, and also to display in 'Form for related entities' if you want a user to able to run the report from the form on a given record

Was this reply helpful? Yes No