Tuesday, November 20, 2012

What is quick switch and how to enable it in MicroStrategy Report Services Documents?

Quick switch is a feature in MicroStrategy Report Services Documents which is used to switch a dataset report between grid view and graph view in interactive mode or flash mode. A quick switch button will be displayed on left top corner of dataset report when hovering the mouse on top of the dataset report. The report switches to grid view (if it's in graph view currently) or graph view (if it's in grid view currently) when clicking on the the quick switch button, as shown below:

"Web change view mode" privilege under "Web Reporter" should be assigned for a user to be able to see quick switch button in Web.

In Desktop 

  • Right click on the dataset report in document editor
  • Navigate to "Properties"  and switch to the  "Grid" tab.
  • Check the "Quick switch" check box.
In Web
  • Right click on the dataset report in document design mode.
  • Click on "Properties and Formatting..." on the menu.
  • Click on "Layout" in the popped out dialog.
  • Check the "Quick switch" check box.    

Friday, November 16, 2012

How to show the grid on top of the graph in a Grid Graph View report through customization?

In MicroStrategy Web, when a Grid Graph View report is executed, the grid always appears below the graph.

In order to have the grid appear on top of the graph, follow the steps below:

  1. Make a backup of the ReportGridGraphLayout.xml file in the WEB-INF\xml\layouts folder.
  2. Open ReportGridGraphLayout.xml and interchange the following two lines, so that grid is on top of the graph:

      <mstrlayout:render name="graph" />
      <mstrlayout:render name="grid" />
  3. Restart the Web Server.

Thursday, November 1, 2012