The Strategy 9.x metadata supports reports with a template on prompt, such as the Report Wizard report template included in the metadata shell. It is also possible to create this type of report using the Strategy Intelligence Server SDK.
The following lines show how to define a prompt in template using Visual Basic:
' Get the reports embedded folder
Set oEmbeddedFolder = oReport.Info.Embedded
' Create embedded template
Set oTemplate = oEmbeddedFolder.Add(DssTypeTemplate, "Local Template")
' Set template on the report
Set oReport.Template = oTemplate
' Create the template prompt
Set oPrompt = oEmbeddedFolder.Add(DssTypePrompt, "Prompt on all templates")
' First we need an appropriate search
Set oSearch = oEmbeddedFolder.Add(DssTypeSearch, "Search for all templates")
oSearch.Types.Add DssTypeTemplate
' Define the prompt object as a choose from all templates
' We want the user to pick at least one and no more than one template
With oPrompt
.PromptType = DssPromptObjects
.Reuse = DssReusePreviousOrBreak
.Minimum = 1
.Maximum = 1
.Restriction = oSearch
.Title = "Choose a template"
.Meaning = "Please select the template you would like to use for the report:"
End With
' Add the prompt as the template prompt property
Set oReport.TemplatePrompt = oPrompt
' Save report
oISource.SaveObject oReport, oTemplateReportFolder To find more information on the meaning of the properties, interfaces and calls used, please refer to the Strategy Intelligence Server API Developer Reference manual shipped with Strategy SDK.
The example provided in this document is provided “as-is” and user has read the following customization warning:
ADDITIONAL INFORMATION:
The Strategy SDK allows you to customize several Strategy products and extend and integrate the Strategy business intelligence functionality into other applications. However, before changing the way Strategy products look or behave, it is helpful to understand how the application is built. For more information regarding the Strategy products or the process of customizing Strategy products, please refer to Strategy Developer Zone (
https://developer.microstrategy.com).
To access the Strategy Developer Zone, you must have access to the Strategy Knowledge Base, you must have purchased the Strategy SDK, and you must be current on your Strategy maintenance agreement. If you are a US-based business and believe that you satisfy all three of these conditions but you do not have access to the Strategy Developer Zone, please contact Strategy Technical Support at
support@microstrategy.com or at (703) 848-8700. If you are an international business, please contact Strategy Technical Support at the appropriate email address or phone number found at
https://www.microstrategy.com/us/services/support/contact.
CUSTOMIZATION WARNING:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. In the event of a code change in future builds, Strategy may not be able to provide additional code on this matter even though this customization is provided at this time for this specific build. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.
6738
