KB19667: How to hyperlink from a Report Services document to a report based on a selector element in MicroStrategy Developer

The following procedure describes how to hyperlink from a source Report Services document to a target report based on the Category attribute selector in Strategy Developer (formerly Desktop)
 

• Create a target report and save it as target_report:
   
  
• Row: Category, Subcategory
• Column: Revenue
• Prompt: Category attribute qualification

• Create a source report and save it as source_report:
   
  
• Row: Year, Category
• Column: Revenue

• Create a new Report Services document from the source_report, and create a selector control from Category, as shown below:
  

• Insert a panel and place text box for hyperlink on it, as shown below:
  

• From properties of text, set hyperlink to the target report. Value prompt answers can pass to the target report using &valuePromptAnswers={Attribute_name@ID}, as shown below:
  

• Example of hyperlink:
   
  http://server_name/MicroStrategy/asp/Main.aspx?Server=server_name&Project=project__name&Port=0&evt=4001&src=Main.aspx.4001&reportViewMode=1&reportID=5508DBAA4FCA1EBC4E0A1D8F9B1B3876&valuePromptAnswers={Category@ID}
  
• Select the panel created in step 4 as target of selector control, as shown below:
  

• Execute the Report Services document, as shown below:
  

• Now users can navigate to the target report from hyperlink text. This target report succeeds category from source documentation, as shown below: