Dry Run a detailed understanding of statements - statements designed (1), (2) [url=http://www.runqian.com.cn/rqrpt/rqwebreport.htm][u][b] Run Dry statements [/b][/u] recently has been engaged in the Web Reporting Tool products, some users take Crystal, BO. Brio products such as the internationally renowned and it has done comparative testing, the final choice Dry Run, Dry Run and some users take a much cheaper price and some statements of Web software, ultimately willing to pay more money or to the number of times a run dry. The statement referred to a new generation of standard products, what characteristics? Let us depth research : I, mapping programs Run Dry statements using the Internet category Excel format editing program, set up through the merger of Lattice and frame styles organizations statements. Run Dry statements can be read into Excel table drawing good kind, including the data and format. We can compare the typical traditional tools such as Crystal Report, which generally use Control-mapping statements. In this way, they will encounter serious difficulties in drawing form. There are a number of segments or rectangular form from the launch of China's statements require a neat grid, which rectangular and lines to be accurate alignment, imagine the extent of their troubles. When the table wide, it is often left ignored Gu right; Multilayers and the first amendment is very tedious mapping; Coordinate System because of the rules, or alignment with the relevant resolution, the picture on the screen and rows of statements when displayed on the website or missing in the printer; Most traditional tools of Excel can only write data derived lose format information Fine individual can maintain production format, but will also rely heavily on the degree of alignment, little else will change many firms unable to lead his party continue to be used to derive almost all Excel users have requested. Dry Run Excel and statements not only efficient forms of painting, drawing 10 times more efficient than traditional tools. But theoretically does not exist on the issue of missing derived distortion of Excel can do. Meanwhile, Dry Run statements using maps depict the 3.0 supports print paper, the paper will be in the ratio of 1:1 for scanned photographs affixed statements maps, and then facing the kind depicted in Table than the traditional ruler to measure the size used in subsequent statements installed tools to improve the efficiency of many programs. Run Dry statements mapping program than the Crystal Report, the Brio products abroad, in drawing the complicated domestic common form has considerable advantages. In fact, this lattice method statements have been more and more domestic products are used, such as the innovation, and so forth-table, it shows that it has become a mainstream trend. However, one aspect of the software rendering only statements, Run Dry statements, but also the core of its unique advantages in the data model. Reference article : [url=http://www.runqian.com.cn/rqrpt/rqwebrpt_cmp.htm][u][b] contrast with the traditional tools statements [/b][/u] [url=http://www.runqian.com.cn/tech/tech_010.htm][u][b] From Excel to run dry [/b][/u] Dry Run a detailed understanding of statements - statements Design Data Model Dry Run colleagues in the data model is the most exciting part of 3.0 statements. 1 Statement Analysis China's statements, the data generally have the following characteristics : On multi-source data from a number of statements : a data table, it is difficult to write using SQL sentence, or even a variety of heterogeneous database; On patch : report is divided into films per rules, no impact on overall returns to the rules, or a parallel list (ranks are likely direction) is very common; On not completely broken down : incomplete separation of the fixed format statements is not uncommon; ． Georgia : Georgia complicated operation between inter-operation is very arbitrary, very common crossed inter-group operations; On changes to the listed requirements : symmetrical ranks are changes in the direction of many cross table; And correspondence, statements traditional tool data model are as follows : serious mistakes On single source : the data must use a SQL statement to write (or stored), the statements in a single two-dimensional data sets are handling terminal; ． Form a whole, there is only one rule : the entire table could plots region, and not parallel patch; The fact that only complete separation is divided : divided, fixed and production difficulties statements; On interbank operations group carried out a simple calculation : Only summary or the whole group, individual interbank operations to provide simple tools that do not support inter-group operations, the independent Georgia operation very difficult. ． Asymmetry : the ranks of the difficulties shown in the direction changes, the law will produce a strong statement of the Cross; These statements traditional tools designed to produce statements of error is very difficult to draw a considerable number of code statements can be completed, the individual statements completely unable to complete the complicated forms. Run to solve all of these problems stem statements 3.0! Related reading : why should we spend Crystal Report[/u] [url=http://www.runqian.com.cn/tech/crystal.htm][u] [url=http://www.runqian.com.cn/tech/tech_017_1.htm][u] New model [/u] statements 2. Data Model Dry Run colleagues in the data model is the most exciting part of 3.0 statements. 2.4 Cross Report Cross simple statements, and there stronger than the traditional tools of visual control. [img]http://www.runqian.com.cn/rqrpt/images/wp016.jpg[/img]     With the traditional tools, Dry Run statements Crosstab model produced no specific treatment, and other forms can be dealt with. And the right to write down the table as long as the first expansion of the formula can be performed automatically and the middle, but can also form the first part of certain statements with the expansion of the right side of the table to keep the entire appearance, and the head of the traditional tools are fixed. The statement is likely to be completed multi-cross. [img]http://www.runqian.com.cn/rqrpt/images/wp018.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/images/wp020.jpg[/img] The multiple overlapping statements as a rule, the traditional tools usually can be completed. However, this statement was also the source of many statements of the first and middle of each table for a breakdown of the data from a physical data tables with traditional tools for five forms must be achieved by the foreign link fork, SQL is very complex but extremely inefficient operations; Run it as long as you write using dry began in a simple SQL statements, February 2 forks multiplication, is not only simple and highly efficient. 2.5 patch statements This patch levels (two slices of several different hierarchical) statements is a fatal mistake traditional tools, the programming is completed and the Dry Run and the statements were very easy and very intuitive together. [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0000.jpg[/img] Divided about the same problems, the two films are listed in parallel with the direction of changes in the region, in the traditional dynamic programming tools to be added can be achieved, and it's very relaxing to Run Dry statements. [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0001.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0002.jpg[/img] In fact, only two films rarely statements often July 8 will be divided into a dozen films and even films, sub - horizontal-vertical film, Run Dry statements deal with such difficult statements are unique advantage. 2. Data Model Dry Run colleagues in the data model is the most exciting part of 3.0 statements. Section 2.6 interbank operations Generally only practitioners of traditional tools and operations against the group of interbank operations than the same period in the previous period, and very difficult, and often must prepare data programming can be completed. Run Dry statements and the level of invention and displacement coordinates perfectly coordinates concept can solve this part, a regular cell interbank group quoted very simple. No arbitrary rules for the operation, also provided statements Run Dry Excel-type operation between the lattice, which is unmatched by traditional tools. [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0003.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0004.jpg[/img] Apart from the rules of interbank operations group, this month obtained under the conditions do not require continuous operation can also support it. [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0005.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0006.jpg[/img] 2.7 son returns In fact, the conventional sense from the table in the main stem statements Run son statements do not need to complete the concept. Son statements will lead to the master sheet data communication problems, inconvenience distribution arrangement, in principle, should make use of. [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0008.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0009.jpg[/img] Of course, Run Dry statements are statements of support elements can be introduced (the main form of data and format cells were filled) and Embedded (tensile or compression to the entire sub-form after the cells were embedded in the main table). [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0010.jpg[/img] [img]http://www.runqian.com.cn/rqrpt/raq_images/rqwebrpt_fem_1a_clip_image002_0012.jpg[/img] Acer 2.8 parameters and All statements, the tool provides a statement of function parameters, the Run Dry statements no exception. Data type parameters can be used to report data sources (SQL) statements or arithmetic expressions. Apart from the general parameters, the Run Dry statements are not traditional tools also provide Acer, Acer According to data type, only in the simple phrase or expression substitution. For example, which can be SQL SELECT FROM table listing or tape or even incomprehensible BY direction as Acer and SQL have changed, it will provide users with more flexible control. For example, if a SQL WHERE condition "into 100" 200 can be used with ordinary sense of the parameters, it wants to be "100 into" the 200, then it can not be done on the parameters of the operation, but Acer may easily. (To be continued, Please pay attention) Related reading : [url=http://www.runqian.com.cn/rqrpt/rqwebrpt_fea.htm][b][u] rapid understanding Run Dry statements [/b][/u] [ Closed window ]