Share via

Pre-filter not showing on SSRS report on Dynamics 365 dashboard

Eljakim Seemann 1 Reputation point
2021-05-21T12:45:57.827+00:00

I have an ssrs fetchxml report developed with SQL Server Data Tools 2015 (in VS EE 2015) and successfully published to Dynamics CRM 365 Online.

Pre-filter is enabled and successfully showing and working when opening the single report directly in D365.

I have then integrated the same report in a D365 Dashboard by using a web resource (reportloader).

When opening the D365 Dashboard the "Edit Filter" button line shortly appears and disappears. I cannot edit the pre-filters in report on the dashboard but I can do it when opening the report in D365 directly.

Any idea what is missing? The fetchxml tag "enableprefiltering"="true" (was set to true) and I have no idea what is missing...

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,571 Reputation points
    2021-05-24T05:57:43.837+00:00

    Hi @Eljakim Seemann ，
    This does not seem to be a problem with the SSRS report itself. If it is a problem with the Dynamics 365 dashboard, please consult relevant experts.
    If you have any questions about the report itself, you can always feel free to let me know.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Eljakim Seemann (Contractor) 1 Reputation point
    2021-10-20T14:20:41.437+00:00

    Hi Joyzhao, can you forward my question to a microsoft dynamics 365 expert? Otherwise I have to open a case.

    0 comments