Previous Topic  Next Topic

Advanced Exporting With JSPs

You can use a JavaScript function for exporting to different formats, display the buttons for one-step export on the toolbar, control user access to different export formats, and customize the warning messages when exporting reports to XML. This topic describes how you can perform advanced exporting using JSPs.

This topic contains the following sections:

• Exporting a Report Using a JavaScript Function
• Customizing Buttons for One-Step Exporting
• Controlling User Access to Different Export Formats
• Customizing Warning Messages

Exporting a Report Using a JavaScript Function

Page Report Studio provides you with a JavaScript function which enables you to open a report or export it in a specified format. You can find this function in the file API.js in <install_root>\public_html\javascript\dhtml, as follows:

function user_oneStepExport(type, options)

The following explains this function's two parameters, type and options.

type - The export format.

• HTML = 0
• PDF = 2
• PS = 3
• RTF = 4
• TEXT = 5
• EXCEL = 6
• XML = 7

options - The values of the options of each format. It is a string array whose member is of the format "key=value". See the options:

Key	Description	Available Value	Default Value
HTML
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the report output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
browser	Specify the web browser type.	0 - IE or Chrome 1 - Firefox	0
imagetype	Specify the type of the images in the output file.	0 - Decided by Page Report Studio 1 - GIF 2 - JPG	0
overflow	Specify the overflow type.	0 - VISIBLE 1 - HIDDEN 2 - VERFLOWCOUNT	0
resolution	Specify the HTML resolution.	Any integer between 1 and 4294967296	96
title	Specify the title for the HTML file.	Any string	""
css	Specify whether to embed the cascading style sheet in the exported HTML files.	true, false	false
multi	Specify whether to generate an HTML file for each page of the report output.	true, false	false
hyperlink	Specify whether to contain hyperlinks in the HTML file.	true, false	false
pagenumber	Specify whether to contain page numbers in the HTML file.	true, false	false
drilldown	Specify whether to include the drilled-down file in the exported HTML file.	true, false	false
no_margin	Specify whether to remove the original margins.	true, false	false
absolute	Specify whether to make the font size fixed in the web browser.	true, false	false
PDF
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
no_margin	Specify whether to remove the margin.	true, false	false
simulate	Specify whether the mode is to be Simulated Printing Mode.	true, false	true
standard	Specify whether to set the mode as Standard Mode.	true, false	false
content	Specify whether to contain the TOC in the exported PDF file.	true, false	false
drilldown	Specify whether to include the drilled-down file in the exported PDF file.	true, false	false
encrypt	Specify whether to encrypt the report.	true, false	false
compress	Specify whether to compress the images in the report.	true, false	false
ratio	Specify the percentage with which to compress the images in the report.	Any integer between 1 to 100	20
compatibility	Specify the encryption compatibility.	0 - Acrobat 3.0 and later 1 - Acrobat 5.0 and later	1
doc_psw	Specify the password for opening the PDF file when encrypt=true.	Any string	""
permi_pasw	Specify the password for printing and editing the PDF file when encrypt=true.	Any string	""
printing	Specify the PDF printing mode.	0 - Prevents users from printing the file 4 - Allows low resolution-printing 2052 - Allows high-resolution printing	0
changes	Defines which editing actions are allowed in the PDF file.	0 - Prevents users from making any changes to the file 1024 - Allows inserting, deleting, and rotating pages 256 - Allows users to fill in form fields and adding digital signatures. 32 - Allows users to fill in form fields and add digital signatures and comments 40 - Allows users to do anything except extracting pages 2108 - Allows all	0
enable_copy	Specify whether to allow users to copy the file contents.	true, false	false
enable_access	Specify whether to let visually impaired users read the document with window readers.	true, false	true
PostScript
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
no_margin	Specify whether to remove the margins in the PS file.	true, false	false
RTF
to_version	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
rtf_flow	Specify whether to apply a flow layout when exporting the report to RTF.	true, false	false
no_margin	Specify whether to remove the margins in the RTF file.	true, false	false
Text
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
repeat	Specify whether to replace a field value of a record with that of its previous record if the field value is null.	true, false	false
compress	Specify whether to compress the clearance between columns.	true, false	false
win_linebreak	Specify whether to use Windows end-of-line characters.	true, false	true
normal	Specify whether to generate the report to a standard text file.	true, false	true
quote_mark	Specify whether to mark the fields in the exported file with quotation marks.	true, false	false
head_foot	Specify whether to contain all headers and footers in the report.	true, false	true
delimiter	Specify the delimiter.	Any single character
width	Specify the user defined character width.	An integer
height	Specify the user defined character height.	An integer
Excel
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
wrap	Specify the word-wrap setting.	0 - All Keep Existing 1 - All Disabled 2 - All Enabled	0
new_layout	Specify whether to use the new layout mode.	true, false	true
shapes	Specify whether to include the shapes in the exported file.	true, false	false
excel_2000	Specify whether to export the report in Data Format, which means Server only exports the report data without format.	true, false	false
advanced	Specify whether to apply the advanced options.	true, false	false
header	Specify the page header text.	Any string
footer	Specify the page footer text.	Any string
gridline	Specify whether to print gridlines when printing the exported Excel file.	true, false	false
XML
to_ver	Specify whether to save the report to version.	true, false	false
to_open	Specify whether to export and open the output file.	true, false	false
to_local	Specify whether to save the report to a local file.	true, false	false
only_data	Specify whether to only contain the database column information in the exported XML file.	true, false	false
schema	Specify the name of an existing schema file with its full path with which to generate the XML file.	An existing schema file with its full path.

