Printing and exporting reports

There are many ways to deliver a report; one of them is the PDF format. The main advantage of PDF is that it can be easily distributed, printed, and most of all cannot be tampered with…

MicroStrategy allows you to export the grid in several other formats including but not limited to Microsoft Word and… yes, Excel.

Getting ready

In order to complete this recipe you need to have Adobe Reader installed on the machine.

How to do it...

Open the 20 Cities sorted by SalesAmount report, if it's not already open, and follow these steps:

  1. Go to Data | Export To and select PDF File from the nested menu.
  2. If you have Adobe Reader installed, you'll see the ready-to-print PDF document; otherwise, the file will be saved in your %temp% folder. Notice that the original colors are maintained.
  3. Close or minimize Adobe Reader and go to the Data | Export To menu; this time select HTML File.
  4. The report will be opened with your default browser, this time in HTML format.
  5. Minimize or close the Internet browser and go to Data | Export To. You may select Text File and the Notepad would show a tab delimited version of the data.
  6. Or you can prefer Export To | MS Excel and—if the application is installed—have a look at the data with your favorite spreadsheet software.
  7. If you want to print the report, go to the File | Print menu.

How it works...

MicroStrategy internally stores report data as XML. It then renders the output to fit the desired format.

There's more...

If you don't want to see the title and description, or the filter details in the exported file, you can open the Data | Export Options menu:

  1. In the Export Options window, select the application that you are using to export, for example, HTML File.
  2. Click on the Appearance tab and in the Exported fields list check or uncheck which details you want to appear in the output, see the screen capture:
    There's more...

    Note

    You can watch a screencast of this operation at:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset