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

KB45709: Grids get cut off in dashboards when exported in PDF or Excel in MicroStrategy


Community Admin

• Strategy


When exporting a dashboard to any format (PDF, Excel, etc.), grids get cut off to stay true to the design of the document.  Behavior in previous versions of MicroStrategy allowed for grids to overflow and show all the data without the window getting cut-off for exports.  Steps to show all the data in exports are explained in this article

Symptom

The behavior has changed in Strategy 9.3 and later.  Windows stay true to the size of the actual panel.  Settings need to be modified so that all the data can shown.
Export that gets cutoff:

ka04W0000014839QAA_0EM4400000029Tz.jpeg

Cause

Settings have changed from earlier versions to better support documents/dashboards and the introduction of Mobile.  Panels are designed to stay at one size, especially with exports, so that panels and windows are not overlapping.  However, the one caveat is that data sometimes gets cut-off for the sake of the design of the dashboard.
 

Action

1. Right-Click on Grid and go to 'Properties and Formatting'.
2. You must disable the Title Bar for this to work.  Make sure 'Show Title Bar' is unchecked.
3. Go to 'Layout' and change 'Grid Overflow (PDF & Excel)' to 'Fit to grid contents'.
**Note that if the Title Bar is not unchecked, this option will not be visible.
4. Also in the 'Layout' menu, change the Width and Height to 'Fit to contents'.
5. Right-click the background of the dashboard and go to 'Properties and Formatting'.
6. In 'Layout', make sure 'Height can shrink' and 'Height can grow' are checked.
Export the dashboard and the data should be expanded to show.
Now the export should show all data&columns:

ka04W0000014839QAA_0EM4400000029U2.jpeg

 


Comment

0 comments

Details

Knowledge Article

Published:

May 23, 2017

Last Updated:

May 23, 2017