KB14792: When setting ‘Fixed Columns and Rows’ to a non-whole number for a grid report in a Report Services document, the number changes automatically in MicroStrategy Developer 9.x and 10.x

SYMPTOM:
The 'Fixed Columns and Rows' grid options for a Report Services document in Strategy Developer 9.x and 10.x does not retain the custom value set by the user. When setting a fixed value for a column in the grid of a report to a non-whole number, the Report Services document does not retain that value. The value will automatically change to a value that is a tenth of an inch less than the original value.
 
STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue in the Strategy Tutorial project:
 

• Create a document with any base report. Place that base report in the Detail Header section of the Report Services document. Make sure that the report is set to 'Grid' view, as shown below:
  

• Double-click on the grid in the Detail Header section. When the grid is highlighted, go to 'Grid' on the toolbar and select 'Options' as shown below:
  

•  
  If the grid is not highlighted, there will not be an option to select 'Grid' on the toolbar. If the grid in the Detail Header section cannot be double-clicked, users can simply right-click on the grid in the Detail Header section and select 'Edit Grid'.
   
  
• Select the 'Columns and Rows' tab. Select the 'Fixed' radio button in the 'Columns' section and select 'All Columns' by using the drop down menu box. Then, set the value of that column to 2.4 inches and click OK, as shown below:
  

• Repeat step two and select the 'Columns and Rows' tab again. In the 'Columns' section, use the drop down menu box to select 'All Columns'. Notice how the number is different from the original (2.4). Notice that the value is now '2.39583333' inches, as shown below:
  

CAUSE:
The product is working as designed. The reason why the value changes is because the value inputted as inches is converted into pixels when calculating width and height. The number of pixel points is an integer, not a decimal. So, a fractional input value in inches (e.g. 2.4) will be converted and rounded into pixels (integer value), and then converted back and shown as inches. After the conversion, the inches may not match exactly to the number before the conversion.
 
ACTION:
An enhancement request has been submitted to show the pixel display. Contact Strategy Technical Support for an update on the status of this enhancement request.