Readers:
Here is another blog re-post from my friend, Bryan Brandow’s MicroStrategy site.
If you want to directly visit Bryan old site, the URL is http://www.bryanbrandow.com.
Best Regards,
Michael
Bryan originally posted this on July 22, 2011.
Removing Sections of a Report via URL API
While working with the Web SDK to try to make a small customization, I stumbled on a pretty useful set of URL API codes that allow you to quickly modify the Report Page by removing various elements. While such customizations are common, I wasn’t aware that they were available out of the box. I would think that these would be very useful in doing simple linking to reports via an IFrame from another application, such as a Portal.
The trick to get the URL for a Report by right clicking it in Web, choosing Properties, and then copying the Link at the bottom. Now, locate the src section of the URL:
ASP:
&src=Main.aspx.4001
JSP:
&src=mstrweb.4001
and add in one of the transforms just before the .4001.
Available transforms that I’ve found:
reportNoHeader
reportNoHeaderNoFooter
reportNoHeaderNoFooterNoPath
reportNoHeaderNoFooterNoPathNoToolbar
Example:
ASP:
&src=Main.aspx.reportNoHeader.4001
JSP:
&src=mstrweb.reportNoHeader.4001
Unfortunately, these are actual transforms and not flags, so you can’t mix and match to fit your needs (for example, if you only want to hide the toolbar, reportNoToolbar will NOT work). Those are the only 4 that you can use that I’ve found, but they may be handy in a pinch and best of all, not require customization work to use.
Update:
Another method of doing this that does let you pick and choose and supports documents as well:
&hiddenSections=header,footer,path,dockTop
Place that code in the URL, for example (Note: I have shown this on multiple lines. You should paste this in as one long line with no line breaks):
http://webserver/Microstrategy/asp/Main.aspx?Server=ISERVER&Project=PROJECT&Port=0&evt=2048001
&hiddenSections=header,footer,path,dockTop&src=Main.aspx.2048001
&visMode=0&documentID=04AACFE445AD69198676C8AD56245118
¤tViewMedia=2
List of options (case-sensitive):
- header
- path
- dockTop
- dockLeft
- dockRight
- error
- content
- dockBottom
- footer
Bryan’s Blog Entry Link: http://www.bryanbrandow.com/2011/07/removing-sections-of-report-via-url-api.html
Leave a Reply