Converting Excel Column with To SSRS (inch or pt)

I have report in Excel that I user gave me and wants the same exact format in the new SSRS report. So if I have a column in excel of the width 14.14 (103 pixels) what should that be for the width of that column in SSRS ( in, mm, cm, pt, or pc)?

I can't get the correct factor because it seems to differ based on size?

Excel Width     Pixels   Ratio  
0.08            1        0.08   
0.83            10       0.083  
13.57           100      0.1357 ??
142.14          1000     0.14214    
254.71          1788     0.142455257    

I understand pixels per inch is dpi dependent, but what I am looking for is a printable equivalent.

Answers


Excel (and many other MS related apps) default to 96 pixels per inch.

So your 103 pixel wide Excel column should be: 103 / 96 = 1.073 inches (Rounded to thousands.)

Of course many printing options will change this, such as "Fit on one page."


Here is what I found out about the relationship between excel and ssrs. It seems excel uses 96 pixels per inch. I also found using units of PT in ssrs translates much more accurately into excel and is actually mentioned somewhere in the MSDN documentaiton.

In excel a column of 10 = 75 pixels, 20 = 145 pixels, etc. Basically the units are 70 plus an additional 5 pixels.

So to set the column in ssrs I used:

[Width in PT] = ([width in excel] / 10 * 70 + 5) / 96 * 72)

For example: Width 10 in excel = 75 pixels = 56.25 pts = .78125"


Need Your Help

Is it possible to use validation with express static routes?

node.js validation express static

I'm using jwt token validation in my project to protect some importent data:

Replace Div when hover other Div

javascript html css hover css-tables

I want to replace the Divs in a table when I move the mouse over different Divs