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,729 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,561 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 No 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 No comments