Conditional Formatting Not Working on SQL Server 2017

Andrew Tunnicliffe 1 Reputation point
2021-01-14T18:35:19.427+00:00

I have created a report with different drill downs all with database driven conditional formatting, however as can be seen in the screenshot one of the levels isn't working on the server (this works on my local laptop), when the report is first run that level isn't expanded.

I have seen a fix for this for other SQL Server versions but not for SQL Server 2017.

Anyone got any ideas?

Thanks

Andrew

56656-screenshot-20210114-182923.jpg

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.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,551 Reputation points
    2021-01-18T08:32:34.637+00:00

    Hi @Andrew Tunnicliffe ,

    Thanks for your detail message of the issue.

    Could please help to run the report in other browser to see if the issue will occur or not?

    I tested it in my machine with SSRS 2017, things work fine.

    You may download the report rdl from web portal and open it in notepad to check if there is expression you set or not .

    57547-screenshot-2021-01-18-161959.jpg

    Please also try to create placeholder over text and then setting it to render HTML.

    57476-screenshot-2021-01-18-162952.jpg

    Noticed that SSRS2017 has a newest release 14.0.600.1669, if possible, you may upgrade to the newest release.

    Regards，
    Zoe

    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.

    Was this answer helpful?

    0 comments
  2. ZoeHui-MSFT 41,551 Reputation points
    2021-01-15T03:18:33.6+00:00

    Hi @Andrew Tunnicliffe ,

    Couldn't fully understand your issue.

    Do you mean that the report is well showing in your laptop but in other pc it doesn't work?

    If you have set the row visibility of display can be toggled by the report item, the level will not be expanded unless we click it.

    Could you give more details about the issue? If possible you may show us the design sample and the conditional formatting expression.

    For the fix of SSRS2017, you may click the SQLServerReportingServices.exe application like shown.

    56974-screenshot-2021-01-15-111449.jpg
    Regards，
    Zoe

    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.

    What can I do if my transaction log is full?--- Hot issues November

    How to convert Profiler trace into a SQL Server table -- Hot issues November

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.