Change Fonts and size report wide

[tshad]

Is there a way to change all my fonts to a particular family or size for the whole report.?

I have about 20 reports that were created with "Arial, 10pt, Default, Default, Default". The company wants to change this to "Arial, 11pt, Default, Default, Default" for all the reports. I thought I could do this from the Code but the code does not have "Arial" anywhere and the sizes are all 9pt????.

Obviously, the report is not using the information from the code file but somewhere else. Is there a way to change this without having to go to each cell to make the change?

Thanks,

Tom

 

[xlbo]

You should be able to use "Select All" to select all report elements then go to the properties window and amend the font

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[DaveInIowa]

I've wondered how to do this myself. I also have looked for a way to set default font attributes when adding new text boxes. No luck on either count so I end up setting one text box then copying its font property then selecting and pasting that value into my remaining text boxes.

Geoff - I'm using Visual Studio 2008 and whenever more than one text box is selected, the Font property is not available, neither in the Properties window or by right-clicking one of the selected text boxes. Do you have this capability in the version you're working with?

 

[xlbo]

Hi Dave - using VS 2008 with SQL Server R2

This can be done only when all selected items are of the same type so if you have a table / list plus textboxes, you can't use select all - you can use ctrl + mouse to select all textboxes and apply that way...

Unfortunately you cannot change the default font in SSRS - what I have done as a workaround in the past is to have a template report that has each report object type pre-set with formatting in advance. I then just copy items from this report template into any new report I am creating to reduce the formatting overhead

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[DaveInIowa]

Thank you for the information Geoff. This must be a new feature to R2. Right now, even if I use Ctrl+click to select multiple textboxes and even if the textboxes have the same font attributes, the Font property disappears.

 

[xlbo]

Odd - I'm sure I remember that working on 2000 (jumped straight from 2000 to 2008/R2) as well but it's been a little while so it is quite possible that I just blanked out the pain of having to do that operation for each textbox!



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question