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

KB39708: How to show part of the prompt information when exporting report in MicroStrategy Web 10.x


Community Admin

• Strategy


How to show part of the prompt information when exporting report in MicroStrategy Web 10.x

In some business secenarios, it is required to show part of the prompt information in the report. Auto text can be used to show the specific parameters like filter detail, prompt detail, and so on.
 
For Report Services Documents, add the auto text of {&Prompt1&} as shown below to display the first prompt answer:
 

ka04W000000ObHxQAK_0EM440000002SUJ.jpeg

 
For reports, it is currently not supported to use Auto text in Developer. Users can export the report through Strategy Web and show part of the prompt answer in the exported file with the below steps:
 

  1. Run the report in Strategy Web.
  2. Go to Home>Export and click the exporting format.
  3. Click "Edit Custom Settings..." in the prompted window of "Export Options" as shown below:
ka04W000000ObHxQAK_0EM440000002SUN.jpeg
  1. Add the auto text as required as shown below and click "Apply">"Export"
ka04W000000ObHxQAK_0EM440000002SUL.jpeg

The exported file is shown below:

ka04W000000ObHxQAK_0EM440000002SUP.jpeg

Note: The "Edit Custom Settings..." described above is report level setting. After changing the setting, save the report again to keep the setting for further usage.  
 
Meanwhile, the below KB article also describes a method for formatting the section of filter detail to show part of prompt answer:
KB9311: How to display only a portion of a filter detail or a prompt answer in a Strategy 10.x Report Services Document.
39708


Comment

0 comments

Details

Knowledge Article

Published:

July 4, 2017

Last Updated:

March 30, 2019