• The three options to_ver, to_open, and to_local are mutually exclusive, that is, only one of them should be true, and the rest false. If you set two or three of them to true, Page Report Studio only accepts the first true and treat the rest as false. If you set all three to false, Page Report Studio considers to_open as true.
• In the string array options, the members are separated by commas (","). You can arrange the members in any order, and omit those keys where you want to use the default value. For example, you can define a variable html_options:

  var html_options = ["imagetype=1", "resolution=120", "hyperlink=true", "no_margin=false", "title=hello world"];

  Then, you can use user_oneStepExport(0, html_options) to obtain a URL for exporting a report in HTML.

• Page Report Studio also provides the function user_downloadReport(type, options) whose usage is similar to user_oneStepExport.

Back to top

Customizing Buttons for One-Step Exporting

Server provides seven buttons for one-step exporting. They are Export to PDF, Export to Excel, Export to RTF, Export to HTML, Export to Text, Export to PS, and Export to XML. By default, the buttons are invisible on the Page Report Studio toolbar. You have to add them to the toolbar by modifying the index.jsp file in <install_root>\public_html\dhtmljsp.

Use the following two API functions to control the buttons:

• public void customizeToolbar(String SessionId, String RptSetId, String toolbarname, int[] buttonId);
  
• public void customizeToolbar(String SessionId, String RptSetId, String toolbarname, int[] buttonId, boolean isVisible);
  

Explanation of these parameters:

• SessionId - session ID, which can be retrieved by DHTMLUtil.getSessionID(request).
• RptSetId - report ID, which can be retrieved by obDHTMLUtil.getRptSetId(request).
• toolbarname - toolbar name, such as "Standard", "Analysis", "View", or user defined ones.
• buttonId[] - toolbar button ID. It is an integer array, so you need define an integer array variant.

  For example: int[] mybuttonid ={DHTMLConstant.TOOLBAR_EXPORTTOPDF, DHTMLConstant.TOOLBAR_EXPORTTOXLS, TMLConstant.BTN_EXPORT_TO_RTF}

  The array elements available for one-step exporting are:

  • DHTMLConstant.TOOLBAR_EXPORTTOPDF
  • DHTMLConstant.TOOLBAR_EXPORTTOXLS
  • DHTMLConstant.TOOLBAR_EXPORTTORTF
  • DHTMLConstant.TOOLBAR_EXPORTTOHTML
  • DHTMLConstant.TOOLBAR_EXPORTTOTEXT
  • DHTMLConstant.TOOLBAR_EXPORTTOPS
  • DHTMLConstant.TOOLBAR_EXPORTTOXML
• isVisible - whether to show the buttons defined with buttonID[]. true -- show, false -- hide. This parameter can be absent, and then the value is true.

For example, if you want to add the Export to HTML button to the Page Report Studio toolbar, then:

1. Open the file index.jsp.
2. Add the code

   int[] temparray = {DHTMLConstant.TOOLBAR_EXPORTTOHTML};
dhtmlConfig.customizeToolbar(SessionID, RptSetId, "Standard", temparray, true);

   before

   //<!-- Tool Bar -->
