report designer manual - 18.appendix iii
TRANSCRIPT
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 1/85
Appendix III. Report Designer Parameters
81
Appendix III. Report Designer Parameters
Parameters are set of instructions for controlling the report production.
For example, when you have a report that presents regional sales status, it is possible tomake a report of selected area by using parameter value. In this case, parameters, /rp and
/rv, will be used as ‘parameter value set’.
The following table shows classified list of parameters.
Classification Parameter Name/rdata
/rf
/rfn
/rpost
/rposttype
/rw
/rnl
Data
/rtagdata
/rexecTool
/ruploadurl
/rdelnodatamsg
/rdonotreport/rdonotreportex
/rfetchdatafirst
/rfirstmrd
/rfnodata
/rloginid
/rmergecellopt
/rnodatastring
/roncemappingdata
/ronepgrpt
/ronepgrptex
/rpageorder/rprnspno
/rremakerpt
/rswapfilepage
/ruseswapdisk
Report
/rwait
/rlSecurity
/rsequrity
/p
/rallprn
/rinslastpage
/rop
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 2/85
Appendix III. Report Designer Parameters
82
/rpaper
/rpaperlength
/rpdrv
/rpdup
/rpdupex
/rpprnform
/rprintnexit
/rprnend
/rprnfile
/rprnjangopt
/rprnn
/rprno
/rprns
/rprnstart/rps
/rpsrc
/rpuserpaper
/rpxpos
/rpypos
/rskippbline
/rcsv
/rcsvopt
/rexport
/rpdfnf
/rrunscr
/rsavedialogtype
/rsavepdf
/rsep/rtagname
/rxls
/rxlsfullhorz
/rxlsnopb
Save
/rxlsopt
/rcomboautorefresh
/rcombononullstrInquiry Toolbar /rcomboselectfirststr
/rchartactive
/rchartaxismax
/rchartaxismin
/rchartlabelmax
/rchartlabelmin
/rchartmarkpos
Chart
/rsetmaxganttcount
/rpd
/rpmdIf Statement Parameter Input
/rpn
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 3/85
Appendix III. Report Designer Parameters
83
/rpt
/rp
/rppSet Parameter Value
/rv
/rautoadjust
/rbrowsingopt
/reditmode
/rfixallobject
/rhcd
/rhidelinkinfo
/rhlinkopt
/ri/rmaketree/rmessageboxshow
/rmvs
/rnpu
/rpartsavedialog
/rsave
/rtrace
Environment
/rtracefile
/radocmdtimeout
/radocontimeout
/rcontype/rdn
/rip
/rpw
/rsn
DB connection
/rui
/rcss
/rhtmlimportoptHTML Source Conversion
/rstyle
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 4/85
Appendix III. Report Designer Parameters
84
3.1. Parameter Description
This chapter shows Instruction Parameter in Report Designer Viewer or OCX Viewer.
Parameter Name [parameter value]…
By using blank space, it is possible to select several parameters together. Parameter Namesstart with /r (except /p). Parameter value does not exist or may have several values
depending on parameters.
Refer to the following Description of parameters for the value setting of parameter.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 5/85
Appendix III. Report Designer Parameters
85
3.1.1. /p
Instruction
/p
Description
Parameter for producing report and for making print-out of the report.
This parameter is used only in Report Designer EXE Viewer and make it run in hiding ofReport Designer EXE Viewer. If you want to run the report in condition of using Report
Designer OCX Viewer, you need to use /rop parameter.
Notice. You must input /p parameter before a report file name. If you need to input differentparameters in order to run the report, you may input different parameters after file name like
in the following example /rp [car].
Example
"C:\Program Files\M2Soft\Report Designer 5.0\rdviewer.exe" /p product_rpt.mrd /rp [car]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 6/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 7/85
Appendix III. Report Designer Parameters
87
3.1.4. /rallprn
Instruction
/rallprn
Description
When you print a report, if this parameter is used with /rop parameter, page-print starts once
the whole pages of report are completed.
Example
/rop /rallprn
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 8/85
Appendix III. Report Designer Parameters
88
3.1.5. /rautoadjust
Instruction
/rautoadjust [0(default value) or 1]
Description
It automatically adjust the ratio of a Report Designer Viewer according to the size of a screen.
If set 1, the ratio will set automatically adjusted to fit in the size of a screen. Otherwise, it will
apply 100% ratio.
cf. Auto-ratio adjustment in Report Designer OCX Viewer can also be set by using
AutoAdjust properties values.
Example
/rautoadjust [1]
One in the left is a screen capture before applying /rautoadjust, and the other in the right is a
screen capture after using /rautoadjust for automatically adjust.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 9/85
Appendix III. Report Designer Parameters
89
3.1.6. /rbrowsingopt
Instruction
/rbrowsingopt [0(default value) or 1]
Description
In executing mode when you view a report, /rbrowsingopt is used for mouse dragging
functions.
If value is 0, mouse dragging only allows screen scroll function.
If value is 1, you can block for text copy on text frame object and cell object of table bymouse dragging. In other cases, screen scroll function will be executed.
cf. In editing mode, you can always block by mouse dragging.
Example
/rbrowsingopt [1]
By using this parameter, blocks are shown by mouse dragging as shown below.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 10/85
Appendix III. Report Designer Parameters
90
3.1.7. /rchartactive
Instruction
/rchartactive
Description
/rchartactive is a parameter that makes chart object to activate status. This parameter allowsto use the functions of chart object without double clicking chart object.
cf. It is same as the usage of SetFocusToChart OCX method.
Example
/rchartactive
3.1.8. /rchartaxismax
Instruction
/rchartaxismax [maximum value]
Description
It is a parameter that setups the maximum value of Y axis in chart.
Its priority is ahead of the maximum value in chart editing dialog box.
Example
/rchartaxismax [500]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 11/85
Appendix III. Report Designer Parameters
91
3.1.9. /rchartaxismin
Instruction
/rchartaxismin [minimum value]
Description
It is a parameter that setups the minimum value in Y axis in chart.
Its priority is ahead of the minimum value in chart editing dialog box.
Example
/rchartaxismin [-20] /rchartaxismax [100]
By using parameters above, the maximum and the minimum values will be applied as shown
below.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 12/85
Appendix III. Report Designer Parameters
92
3.1.10. /rchartlabelmax
Instruction
/rchartlabelmax [maximum date]
Description
When Label of X axis in chart is date format, it sets up the maximum date.
Example
/rchartlabelmin [20050101] /rchartlabelmax [20051230]
3.1.11. /rchartlabelmin
Instruction
/rchartlabelmin [minimum date]
Instruction
When Label of X axis in chart is date format, it sets up the minimum date.
Example
/rchartlabelmin [20050101] /rchartlabelmax [20051230]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 13/85
Appendix III. Report Designer Parameters
93
3.1.12. /rchartmarkpos
Instruction
/rchartmarkpos [positive value]
Description
It is a parameter that controls Y-position of ‘Mark’ when you mark in chart series.
If you select a positive value, mark position will move up-ward and if you select negativevalue the mark position will move down-ward.
Normally, it is used when working with Gantt chart.
Example
/rchartmarkpos [10]
3.1.13. /rcomboautorefresh
Instruction
/rcomboautorefresh
Description
When display tool bar has several display combo box, and if values in one combo box changes,
the list in the related combo box automatically changes.
For example, the name of country, city and client numbers are in display combo box, andyou change the country from USA to Korea, then the city name list will automatically changes.
It is assumed that the query statement for city name is related to country name.
In case you do not use parameter above, when you change country name, city name list will
not change, but when you change city name, city name display combo box will be refreshed.
Example
/rp "USA" "Denver" /rcomboautorefresh
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 14/85
Appendix III. Report Designer Parameters
94
3.1.14. /rcombononullstr
Instruction
/rcombononullstr
Description
Basically, the first one in display combo box list adds blank. This parameter controls not toadd blank.
By applying this parameter, combo box will look like the picture in the right.
Example
/rp "USA" "Denver" /rcomboautorefresh /rcombononullstr
3.1.15. /rcomboselectfirststr
Instruction
/rcomboselectfirststr
Description
When display tool bar has several display combo box, if the selection in one combo box
changes, the first one in another related combo box list will be selected.
By applying this parameter, combo box will look like the picture in the right.
Example
/rp "USA" "Denver" /rcomboautorefresh /rcombononullstr /rcomboselectfirststr
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 15/85
Appendix III. Report Designer Parameters
95
3.1.16. /rcontype
Instruction
/rcontype [database connection method]
Description
It is a parameter that is used to change database connection when processing reports.
This parameter can be used in reports that are using SQL statement or Stored Procedure.
For example, ODBC connection is used for making mrd file in Report Designer Editor, and
when execution in Report Designer Viewer, it is possible to make report in RDAGENTconnection.
Available connection moods are RDAGENT, NET, ODBC, ADO, ORACLE, ORACLE8,
ORACLE8I, RDS, SYBASE, SYBASE11.
You need more parameters below to execute reports in selected connection methods.
/rcontype [RDAGENT] /rf [RDAgnet path] /rsn [service name]
/rcontype [NET] /rf [connection path] /rsn [data source]
/rcontype [ODBC] /rsn [DSN name]
/rcontype [ADO] /rsn [connection words order]
/rcontype [ORACLE8I] /rsn [service name] /rui [user ID] /rpw [password]
/rcontype [RDS] /rip [server connection] /rsn [connection words order]
/rcontype [SYBASE11] /rsn [service name] /rui [uesr ID] /rpw [password] /rdn [database
name]
cf. Refer to the Descriptions of /rf, /rsn, /rui, /rpw, /rdn parameters used with /rcontyperespectively.
Example
/rcontype [RDAGENT] /rf [http://123.123.1.6:8282/RDServer/rdagent.jsp] /rsn [myoracle]
/rcontype [NET] /rf [http://myserver/RDServer4Net/rdnetdsl.aspx] /rsn [constr_sqlserver1]
/rcontype [RDS] /rip [http://orion] /rsn [Data Source=pubtest]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 16/85
Appendix III. Report Designer Parameters
96
3.1.17. /rcsv
Instruction
/rcsv [local file name]
Description
When you execute a report, it saves data from data source into a text file.
It saves as CSV file format using comma( , ) as a separator.
Example
/rcsv [c:\test.csv] /rcsvopt [1]
3.1.18. /rcsvopt
Instruction
/rcsvopt [0(default value) or 1]
Description
This is used with /rcsv parameters, and it appoints data saving method.
If the value is 0, and if there are new line character, comma(,), double quotation mark(“) inthe data, it binds and saves the corresponding column data using double quotation mark(“).(default)
If the value is 1, it does not handle column data in any other way.
Example
/rcsv [c:\test.csv] /rcsvopt [1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 17/85
Appendix III. Report Designer Parameters
97
3.1.19. /rdata,
Instruction
/rdata [data set]
Description
It is a parameter used in FILE connection and XMLFILE connection, and appointing data set
needed for executing reports.
cf. There are two parameters /rf and /rdata for appointing data source in FILE connection
and XMLFILE connection.
/rdata is to transmit existing data set while executing a report and Report Designer Viewerproduce reports using data set.(PUSH method)
/rf is to transmit the path of data set while executing a report. It creates report by bringing
data set through the appointed path in Report Designer Viewer. (PULL method)
When you have massive amount of data output, use /rf because it creates report by patchingdata partially. In this functional advantage, /rf is better than /rdata.
Example
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
<!--
function JavaOpen2_OnClick() {
var tmpStr;
tmpStr = "/rdata [" ;
tmpStr = tmpStr + "1semester_in_1997@1@computers@3@C";
for ( i = 0 ; i < 10 ; i++ ) {
tmpStr = tmpStr + "\n" + "1st_semester_in_1997@1@englishI@3@D+";
tmpStr = tmpStr + "\n" + "1st_semester_in_1997@2@philosophy@3@B";
tmpStr = tmpStr + "\n" + " 1st_semester_in_1997@2@chinese@3@C";
tmpStr = tmpStr + "\n" + "2nd_semester_in_1997@ @GPA:(Attended)20
(achieved)20@@";
tmpStr = tmpStr + "\n" + "2nd_semester_in_1997@ @Ave.GPA : 2.33@@";
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 18/85
Appendix III. Report Designer Parameters
98
}
tmpStr = tmpStr + "]";
// alert(tmpStr);
Rdviewer.FileOpen("C:\\transcript.mrd", tmpStr);
}
-->
</SCRIPT>
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 19/85
Appendix III. Report Designer Parameters
99
3.1.20. /rdelnodatamsg
Instruction
/rdelnodatamsg
Description
When the number of data at the repeating section in ‘Table’ type report are 0, it merges all
the cell and shows ‘Query data does not exist.’ in the cell. (Default)
If /rdelnodatamsg parameter is used, it will display already designed table form without
performing function above.
It performs the same function when clear the check box of ‘Combine Repetitions’ in Set TableProperties dialog box.
Example
/rdelnodatamsg
3.1.21. /rdn
Instruction
/rdn [database name]
Description
When executing a report, this parameter is used to change the name information ofdatabase that is to be used in the report.
It is used for connecting to SYBASE database.
Example
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 20/85
Appendix III. Report Designer Parameters
100
/rcontype [SYBASE11] /rsn [service name] /rui [user’s ID] /rpw [password] /rdn [databasename]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 21/85
Appendix III. Report Designer Parameters
101
3.1.22. /rdonotreport
Instruction
/rdonotreport
Description
This parameter controls not to execute a report but just to open a form file.
It is for presenting an empty form file on the screen and for executing a report after inputtinginquiry condition in display tool bar.
Left side is a report created with this parameter. Right side is a report created after inputtinginquiry condition.
Example
/rp SEOUL [salesman] /rdonotreport
3.1.23. /rdonotreportex
Instruction
/rdonotreportex
Description
It functions the same as /rdonotreport parameter. If it is applied for a file that does not use /rpparameter variable, the reports are executed without considering parameter.
Example
/rp SEOUL [salesman] /rdonotreportex
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 22/85
Appendix III. Report Designer Parameters
102
3.1.24. /reditmode
Instruction
/reditmode
Description
Report Designer Viewer provides execution mode and editing mode. In execution mode,only displaying a report is available. In editing mode, both displaying and editing is available
and the execution mode is a default. To execute a report in editing mode, use thisparameter.
Editing mode is only available when ‘Modify final report’ or ‘Enable memo on final report’ in
‘File-Document properties-Document’ tab of Report Designer Editor is set.
Example
/reditmode
3.1.25. /rexec
Instruction
/rexec [file name]
Description
After executing a report, use /rexec to execute a selected file.
Example
/rexec [c:\a.xls]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 23/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 24/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 25/85
Appendix III. Report Designer Parameters
105
Server script above prints data in a form below.
<%String dno = request.getParameter("dno");
StringBuffer sql = new StringBuffer(30);sql.append("SELECT e.empno, e.ename, e.job, e.mgr, e.hiredate, e.sal, d.dname
FROM emp e, dept d where e.deptno=d.deptno AND e.deptno=" + dno);
if (conn.isClosed() ) {conn = conn = DriverManager.getConnection( DB_URL, user, passwd );
}ResultSet empCursor = null;try {
stmt =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
empCursor = stmt.executeQuery( sql.toString() );
whi le( empCursor.next() ) {out.println(empCursor.getString("empno") + "^" +
empCursor.getString("ename") + "^ " + empCursor.getString("job" ) + "^ " +empCursor.getString("mgr" ) + "^ " + empCursor.getString("hiredate") + "^" +empCursor.getString("tit le") + "^ ");
}
empCursor.close();stmt.close();
} catch (Exception e) {out.println("Error!<br>" + e.toString());}
%>
1^ Kelly^Gloves^Computer science^1992/03/01^Sales Representative^
2^ Matthew^Gloves^Applied science^1989/06/01^Vice President, Sales^
3^Steven^Helmets^Mathematics^1993/04/01^Sales Representative^
4^ Gerry^Helmets^Economics^1995/05/03^Sales Representative^
5^ Laura^Locks^Biology Education^1996/03/01^Sales Manager^
6^Christopher^Locks^General Sociology^1990/10/17^Sales Representative^
8^Anne^Marketing^Computer science^1996/03/05^Sales Representative^
9^Albert̂ Marketin ^Com uter science^1990/11/15^Inside Sales Coordinator̂
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 26/85
Appendix III. Report Designer Parameters
106
there are two kinds of parameter to setup data source; /rf and /rdata in FILE connection
path, XMLFILE connection path. Refer to /rdata parameter Description.
When use in RDAGENT connection, NET connection
It is available in RDAGENT connection form or NET connection form, selecting server URL.
Its priority is before selected server URL in designing a report.
Example
/rf [http://www.m2soft.co.kr/ReportDesigner/test/mrd/test.txt] //data source path
/rf [<%=serverIp%>/reports/data.jsp?empno=<%=empno%>&deptno=<%=deptno%>] //datasource path
/rf [http://200.100.1.1:8282/RDServer/rdagent.jsp] //RDAGENT server path
/rf [http://200.100.1.1/rdserver4net/rdnetdsl.aspx] //NET server path
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 27/85
Appendix III. Report Designer Parameters
107
3.1.28. /rfetchdatafirst
Instruction
/rfetchdatafirst
Description
For quick printing, Report Designer patches part of data, and then present on the screen and
continue to produce a report. However, /rfetchdatafirst parameter controls to present afterpatching all data. Do not use /rfetchdatafirst in quick printing.
Example
/rfetchdatafirst
3.1.29. /rfirstmrd
Instruction
/rfirstmrd
Description
It is available when you open file lists with RprFileOpen Method. It will execute the firstreport among the file list.
Example
Rdviewer.RprFileOpen ("D:\\rd50\\rd50.rpr", "/rfirstmrd");
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 28/85
Appendix III. Report Designer Parameters
108
3.1.30. /rfixallobject
Instruction
/rfixallobject
Description
In editing mode, it keeps objects like text frame, table and lines not to selected and move..
In editing mode, objects are fixed for wards editing.
Example
/rfixallobject
3.1.31. /rfn
Instruction
/rfn [data source path or RDAGENT server path or .NET server path]
Description
Its function is same as /rf parameter. It only function differently in using Local file as a datasource. To use /rf parameter, delete local file after completing a report. In a case using /rfn
parameter, do not delete.
Example
/rfn [http://www.m2soft.co.kr/ReportDesigner/test/mrd/test.txt] //data source path
/rfn [<%=serverIp%>/reports/data.jsp?empno=<%=empno%>&deptno=<%=deptno%>] //data
source path
/rfn [http://200.100.1.1:8282/RDServer/rdagent.jsp] //RDAGENT server path
/rfn [http://200.100.1.1/rdserver4net/rdnetdsl.aspx] //NET server path
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 29/85
Appendix III. Report Designer Parameters
109
3.1.32. /rfnodata
Instruction
/rfnodata [mrd file name]
Description
It present selected mrd file instead when the number of record is 0 from data source.
Example
/rfnodata [c:\nodata.mrd]
3.1.33. /rhcd
Instruction
/rhcd
Description
It makes dialog box invisible in creating a report.
Executing a report without using /rhcd parameter makes dialog boxes like ‘database
connecting’ or ‘presenting report’ appear on the screen. And when there is no referredinformation, dialog box saying ‘no data found’ will appear.
Note) it is same as setting Report Designer OCX Viewer’s IsShowDlg attribute value to false.
Example
/rhcd
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 30/85
Appendix III. Report Designer Parameters
110
3.1.34. /rhidelinkinfo
Instruction
/rhidelinkinfo
Description
When a mouse is upon hyperlink attributed object, it is a parameter to hide the informationpresented in condition bar.
Example
/rhidelinkinfo
3.1.35. /rhlinkopt
Instruction
/rhlinkopt [0(default) or 1]
Description
It is a parameter to appoint whether single mouse click or double mouse click is set to work
when moving by hyperlink.
0 (default) – single mouse click
1 – double mouse click
Example
/rhlinkopt [1]
3.1.36. /rhtmlimportopt
Instruction
/rhtmlimportopt [0(default value) or 1]
Description
Set 1 as a value to execute HTML source transition in each record.
0 (default value) - HTML source transition first time 1
1 – for each record, HTML source transition
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 31/85
Appendix III. Report Designer Parameters
111
Example
/rhtmlimportopt [1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 32/85
Appendix III. Report Designer Parameters
112
3.1.37. /ri
Instruction
/ri [rdviewer.ini file]
Description
Report Designer Viewer has rdviewer.ini as configuration setup. By using this parameter, youcan use INI file as a configuration setup file. In INI file, you can setup database, IP, PORT,
User Name, service port, server version.
Example
/ri [c:\tmp\rdviewer.ini]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 33/85
Appendix III. Report Designer Parameters
113
3.1.38. /rinslastpage
Instruction
/rinslastpage
Description
It is used in both side printing, assuming last page as new paper and putting in every second
printing.
Example
/rinslastpage
3.1.39. /rip
Instruction
/rip [server IP or host name]
Description
It changes server IP or host name that are for connecting database in executing a report.
Example
/rcontype [RDS] /rip [http://orion] /rsn [Data Source=pubtest]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 34/85
Appendix III. Report Designer Parameters
114
3.1.40. /rl
Instruction
/rl [user level]
Description
It setups report user’s level.
In designing a report, it selects security level to data field for some group of users, and it
presents and hides data according to security level selected data for user and their level.
In designing a report, use formatting> security level menu and select security level in text
frame or table.
In executing a report, setup user’s level by using /rl parameter. When user’s level is lower
than the level assigned in data field, the data will secured. ‘ward order for security level’ will
appear in successfully secured data field.
cf. There are /rl and /resqurity to secure data field.
Example
In designing report, setup sales data field level as 2.
Left side is a example to setup user’s level as 1.
Right side is a example to setup user’s level as 3.
/rl [1] /rl [3]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 35/85
Appendix III. Report Designer Parameters
115
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 36/85
Appendix III. Report Designer Parameters
116
3.1.41. /rloginid
Instruction
/rloginid [User ID]
Description
It is to present report user’s information, selected user’s ID will be used in two differentfunction.
1. In referring report, printing, saving, it present user’s information to log in server side.
: only function in ‘log manager use’ selected server.
2. check if a user has execution right in executing a report connected with documentscontrol.
: documents control server controls user’s execution right. As shown below, when report
execution is ordered, if tester user has right to execute test.mrd documents, it execute s a
report.
rdviewer.FileOpen("$test$test.mrd", "/rf [http://myserver:8080/RDAgent.jsp] /rloginID[tester]");
Example
/rloginID [tester]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 37/85
Appendix III. Report Designer Parameters
117
3.1.42. /rmaketree
Instruction
/rmaketree
Description
It executes making content right after executing a report. It is used in executing a selected
content field report.
After completing a report, to make content at a point you want, use ShowIndexTree(1);method.
Example
/rmaketree
3.1.43. /rmergecellopt
Instruction
/rmergecellopt [0 or 1(default value)]
Description
It setups merge cells.
For the cases when two rolls has repeated roll, and two different cells have different field
name, this parameter merge cells.
If you use /rmergecellopt [0], even when above and below cell data’ value are same but has
different field name, it does not merge cells.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 38/85
Appendix III. Report Designer Parameters
118
Example
/rmergecellopt [0]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 39/85
Appendix III. Report Designer Parameters
119
3.1.44. /rmessageboxshow
Instruction
/rmessageboxshow [0, 1, 2, or 3(default value)]
Description
It controls message box print out. Set these values.
0 : hide all the message boxes
1 : only show error message
2 : only show error and warning messages
3 : show all messages (error, warning, information) . default value
Example
/rmessageboxshow [1]
3.1.45. /rmvs
Instruction
/rmvs
Description
It always provides Vertical scroll bar.
Example
/rmvs
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 40/85
Appendix III. Report Designer Parameters
120
3.1.46. /rnl
Instruction
/rnl [newline character substitution character(col)]
Description
In creating a report of FILE connection method, it used with /rdata parameter and assignsNewLine character and substitution character(col). It recognizes substitution character(col)
from /rdata parameter as new line, then execute a report.
Example
/rdata [1@my country~a country~next line@~2@your country~b country~Iknows@~3@myyour~ab~who knows@] /rnl [~]
3.1.47. /rnodatastring
Instruction
/rnodatastring [sting]
Description
It is a parameter to assign a string that there are no matched data after requesting search.
It has a higher priority than the string set in ‘Set Table Propert ies’ dialog box, and it onlyworks when checked at ‘Combine Repetitions’ option.
Description
/rnodatastring [no matching data]
3.1.48. /rnpu
Instruction
/rnpu
Description
It controls not to appear Pop-up menu when you press right click of mouse in Report
Designer Viewer.
Example
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 41/85
Appendix III. Report Designer Parameters
121
/rnpu
3.1.49. /roncemappingdata
Instruction
/roncemappingdata
Description
It is a parameter for mapping data only once to the background object.
When the data set is connected to the background object, in default, data mapping is
performed every record handling. If this parameter is used when the number of records arehigh, the report processing speed will be enhanced,
Example
/roncemappingdata
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 42/85
Appendix III. Report Designer Parameters
122
3.1.50. /ronepgrpt
Instruction
/ronepgrpt
Description
It is used in printing a report in one page.
Basically, report is created in several papers as pager size. However, by using this parameter,
page extends to a size that can print whole report. It is used in executing a report for screenviewer and same as selecting ‘one page print’ in document attribution.
when you print our a report by printer, you can adjust the printing size or divide to severalparts to print 100% of it. Use /rremakerpt parameter to print 100% size by dividing several
parts.
This parameter is function in table documents and level form.
Example
/ronepgrpt /rremakerpt
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 43/85
Appendix III. Report Designer Parameters
123
3.1.51. /ronepgrptex
Instruction
/ronepgrptex
Description
It is the same as /ronepgrpt parameter, printing a report in one page.
But, if a condition of changing page is selected in a table document report using sub-page, itfunctions differently.
If you use /ronepgrpt parameter, a report will execute d without considering page change.Otherwise, if you use /ronepgrptex parameter, it will execute with page change condition.
At this point, the object applied page change condition has to be ’sub-page object’. Refer to
sub-page object in object properties description.
Left picture is a example created with /ronepgrpt parameter. Right picture is an examplecreated with /ronepgrptex parameter.
Example
/ronepgrptex
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 44/85
Appendix III. Report Designer Parameters
124
3.1.52. /rop
Instruction
/rop
Description
It prints a report by printer as you execute a report.
It describes page numbers as it prints a report.
Therefore, it starts printing as you create the first page of the report. But if you use thisparameter with /rallprn parameter, it functions differently.
cf. If you use /rwait parameter in executing a report in Report Designer OCX Viewer,FileOpen method does not change value until the complement of report execution (until allthe pages are made). Basically, /rwait is used with /rop parameter to print several reports at
once.
Example
Rdviewer.FileOpen (“http://myserver/reports/test.mrd”, “/rf[http://200.100.1.1:8282/RDServer/rdagent.jsp] /rp [Seoul] [] /rop /rwait”);
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 45/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 46/85
Appendix III. Report Designer Parameters
126
Example
/rp [SEOUL] [salesman] //$1 parameter value : SEOUL, $2 parameter value : salesman
Report provided with parameter value $1, $2 and created with SQL, is the picture below. Itpresents parameter value $1, $2 at the cell of a table.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 47/85
Appendix III. Report Designer Parameters
127
3.1.54. /rpageorder
Instruction
/rpageorder [sub-page order]
Description
It re-orders created page, is used in executing serve page document.
Input page numbers with comma(,) as a separator.
It is used for delete and repeating specific page by re-ordering.
Example
/rpageorder [3,3,1] //make 3rd page to be printed out two times and then first page one time.In this case, 2nd page is deleted.
3.1.55. /rpaper
Instruction
/rpaper [paper size]
Description
It sets paper size.
Paper sizes are A1,A2,A3,A4,A5,B4,B5,LETTER,136 block,80block. Select one of them.
cf. use /rpaper, /rpprnform parameter to set a paper size. Refer the Description of /rpprnformparameter.
Example
/rpaper [A3]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 48/85
Appendix III. Report Designer Parameters
128
3.1.56. /rpaperlength
Instruction
/rpaperlength [vertical size of print paper (1/10mm scale)]
Description
It setups vertical size of a paper to 1/10mm scale, and is used for printing rolled paper. Whenyou print rolled paper, it protects not to change page space as page changes.
Example
/rpaperlength [2970]
3.1.57. /rpartsavedialog
Instruction
rpartsavedialog [0 or 1] [page range]
Description
It setups default value of saving dialog box in some page.
Present page as a default value; select 0. Some other page as a default value; select 1.
Page number and rage are decided with comma(,) as a separator. ex)3,5-8
Example
/rpartsavedialog [1] [1, 3-7]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 49/85
Appendix III. Report Designer Parameters
129
3.1.58. /rpd
Instruction
/rpd [$1parameter default value] [$2parameter default value] [$3 parameter default value]..
[$N parameter default value]
Description
It is to set $parameter default value. Dialog box ‘set condition for parameter’ will pop-up forputting parameter value if you do not give /rp parameter after you use parameter value in
designing a report.
/rpd parameter makes default value to be presented in the entry box of dialog box.
cf. refer to /rpn , /rpt, /rpmd
Example
/rpd [SEOUL] [salesman]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 50/85
Appendix III. Report Designer Parameters
130
3.1.59. /rpdfnf
Instruction
/rpdfnf
Description
It controls not to include font information when you save a report in PDF file form.
Example
/rpdfnf
3.1.60. /rpdrv
Instruction
/rpdrv [print name]
Description
It is to setup print name when you print a report.
Example
/rpdrv [FinePrint 2000]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 51/85
Appendix III. Report Designer Parameters
131
3.1.61. /rpdup
Instruction
/rpdup
Description
It is for printing both sides.
Example
/rpdup
3.1.62. /rpdupex
Instruction
/rpdupex
Description
It is used for printing both sides in a table document using sub-page. This is an extendedversion of /rpdup parameter.
By using /rpdup parameter; Odd number pages will print at the front page. Even numberpages will print at the back of the paper. However, /rpdupex parameter always print the firstsub-page at the front.
For example, A person’s result is 1 page, and B person’s result is 2 pages, /rdupex
parameter makes B person’s first page to be printed 2nd paper’s front page.
Example
/rpdupex
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 52/85
Appendix III. Report Designer Parameters
132
3.1.63. /rpmd
Instruction
/rpmd option[value] option[value] option[value] .. option[value]
Description
It is to present entry box of parameter value as a combo box in an ‘enter parametercondition’ dialog box.
To sep up a value, use combo box. It will show lists available for easy entry. There are 3ways to fill in the combo box list.
1) Use S option
It setups SQL query document with option value and fill combo box list with performed querystatement set.
As a result of executing a query statement, set can have 1 or 2 columns. If column is 1, a
value in combo box and a value that is used as parameter value in query execution aresame. If column is 2, first column’s value is presented in combo box. And second column’svalue will be used as $ parameter value.
2) Filling a value by using M option
User sets value that will presented at a list of a combo box and value that will be used as a$parameter value in query execution . Set @ as a separator as shown below
Displaying value1@internal value1@ Displaying value 2@ internal value 2@ ... Displaying
value N@ internal value N
3) Filling value by using D option
User set value that will display in a list of a combo box as a option value. M option setsdisplay value and internal value together, but d option only sets displaying value. Value set
as a displaying value in D option will also be used as a internal value.
Displaying value1@ Displaying value2@ ... Displaying valueN
cf. refer to /rpd, /rpn , /rpt .
Example
/rpd [Nampa] /rpn [enter city name] /rpt [select query condition] /rpmd s[SELECT distinct
Customers. City FROM Customers ORDER BY Customers. City ASC] // filling value withusing S optin
/rpd [Nampa] /rpn [enter city name] /rpt [select query condition] /rpmdM[Nampa@100@Santa Ana@200@Tualatin@300] // filling value with using M option.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 53/85
Appendix III. Report Designer Parameters
133
/rpd [Nampa] /rpn [enter city name] /rpt [select query condition] /rpmd D[Nampa@Santa
Ana@Tualatin] //filling value with using D option.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 54/85
Appendix III. Report Designer Parameters
134
3.1.64. /rpn
Instruction
/rpn [$1parameter title] [$2 parameter title] [$3 parameter title].. [$N parameter title]
Description
In ‘enter parameter condition’ dialog box, it sets each parameter’s title.
In designing a report, even if you use parameter name in query definition, ‘enter parameter
condition ‘ dialog box will appear for entering a parameter value at least you give /rpparameter in executing a report.
you can change ‘enter value of parameter $1’ title by using /rpn parameter.
cf. /refer to rpd, /rpt, /rpmd
Example
/rpd [SEOUL] [salesman] /rpn [enter city name] [enter representative]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 55/85
Appendix III. Report Designer Parameters
135
3.1.65. /rpost
Instruction
/rpost [server script calling parameter]
Description
It is used with /rf parameter to transform a parameter that is necessary in calling server script,
to POST way. There is no limit in a length of transforming to POST way.
cf. refer to /rf parameter Description.
Example
/rf [<%=serverIp%>/reports/data.jsp] /rpost [empno=<%=empno%>&deptno=<%=deptno%>]
3.1.66. /rposttype
Instruction
/rposttype [Content-Type]
Description
It sets Content-Type in HTTP required with using /rpost parameter.
Example
/rposttype [text/xml]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 56/85
Appendix III. Report Designer Parameters
136
3.1.67. /rpp
Instruction
/rpp [$1parameter form|$1parameter value] [$2parameter form|$2parameter
value]…[$Nparameter form|$Nparameter value]
Description
It is a extended version of /rp, and used to give parameter value in report execution .
/rp gives only parameter value, however, /rpp gives both parameter form and parametervalue.
Parameter from has 1 to 5 value.
1 : char,varchar, 2 : int,bit,decimal, 3 : float,double, 4 : timestamp, 5 : date
It is used in query execution report by using ‘Prepare Statement use’.
Example
/rpp [2|7369]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 57/85
Appendix III. Report Designer Parameters
137
3.1.68. /rpprnform
Instruction
/rpprnform [user defined paper name]
Description
It sets printing paper size.
There are /rpaper, /rpprnform parameter to set printing paper size.
/rpaper parameter is to set paper size that is provided from Report Designer; set one among
A1,A2,A3,A4,A5,B4,B5,LETTER,136blank,80blank .
but, /rpprnform parameter sets ’user defined paper name’. User can set user define papersize at printer driver. It is possible to use from Window XP, 2000.
Example
/rpprnform [SIZE1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 58/85
Appendix III. Report Designer Parameters
138
3.1.69. /rprintnexit
Instruction
/rprintnexit
Description
It is used to finish a viewer in viewer execution module. Basically it is used with /ropparameter.
Example
/rop /rprintnexit
3.1.70. /rprnend
Instruction
/rprnend [last page number to print]
Description
It sets last page number to print with using /rop parameter.
Example
/rprnstart [3] /rprnend [5]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 59/85
Appendix III. Report Designer Parameters
139
3.1.71. /rprnfile
Instruction
/rprnfile [PostScript file name or PCL file name]
Description
It saves document as local file as well when you print a report.
It saves as PostScript file or PCL file that is provided from driver.
Example
/rprnfile [c:\test.ps]
3.1.72. /rprnjangopt
Instruction
/rprnjangopt
Description
It makes first serve page to be printed at the first page. It is used in printing table documents
that uses serve page.
For example, a report for A student is made 3 pages, and a report for B student is made 3pages.
Basically, each page become 2 pages. Therefore it becomes 3 pages printed out. But, by
using /rprnjangopt parameter, it prints first and second page of A student in one paper.
Below is a picture made with /rprnjangopt parameter.
Example
/rprnjangopt
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 60/85
Appendix III. Report Designer Parameters
140
3.1.73. /rprnn
Instruction
/rprnn [# of pages to print]
Description
It sets print numbers.
Example
/rprnn [2]
3.1.74. /rprno
Instruction
/rprno [printing option(0,1,2)]
Description
It sets printing option when you print out.
0 : print whole document 1 : print only object 2 : print only data
If you print only object, it does not print text data. If you print only data, it prints out only text
data.
Example
/rprno [1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 61/85
Appendix III. Report Designer Parameters
141
3.1.75. /rprns
Instruction
/rprns
Description
It is used with /rop parameter, opening a printing dialog box before printing our. It has the
same function as /rps parameter.
Example
/rop /rprns
3.1.76. /rprnspno
Instruction
/rprnspno [start page number]
Description
It sets ’beginning page number’ when report has page number object.
In designing a report, to set ‘beginning page number, use text frame properties dialog box./rprnspno parameter is used in executing a report to change page number.
Example
/rprnspno [10]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 62/85
Appendix III. Report Designer Parameters
142
3.1.77. /rprnstart
Instruction
/rprnstart [start page number]
Description
It is used with /rop parameter to set the first page number for printing.
Example
/rop /rprnstart [3] /rprnend [5]
3.1.78. /rps
Instruction
/rps
Description
It is used with /rop parameter, opening a printing dialog box before printing out. Its function is
the same as /rprns parameter.
Example
/rop /rps
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 63/85
Appendix III. Report Designer Parameters
143
3.1.79. /rpsrc
Instruction
/rpsrc [printing paper box(0 ~ 12)]
Description
It sets paper box to use for printing..
Set one value from 0 to 12.
1: DMBIN_ONLYONE 2: DMBIN_MIDDLE 3: DMBIN_MANUAL
4: DMBIN_ENVELOPE 5: DMBIN_ENVMANUAL 6: DMBIN_AUTO
7: DMBIN_TRACTOR 8: DMBIN_SMALLFMT 9: DMBIN_LARGEFMT
10: DMBIN_LARGECAPACITY 11: DMBIN_CASSETTE 12: DMBIN_FORMSOURCE
Example
/rpsrc [3]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 64/85
Appendix III. Report Designer Parameters
144
3.1.80. /rpt
Instruction
/rpt [dialog box title]
Description
It is to change a title of ‘enter parameter condition’ dialog box.
In designing a report, you use $parameter name for query definition. However, in executing a
report, if you do not give /rp parameter , dialog box saying ‘enter parameter condition’ willappear.
You can change a title of a dialog box ‘enter parameter condition.’ by using /rpt parameter.
cf. refer to /rpd, /rpn , /rpmd
Example
/rpd [SEOUL] [salesman] /rpn [enter city name] [enter representative] /rpt [select inquirycondition]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 65/85
Appendix III. Report Designer Parameters
145
3.1.81. /rpuserpaper
Instruction
/rpuserpaper [value]
Description
It is to print report which size is defined by user. It is used with /rpaperlength option. If you
use specific printer diver in a condition of Windows 98, page spare could be different eventhough you give /rpaperlength option. To keep it not to do this, give 256 as a /rpuserpaper
value.
Example
/rpaperlength /rpuserpaper [256]
3.1.82. /rpw
Instruction
/rpw [password]
Description
It is used with /rui parameter and sets user password for database connection.
Example
/rui [admin] /rpw [123]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 66/85
Appendix III. Report Designer Parameters
146
3.1.83. /rpxpos
Instruction
/rpxpos [horizontal size (1/10mm scale)]
Description
It sets horizontal size for position movement when it prints.
Example
/rpxpos [10]
3.1.84. /rpypos
Instruction
/rpxpos [vertical size(1/10mm scale)]
Description
It sets vertical size for position movement when it prints.
Example
/rpypos [10]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 67/85
Appendix III. Report Designer Parameters
147
3.1.85. /rremakerpt
Instruction
/rremakerpt
Description
It is used with /ronepgrpt parameter to divide one page report to several pages for print out
one report into several pages .
It is available in table document and label form report.
But, the report that has DrillDown function, /rremakerpt parameter cannot be used.
Example
/ronepgrpt /rremakerpt
3.1.86. /rrunscr
Instruction
/rrunscr [data file name]
Description
It is used in table document with ‘script use’ and saves data after script execution to a file.
This file’s field separator is ‘@’ . To change field separator, use /rsep parameter.
Below is a picture of re-creating a table document with ‘script use’.
Example
"rdviewer.exe" /p c:/reports/report.mrd /rsep [^*^] /rrunscr [C://data/data1.txt]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 68/85
Appendix III. Report Designer Parameters
148
3.1.87. /rsave
Instruction
/rsave
Description
It makes saving menu inactive, so that executed report will not be saved as a file.
Example
/rsave
3.1.88. /rsavedialogtype
Instruction
/rsavedialogtype [0(default) or 1]
Description
This parameter makes it possible to eliminate the password setting UI when saving MRR file
in save dialog box.
If option is 1, save dialog box that does not have ‘Set password for MRR File’ pops up.
Example
/rsavedialogtype [1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 69/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 70/85
Appendix III. Report Designer Parameters
150
3.1.90. /rsep
Instruction
/rsep [field seperator]
Description
This parameter is used when running File connection or XMLFile connection report, and setfile connection field separator in run time.
In executing a table document with ‘script use’, it is used with /rrunscr parameter to set fieldseparator for data file.
Example
/rsep [^@^]
"rdviewer.exe" /p c:/reports/report.mrd /rsep [^*^] /rrunscr [C://data/data1.txt]
3.1.91. /rsequrity
Instruction
/rsequrity [field name1] [field name2].. [field nameN]
Description
It is to apply security in specific data field of a report.
Field name that you give over with /rsequrity parameter will present ‘ward order in applying
security level’ instead of presenting data. Field name is set in ‘Map Dataset ’ dialog box.
cf. There are /rl and /rsequrity that is to secure data field.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 71/85
Appendix III. Report Designer Parameters
151
Example
/rsequrity [orders.Freight]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 72/85
Appendix III. Report Designer Parameters
152
3.1.92. /rsetmaxganttcount
Instruction
/rsetmaxganttcount
Description
It is used in creating Gantt chart to set a maximum number of presenting object. Itautomatically adjust chart number depending on table number.
Example
/rsetmaxganttcount [8]
3.1.93. /rskippbline
Instruction
/rskippbline
Description
It controls not to function ‘Page Break on Printing’ in executing a report that uses sub-page.
For example, creating bank account table, use /rskippbline parameter to print as it shows ona screen. Otherwise, saving function will change page.
Example
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 73/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 74/85
Appendix III. Report Designer Parameters
154
3.1.94. /rsn
Instruction
/rsn [connection data source name]
Description
It is to change data source name in executing a report.
It is available only in SQL document or Stored Procedure.
Available connection methods are RDAGENT, NET, ODBC, ADO, ORACLE, ORACLE8,ORACLE8I, RDS, SYBASE, SYBASE11
/rf [RDAgnetpwth] /rsn [service name] //RDAGENT
/rf [connection server] /rsn [data source] //NET
/rsn [DSN name] //ODBC
/rsn [connecting ward order] //ADO
/rsn [service name] /rui [user ID] /rpw [password] //ORACLE8I
/rip [connection sever] /rsn [connecting ward order] //RDS
/rsn [service name] /rui [user ID] /rpw [password] /rdn [database name] //SYBASE11
Example
/rf [http://123.123.1.6:8282/RDServer/rdagent.jsp] /rsn [myoracle]
/rf [http://myserver/RDServer4Net/rdnetdsl.aspx] /rsn [constr_sqlserver1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 75/85
Appendix III. Report Designer Parameters
155
3.1.95. /rstyle
Instruction
/rstyle [style block]
Description
It sets a style that will be used in HTML source transition.
Example
/rstyle [p {font-size:12pt; font-family:,Arial;}]
3.1.96. /rswapfilepage
Instruction
/rswapfilepage [# of pages]
Description
This parameter is used with /ruseswapdisk parameter and assigns the number of pages thatsaved in each swap file. The minimum and maximum number of pages are 100 and 1000
pages, respectively.
Example
/rswapfilepage [300]
3.1.97. /rtagdata
Instruction
/rtagdata
Description
It is used in executing a FILE connection report. It marks the beginning and the end of databy put specific tag in data file.
//STARTDATA// : next line of this ward order is the beginning.
//ENDDATA// : line before this ward order is the end of data.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 76/85
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 77/85
Appendix III. Report Designer Parameters
157
3.1.98. /rtagname
Instruction
/rtagname [data file]
Description
It is used to save execute d report as XML file. It setups data file that has XML tag name
information.
Data file has ‘field name, tag name’ as shown below.
Employees.LastName,name
Employees.HomePhone,phone number
cf. Properties > Set Element Name menu
Example
/rtagname [http://myserver/tagname.txt]
Below is an example of created XML file.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 78/85
Appendix III. Report Designer Parameters
158
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 79/85
Appendix III. Report Designer Parameters
159
3.1.99. /rtrace
Instruction
/rtrace [0(default value),1,2 or 3]
Description
It is to save error, warning or information created in report execution as a log file..
0:OFF(default value) ,1:Error, 2:Error & Warning, 3:Error & Warning & Info
use /rtracefname for log file saving.
It you do not use /rtracefname, it will create log file which from is after c:\ root directory.
rdvlog + date + ".log"
Example
/rtrace [1] //c: rdvlog_20060131.log form’s log file will be created in root directory.
3.1.100. /rtracefname
Instruction
/rtracefname [log file name]
Description
It is used with /rtrace parameter to set log file.
Log file will be produced by date and producing rule is same as shown below.
Log file name + date + ".log"
Example
/rtracefname [c:\rdlog\rdlog] log file of rdlog_20040801.log form will be created in //
c:\rdlog\ directory.
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 80/85
Appendix III. Report Designer Parameters
160
3.1.101. /rui
Instruction
/rui
Description
It is used with /rpw parameter to set user ID for database connection.
Example
/rui [admin] /rpw [123]
3.1.102. /ruploadurl
Instruction
/ruploadurl [up roding URL]
Description
In uploading local file to server by using UploadDataFile() of Report Designer OCX Viewer, it
setups URL of jsp and asp.
Example
/ruploadurl [http://www.m2soft.co.kr/upload/uploadf.jsp]
3.1.103. /ruseswapdisk
Instruction
/ruseswapdisk
Description
This parameter is used to create swap file in hard disk not using memory swap when printing
large volume of data. Swap file is created in Tmp directory.
Example
/ruseswapdisk
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 81/85
Appendix III. Report Designer Parameters
161
3.1.104. /rv
Instruction
/rv parameter name[parameter value] parameter name[parameter value] parameter
name[parameter value].. parameter name[parameter value]
Description
It gives parameter value that is available in executing a report.
/rp only gives parameter value, /rv gives both parameter name and parameter value.
Several parameter name[parameter value] will be separated with black.
In creating a SQL document, /rv parameter inquiry is :(parameter name) from.
Use data set connection dialog box to print parameter value in data field. In creating a
summary, to refer parameter, use getparam(“parameter name”). In fixed form script, to referparameter name, use getparam(“parameter name”) .
cf. refer to /rp parameter Description.
SELECT Customers.CompanyName
FROM Customers
WHERE Customers.City = ':(city name)' AND Customers.ContactTitle =
':(representative)'
ORDER BY Customers.CompanyName ASC
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 82/85
Appendix III. Report Designer Parameters
162
Example
/rv name[kelly] major[social information science] address[ ] phone[] student ID[970501]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 83/85
Appendix III. Report Designer Parameters
163
3.1.105. /rw
Instruction
/rw [query statement]
Description
It is to give a query statement over.
It ignores WHERE, ORDER BY, GROUP BY, HAVING of query statements in Querydefinition of Report Designer Editor and change query statement with WHERE sentence that
is from parameter.
If you created Query definition in SQL editing mode, by using /rw parameter you can give allthe SQL documents over. However, it is limited to the case of already set query statement.
/rw parameter will applied to main query statement when a table documents use sub-page.
Example
/rw [WHERE t.f1 = 123]
/rw [SELECT t,f1, t.f2 FROM t WHERE t.f1 = 123] //SQL In free editing, all the SQL
documents will provided.
3.1.106. /rwait
Instruction
/rwait
Description
It calls file open method, and after a report completed it finishes method with using /rwaitparameter.
Basically, if it calls FileOpen method, right after the first page completed, function finishes.
Unfinished report will be produced through Background Processing in idle time.
Example
Rdviewer.FileOpen (“http://myserver/reports/test.mrd”, “/rf
[http://200.100.1.1:8282/RDServer/rdagent.jsp] /rp [Seoul] [] /rop /rwait”);
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 84/85
Appendix III. Report Designer Parameters
164
3.1.107. /rxls
Instruction
/rxls
Description
It saves to excel file after completing all the pages at a viewer. It will show the excel file byexecuting excel program. If you use with /rcsv option, excel program that is set in /rcsv
option will be executed together.
Example
/rxls
3.1.108. /rxlsfullhorz
Instruction
/rxlsfullhorz [0(default value) or 1]
Description
When you save in excel file, if you have a object out of paper range, it automatically savesobjects in a paper range. But, this parameter will save objects out pf the paper range.
Example
/rxlsfullhorz [1]
8/16/2019 Report designer Manual - 18.Appendix III
http://slidepdf.com/reader/full/report-designer-manual-18appendix-iii 85/85
Appendix III. Report Designer Parameters
3.1.109. /rxlsnopb
Instruction
/rxlsnopb
Description
It controls not to put page separator line when you save in excel file.
Example
/rxlsnopb
3.1.110. /rxlsopt
Instruction
/rxlsopt [0(default value), 1, or 2]
Description
When you save a report as a excel file, it sets ‘Keep the report format’. It also controls dialogbox saying ‘Excel Option’ not to appear on a screen. .
0 : ‘Excel Option’ dialog box will be presented. Remaining report form will decided dependingon user’s choice. (default value)
1 : It saves as it remain a report format. ‘Excel Option’ dialog box will not appear.