How to write ssrs xxpression make last name bold if same or duplicates.

Anonymous
2023-02-27T16:56:42+00:00

I have a report in SSRS I have been given a requirement the user wants the last name on the report to be bold if they are the same.  No idea what the expression would be.

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,798 questions
{count} votes

Accepted answer
  1. AniyaTang-MSFT 12,311 Reputation points Microsoft Vendor
    2023-02-28T03:01:29.86+00:00

    Hi @Jannette Jones

    I did a simple test.

    Here is my raw data if last name is in a separate column.

    1

    Then add a row group grouped by "LastName", right-click on the newly-appeared "LastName" column, select Delete Column -> Delete Column Only. 2

    Then right-click the cell property that you want to highlight duplicates, select "Font", and add an expression in "Bold", the result is as shown in the figure below.

    3

    4

    Best regards,

    Aniya


0 additional answers

Sort by: Most helpful