if(dhtmlConfig.isFeatureEnabled(SessionID, RptSetId, DHTMLConstant.FEATURE_TOOLBAR)){

3. Start Report Server.
4. Run a report in Page Report Studio, and you will see a new button Export to HTML on the toolbar.

To add more than one button to the toolbar area, for example, adding Export to HTML and Export to PDF buttons to the toolbar:

1. Open the file index.jsp.
2. Add the following code

   int[] temparray = {DHTMLConstant.TOOLBAR_EXPORTTOHTML, DHTMLConstant.TOOLBAR_EXPORTTOPDF};
dhtmlConfig.customizeToolbar(SessionID, RptSetId, "Standard", temparray, true);

   before

   //<!-- Tool Bar -->
if(dhtmlConfig.isFeatureEnabled(SessionID, RptSetId, DHTMLConstant.FEATURE_TOOLBAR)){

3. Start Report Server.
4. Run a report in Page Report Studio and you will see the buttons Export to HTML and Export to PDF on the toolbar.
5. Select the added button on the toolbar of the report page, the report will be exported to the corresponding format, using the default values of the format options.

Back to top

Controlling User Access to Different Export Formats

Page Report Studio introduces an access control ability which can restrict different users to export reports to different formats. It achieved this by passing values to the global variable enableTypes in both customize_panel.jsp and save_result.jsp files in the <install_root>\public_html\dhtmljsp folder. The value of enableTypes should be Integer, and Page Report Studio gives you the following integers to represent the corresponding report output types:

Report Result Format	Int. Value
HTML	0
PDF	1
Excel	2
Text	3
RTF	4
XML	5
PostScript	6

You can specify a value or an array to enableTypes using the integers in the preceding table. Or you can also use the integers which are not mentioned, but if you do so, the Int. values will be ignored, and do not function. That is to say, if you pass the array {1,2,5,9,-2} to enableTypes, 9 and -2 will be ignored and {1,2,5} will work, so PDF, EXCEL, XML formats can be in use.

Assume that there are two users, user1 and user2. When user1 signs in, run a report in Page Report Studio, he can only export the report as PDF and HTML formats. While user2 can export the report as RTF and XML formats when signing in. To realize it, you can use the following codes in customize_panel.jsp or save_result.jsp file:

                int[] enableTypes=null;
String UserName=null;
UserName=DHTMLUtil.getUserName(request);
if(UserName.equalsIgnoreCase("user1"))
enableTypes=new int[]{1,0};
if(UserName.equalsIgnoreCase("user2"))
enableTypes=new int[]{4,5};       

Back to top

Customizing Warning Messages

You can customize the warning messages when exporting reports to XML through Page Report Studio. With this function, you can specify what you want to show as a warning message. Server supports the custom warning messages across web browsers.

To customize the warning messages, you need to customize the JSP files using either of the following two methods:

Method 1

1. Open the save_result.jsp file in the <install_root>\public_html\dhtmljsp folder with your favorite editor.
2. Specify the value of customMsgForXML in the save_result.jsp to whatever you want. The value cannot be "" or null.
3. Run a report in Page Report Studio.
4. Select Menu > File > Export to display the Export dialog box.
5. Select XML from the Select Report Result Format drop-down list
6. Modify other properties.
7. Select OK. Server displays a warning message as you have defined.

Method 2

You can also export reports via the Export panel instead of selecting Menu > File > Export. By default, Server hides the panel. So, the following is another way to create custom warning messages:

1. Open the customize_panel.jsp file in the <install_root>\public_html\dhtmljsp folder with your favorite editor.
2. Set the class of panelDIV to visibleMargin to show the Export panel on web browser.
3. Specify the value of customMsgForXML in customize_panel.jsp.
4. Run a report in Page Report Studio, and the Export panel together with the report shows.
5. Select XML from the Select Report Result Format drop-down list
6. You can modify other properties.
7. Select OK. Server displays a warning message as you have defined.

For example, using method2, when you need to export reports as XML, and if you want to show "This is IE Browser" while browser is IE, you need to set panelDIV in customize_panel.jsp file to visibleMargin:

<div id="<%=DHTMLConstant.DHTML_PREFIX%>panelDIV" class="visibleMargin">

And then customize CustomMsgForXML in the same jsp file:

String browserName=request.getHeader("User-Agent");
String customMsgForXML ="This is "+browserName;

Access Report Server via IE, run a report in Page Report Studio, select XML from the Select Report Result Format drop-down list in the Export panel, and select OK. Then a pop-up box will show you "This is IE Browser".

Back to top

Previous Topic  Next Topic