SYMPTOM:
The prompt details {&PromptDetails} defined in the sheet header / footer option does not write symbols when exporting to Microsoft Excel 2007 or later in Strategy Web 9.4.1
STEPS TO REPRODUCE:
1. Create a prompted report. Execute the report and exclude the Category element “Books”. The report execution result is as shown below.
2. Define the sheet header and footer as follows({&PromptDetails}) and export the report to Excel.
3. Only when exporting as Excel 2007 or later (xlsx), the symbols are not displayed.
CAUSE:
This is a known issue in Strategy Web 9.4.1.
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
The Strategy Internal Reference Number for the issue discussed in this technical note is 1014818
242786-
