Report Page Setup - Paper size

I use next setup for the reports that are displayed in HTML and PDF formats and need to be ready for printing.

Report Properties - Page Setup

Report Properties > Page Setup I have inches for units because I couldn't set size right with centimeters. When orientation is portrait then Width: 8,27in and Height: 11,69in. (For landscape - the other way round.)

Page margins are 0,5 inches so that it's easy to control report body width in relation to paper size. I have the ruler displayed in report designer and I set report body width to some what 7,2in (paper width 8,27in - margins 2*0,5in). Now report content won't exceed paper width and printing blank papers is avoided.

MS SSRS - Sorting chart axis labels

In the beginning I had difficulties to remember where to find sorting options for the chart axis labels. Clicking around chart area and checking properties got to my nerves but then I decided to write it down for the future and then I begin to remember. I thought this would be useful post to some others too. In this example I add sorting to x-axis "finished_month".

[ 1 ]   Click over x-axis labels so that x-axis category field is seen
[ 2 ]   Right-mouse click open  Category Group Properties and add sorting.
 

x-axis labels - sorting

Notice...

[ 3 ]   It doesn't show anything at Chart Member Properties: SortExpression box. You have to click it open to see the sorting options for that Chart Member.