SYMPTOM:
In Strategy 9x, rectangles, lines, and other shapes in a Report Services document are not exported to Excel.
For example, create a Report Services document and drag a grid into the Detail Header. Next, insert a rectangle and two text boxes on top of the rectangle, as shown below. Insert two lines between the two text boxes and run the document in PDF. The results are as follows:
Note: The two text boxes are in yellow and the rectangle is in pink.
Now, export this document to Excel. Notice, however, that the rectangle and the lines are not exported:
CAUSE:
Exporting rectangles and lines to Excel is not supported in Strategy 9.x and has been logged as an enhancement.
ACTION:
Contact Strategy Technical Support for an update of this enhancement request.
Note:
For more information on best practices when building Report Services documents for export to Excel, refer to the following Strategy Knowledge Base document:
