Change font in entire SSRS report

mukul.poonia 21 Reputation points
2021-02-24T09:39:41.403+00:00

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,813 questions
0 comments
Accepted answer
  1. Olaf Helper 41,001 Reputation points
    2021-02-25T07:51:05.387+00:00

    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

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,001 Reputation points
    2021-02-24T11:22:48.447+00:00

    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 

    <FontFamily>Arial</FontFamily>

    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
  2. Joyzhao-MSFT 15,566 Reputation points
    2021-02-25T06:30:58.3+00:00

    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.
    71936-01.jpg

    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,
    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.

    1 person found this answer helpful.
    0 comments
  3. mukul.poonia 21 Reputation points
    2021-03-01T09:20:47.163+00:00

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

    0 comments
  4. Dan Henne 1 Reputation point
    2021-11-12T14:31:07.88+00:00

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

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

    0 comments