Need some help on formatting header in report

  • I am a newbie. I am working on SSRS report on OLAP data. I created the report and later I had to add few columns. But the the header doesnt seems to be at center now. Since I added few columns at right of the report it is more towards left and not at center. But the properties still show the header is aligned to center. Any thoughts??

  • Hi,

    Adding a screenshot would have helped very much.

    Anyways, First thing which is not clear from your post is what type of Header it is?

    1) A column Header? as used in report tablix?

    If Yes - Solution to it is that you single click on the header textbox so as to select it,right click and select 'Text Box Properties', go to Alignment tab and in the 'Horizontal' drop down, select 'Centre'. Same you can do with 'Vertical' drop down.

    2) Is it a Report Header(as in Header and Footer?) - If yes, again the same rule as mentioned above applies, however what else you can do is to adjust the length of the textbox where you have your report header. Since the Title of report is sually static and you know the length, it would be sensible to adjust the length of the textbox to fit it completely and again follow steps as mentioned in point 1.

    Does it help ?

    Athar Iqbal

  • Sorry for not posting the question properly...I merged all the newly added fields with the old ones and aligned the header to centre. It solves my problem.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply