Pages

Thursday, May 9, 2013

BI Publisher Parameters in the URL

Through this post am discussing about the parameters specified in the report link / URL

Consider a URL like this

http://<ip/address>:<Port>/xmlpserver/Sales/Sales+Report/Sales+Report.xdo?_xpf=&_xpt=1&_xdo=%2FSales%2FSales+Report%2FSales+Report.xdo&Id=1-104x&_xt=Standard&_xf=html

The URL after the report name consists of:

?_xpf=&_xpt=1&_xdo=%2FSales%2FSales+Report%2FSales+Report.xdo&Id=1-104x&_xt=Standard&_xf=html

Note the following standard URL syntax:

? - The first parameter is added with a question mark in the beginning.

& - Additional parameters have to be specified like this.

The BI Publisher parameters are as follows:

_xpf - Its an application internal string. Not to be used by the developer.
_xpt - Chooses the report rendering way or style.

    0 - uses the BI Publisher window (iFrame)

    1- renders just the document

_xdo - Provides the path to the current report. To be note that it is not mandatory to give this parameter.

dept - Report specific parameter that we created in the report.

_xt - Specifies the template to be used. Usually for the reports which have more than one templates.

_xf - Controls format of the output file. Accepted values are: pdf, html, excel, rtf, or data.

2 comments:

  1. nice tips... but, it does work?? im trying to access a BI publisher report using url parameters... :S

    ReplyDelete
  2. When I tested it all of them worked, provided the report is in a folder which is open for guest access. :)

    ReplyDelete