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

Accepted answer
  1. Olaf Helper 45,371 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.

4 additional answers

Sort by: Most helpful
  1. Olaf Helper 45,371 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 No comments

  2. Joyzhao-MSFT 15,601 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 No 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 No 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 No comments

Your answer

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