Chapter1 Preface 【Note】The function points denoted by * are limited function points, with different limitations base on different editions. Please refer to edition function list for more details. 1.1 Objects RAQ Report V4.0 special tutorial on input report is applicable to report designers, deployment engineers and application developers who have grasped the rudiment of report design, and need to go further in input report. Special advanced report design knowledge of RAQ Report is required in chapter multi-source input report. 1.2 Purpose of the Document This document is for report designers, deployment engineers and application developers who want to learn more about input report. The document contains three parts: design, deployment and application development, it systematically explains the knowledge of input report. Users can systematically and completely understand RAQ Input Report model and principles, and master various applications of input report and methods of report deployment and application development in depth. 1.3 Abstract Chapter Contents&Concepts Functions&Operations Chapter1 Preface Chapter2 Introduction Background and concepts of Creating input report input report, getting started with Converting normal report to input report design process input report Chapter3 Grid input Concepts of grid input report, Designing grid input report report Other concepts like update, ...
Input Report Tutorial
Chapter1 Preface
【Note】The function points denoted by * are limited function points, with different
limitations base on different editions. Please refer to edition function list for more
details.
1.1 Objects
RAQ Report V4.0 special tutorial on input report is applicable to report designers,
deployment engineers and application developers who have grasped the rudiment of report
design, and need to go further in input report. Special advanced report design knowledge of
RAQ Report is required in chapter multi-source input report.
1.2 Purpose of the Document
This document is for report designers, deployment engineers and application developers
who want to learn more about input report.
The document contains three parts: design, deployment and application development, it
systematically explains the knowledge of input report. Users can systematically and
completely understand RAQ Input Report model and principles, and master various
applications of input report and methods of report deployment and application development in
depth.
1.3 Abstract
Chapter Contents&Concepts Functions&Operations
Chapter1 Preface
Chapter2 Introduction Background and concepts of Creating input report
input report, getting started with Converting normal report to
input report design process input report
Chapter3 Grid input Concepts of grid input report, Designing grid input report
report Other concepts like update, Setting update, editable
editable attributes, input data attributes and expression, input
data type type., edit style, validity check,
automatic computation Using drop-down dataset,
drop-down calendar,
drop-down view tree
Using data type to check validity and setting validity
check formula
Setting automatic computation
for cells
Using customized jsp to release
input report
Use js to control the highlight
of current row and modify
cell
Changing normal input report Chapter4 Row input Background and concepts of row
report input report to row input report
Background and concepts of Using serial number to set cells
serial number initial value and increment
Differences between normal formula
Import indefinite rows excel input report and row input report
Release input report
Define add and delete row
button to web page
Chapter5 Freestyle input Concepts of freestyle report Designing freestyle input
report Go deep into the principles and report Define update attribute
applications of validity check and Defining drop-down list,
automatic computation drop-down data sheet,
Principles of uploading images drop-down calendar,
correlation filter and other edit Built-in js performance function
Understanding switchCase styles.
function Customizing new edit style
Add customize function button
Validity check of char data type
Customizing validity check
function
Automatic computation of date
Customizing automatic
computation function
Uploading image
Controlling cursor jumps
Chapter6 Forceful Background and realization Input report force release
submission of the approach of input report examples
input report submission
Chapter7 Parameter Function of report parameters Setting and using parameters in
Relationship between parameter report
Designing parameter templates template and input report
Background and application of base on report parameters
parameter processing class Setting parameter edit style for
parameter template Releasing parameter template
with report
Realize access control with
parameter processing class
Realizing search condition save
with parameter processing
class
Reference cells’ variable value
in html
Outputting SQL in input Chapter8 Input Background, structural principle,
processing class and applications of input processing class
processing class
Chapter9 Multi-source Background, realization Designing main-sub input
report input report principles and applications of
multi-source input report Design multi-source cross
input report
Chapter10 Input report Background,Creating input report group
group principles and applications of Defining input data source
input report group Defining table’s attributes
Defining report group’s
parameters and correlations
with report parameters
Defining validity check
between reports
Chapter11 Implementing Background of data reduction Examples and codes for data
reduction and data migration data cleaning and and data migration
filtering by input Principles of using input report to
report realize data reduction and data
migration
Chapter12 Contact us
CONTENTS
CHAPTER1 PREFACE..................................................................................2
1.1 OBJECTS...............................................................................................2
1.2 PURPOSE OF THE DOCUMENT .................................................................2
1.3 ABSTRACT.............................................................................................2
CHAPTER2 INTRODUCTION .......................................................................9
2.1 WHAT IS INPUT REPORT .........................................................................9
2.2 THE FLOW CHART OF CREATING AN INPUT REPORT ..................................9
2.3 CREATING A NEW INPUT REPORT...........................................................10
2.4 CONVERTING INTO INPUT REPORT......................................................... 11
CHAPTER3 GRID INPUT REPORT ............................................................13
3.1 WHAT IS GRID INPUT REPORT...............................................................13
3.2 CREATING A NEW GRID INPUT REPORT ..................................................13
3.3 SETTING THE UPDATE PROPERTY..........................................................15
3.3.1 Concept.......................................................................................15
3.3.2 Operation ....................................................................................16
3.4 EDITABLE ............................................................................................18
3.4.1 Concept18
3.4.2 Define the Editable Property .......................................................19
3.4.3 able Expression ...................................................20
3.5 RELEASING..........................................................................................21
3.6 INPUT DATA TYPE.................................................................................22
3.6.1 Concept22
3.6.2 Setting the Input Data Type.........................................................23
3.7 EDIT STYLE .........................................................................................23
3.7.1 Concept.......................................................................................23
3.7.2 Dropdown Dataset ......................................................................24
3.7.3 Drop-down Calendar ...................................................................25
3.7.4 Drop-down View Tree..................................................................26
3.8 CHECKING THE VALIDITY.......................................................................29
3.8.1 Concept29
3.8.2 Checking Validity by the Data Type.............................................29
3.8.3 Check Expression29
3.9 AUTO COMPUTE ..................................................................................31
3.9.1 Concept31
3.9.2 Numeric Calculation ....................................................................32
3.10 PUBLISHING WITH THE USER-DEFINED JSP ............................................33
3.10.1 Example of User-defined JSP .....................................................33
3.10.2 Deploying and Releasing ............................................................36
3.10.3 Introduction to Normal Input Report Tag......................................36
3.11 BACKGROUND COLOR OF THE CURRENT ROW........................................39 3.11.1 Business Background .................................................................39
3.11.2 Operations...................................................................................39
3.12 IMPROVEMENT: HIGHLIGHT THE EDITED CELL .........................................40
3.12.1 40
3.12.2 Operation ....................................................................................40
CHAPTER4 ROW INPUT REPORT.............................................................42
4.1 WHAT IS ROW INPUT REPORT?42
4.2 CONVERTING TO ROW INPUT REPORT....................................................45
4.3 ADDING SEQUENTIAL NUMBER ..............................................................47
4.3.1 Concept.......................................................................................47
4.3.2 Setting the Initial Value of Sequential Number ............................47
4.3.3 Setting Calculation Expression of Sequential Number ................47
4.3.4 Using Sequential Number Opportunely to Implement Default Value
in New Row .............................................................................................49
4.4 IMPORT EXCEL WITH UNCERTAIN ROWS.................................................50
4.4.1 Business Background .................................................................50
4.4.2 Implementation Approach............................................................50
4.4.3 Example ......................................................................................50
4.5 DEPLOY ..............................................................................................53
4.5.1 Generate Add/Delete Row Function Button ................................53
4.5.2 Deploy.........................................................................................53
CHAPTER5 FREESTYLE INPUT REPORT