Input Report Tutorial

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