EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB236667: Exporting a grid in Outline mode to Excel that has one column width set to zero results in only displaying the column headers in MicroStrategy Web 9.4.1 Hotfix 5


Community Admin

• Strategy


SYMPTOM:
In Strategy Web 9.4.1 Hotfix 5, a user can choose to display a grid in a Report Services Document in Outline Mode. However, when setting one column of that grid to a width of zero, and exporting to Excel, no data is displayed. In the image below, the results of the excel export show a blank grid with only the column headers.

ka04W000000OhNCQA0_0EM4400000025g7.jpeg

 
STEPS TO REPRODUCE:
Follow these steps to reproduce the issue in a Strategy Tutorial project.

  • Create a document.
  • Add a grid with formatting, as shown below:
ka04W000000OhNCQA0_0EM4400000025g5.jpeg
  • Edit the grid from above by going into Properties and Formatting > Layout, and selecting Outline.
  • Change the column width of the left most attribute to 0. See the column width setting in the image below.
ka04W000000OhNCQA0_0EM4400000025g6.jpeg
  • Run the document and export it to Excel.
  • Now the Excel document will show a grid with only the column headers.
  • Increase the column size, and the grid will display correctly, as shown below.
ka04W000000OhNCQA0_0EM4400000025fr.jpeg

 
CAUSE:
This is a known issue with Strategy Web 9.4.1 Hotfix 5.
 
ACTION:
Currently this issue is still being reviewed  by our Technology team and it is not currently scoped for any upcoming scheduled Strategy release. 
 
The Strategy Internal Reference Number for the issue discussed in this technical note is 1014215.


Comment

0 comments

Details

Knowledge Article

Published:

May 24, 2017

Last Updated:

May 24, 2017