Report design in points (pt)

On our project we export SSRS reports to Excel.

Report Definition Language (RDL) enables you to use several measurement units (for example, inches, pixels, centimeters, and points) to specify position and size values. However, Excel uses only points. Therefore, the SSRS Excel rendering extension converts the height and width of the table, the heights of the rows, and the widths of the columns to points. This process may include rounding some values. In this situation, the table height or width and the sum of the row heights or column widths are different. To compensate for the difference, the SSRS Excel rendering extension inserts a small row or column to the workbook.

To prevent that hidden row or column, we configure the table height and width to a value specified in "pt" (points) rather than "cm". 1 cm is about 28 points.

Is it possible to configure SSRS to use points by default while designing a report?

April 24th, 2015 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics