GeeKs Blogging @ dotCOM

BI – Actuate Reports in PDF format in Siebel

by admin

---

Hi all,

Siebel is well integrated with Actuate Reports, used for reporting and Business Intelligence (BI) perspectives.

Today’s post has been contributed by Tapan Chitkara, a regular visitor to GeeksBlogging@dotCOM. Tapan has deep expertise in Siebel Actuate Reports.

By default, when a report is generated and viewed in the Siebel web client, or selected from Reports Server > My Reports view, the report will be presented in Dynamic HTML (DHTML) format in the web browser. When the user clicks on the Save button , a window will popup prompting to download the report to PDF or Excel. If you select PDF and try to save, the file will be saved as the name of the physical report file on the Server as shown in the image below (Please click on the image to enlarge):

If the default behavior is changed so that the report is always presented in PDF format (skipping the DHTML format), by following method, the report name will be displayed as a URL or default[1].pdf as shown below (Please click on the image to enlarge):

To change this behavior so that the report output will be saved with the same name as the report name in PDF format, the user can modify viewframeset.jsp (for Actuate 7) as follows:

1. Navigate to the following directory:

ACTIVEPORTAL_HOME/Viewer

2. Make a backup of the viewframeset.jsp file.

3. Use a text editor such as Notepad to open the viewframeset.jsp file.

4. Locate the line var sConnectionHandle and add the following:

var varTitle = ““;

For example:

var sConnectionHandle = (<%= bExistConnHandle %>) ? “<%= StaticFuncs.jsEncode(paramBean.getParameter(“connectionhandle”)) %>” : null;
var varTitle = “<%=StaticFuncs.getDocNameForViewerTitle(bExistConnHandle, paramBean)%>”;
 
5. Search for:
 
g_reportFrameURL = “../servlet/GetReportData” + replaceDuplicateParams(replaceDuplicateParams(replaceDuplicateParams(g_objectURL , “format”, “PDF”) , “page” , g_currentPageNumber ) , “scalingfactor” , scalingFactorValue );
 
6. Append + “&/”+varTitle as shown below:
 
g_reportFrameURL = “../servlet/GetReportData” + replaceDuplicateParams(replaceDuplicateParams(replaceDuplicateParams(g_objectURL , “format”, “PDF”) , “page” , g_currentPageNumber ) , “scalingfactor” , scalingFactorValue ) + “&/”+varTitle;
 
7. Delete the Standalone folder to clear the HTTP cache and start the services.
 
This technique is not suggested by Siebel as it could lead to unwanted results at times.

Thanks Tapan, for this wonderful contribution.

Related posts:

1. BI – Upload multiple Actuate ROX files Hi all, Tapan is back with his contribution on the...
2. Siebel – Number of rows displayed in List Applet Siebel Web Client by default shows only the first 7...
3. Siebel – EAI Siebel Adapter – Looping Multiple Records This is a follow-up post on the post, Siebel –...
4. Siebel – Showing red asterisk on a conditionally required field In Siebel vanilla Application, we see a red asterisk (...
5. Siebel – Reading data directly from Siebel SRF SRF or the Siebel Repository File as it is more...
6. Login Failed in Dedicated Web Client : MVF Issue Recently I have met with the Problem in form of...
7. Siebel – Unable to login to mobile client After long time I am writing a blog… This time...