Global settings on Font type ,style,size etc SSRS reports property

ajit melepat 21 Reputation points
2022-08-11T06:49:09.523+00:00

I am beginner in SQL reporting , I have a set of reports in a project that done for a client.
Fonts style,size are everything customized for them.
But Now I want to customize these project and reports to other customers .
Is there any way to set the Font style ,Font Size (heading and data separate) globally . it should be reflected all reports(font properties) by changing the values at one place.

this is what my idea,

  1. store logo,font style,font size,headings,address of the client etc. in a table
  2. set a parameter in each report - like a global parameter .
    all reports should fetch the value of font size,style and change the existing font property

Hope you could understand my query

Thank you in advance.

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,290 questions
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,814 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,312 questions
0 comments
Accepted answer
  1. Aniya 151 Reputation points
    2022-08-11T08:12:09.85+00:00

    Hi @ajit melepat
    I haven't tried using parameter settings. The way I can find is to write a console application that loads the RDL and manipulates the XML structure, changing the font properties by changing the XML code.
    Annie

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chelsea 1 Reputation point
    2022-08-11T08:20:15.427+00:00

    Hi @ajit melepat ,
    You can get the properties pane with "F4" and set the properties such as color and font in the properties pane.

    230306-image.png

    Or you can select the report in the Solution Explorer pane, right-click, then View Code, and change the report properties globally by changing the code.

    230307-image.png
    Best Regards,
    Chelsea