Change font in entire SSRS report

mukul.poonia 21 Reputation points

I have a SSRS report built in Visual Studio. Approx 30 pages. And I want to change the font (different size, some places bold etc.) across. are there better ways to do it other than manuallt going in each table/ text box and changing? Is there a way to parameterize these?

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

Accepted answer
  1. Olaf Helper 43,161 Reputation points

    Note:If you mess up with the XML code

    Quite right, and keep in mind that XML ist case sensitive, want wrong case in writing and the report will error out.

    1 person found this answer helpful.
    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points

    In Visual Studio do a right-mouse click on the report => "View Code"
    You get the XML code for the report definition, here you can e.g. do "Find&Replace" to change the font; the XML element for the font (family) looks like


    Make a copy of the report, before you modify the XML this way to be on the safe side.

    1 person found this answer helpful.
    0 comments No comments

  2. Joyzhao-MSFT 15,571 Reputation points

    Hi @mukul.poonia ,
    After finishing the report, open the report in XML format by rightclick on report in solution explorer and choose view code. This opens new window with XML code.

    Find and replace the font you want to do.

    After changing the font, when you return to your report, it will throw a warning saying that the code is changed outside the environment, if you accept the changes will be effective in the report.

    Note:If you mess up with the XML code, there is no go back. So as Olaf said, make a copy of the report before you modify the XML.

    Best Regards,

    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.

    1 person found this answer helpful.
    0 comments No comments

  3. mukul.poonia 21 Reputation points

    thanks a lot for your inputs. it proved very helpful.

    0 comments No comments

  4. Dan Henne 1 Reputation point

    Can you edit the theme or template after the report has been created.

    <df:DefaultFontFamily>Segoe UI</df:DefaultFontFamily>

    0 comments No comments