Excel-like Design Style
Have you ever seen a tool whose interface environment is more suitable for designing static reports than EXECL’s?
It is believed that readers who have the experience of making reports or have viewed a great many reports must have the same negative answer; the interface environment of EXCEL is indeed the best choice of designing reports, its design efficiency and easy operation make it have incomparable advantages over others in designing static reports.
The same controversy happened in the business professional reporting tool industry, which design pattern is better? Design pattern of control dragging and dropping or design pattern similar to EXCEL. After all, several report tools who are the leaders in report tool industry use the design interface of control dragging and dropping, but since RAQ Report releases report design tool similar to EXCEL, there is a resounding reply to the controversy: even in professional report tool industry, the efficiency of report design pattern similar to EXCEL is much higher than that of report design pattern of control dragging and dropping. As the conclusion above: after accustomed to the design environment of EXCEL, no body is willing to make up report by rectangular frames in PowerPoint.
Even for the non-professionals, EXCEL is a report making tool which is easy to use, it takes you just a little time to master report design preliminary, and create tables with attractive appearance. Now let’s see to what extent design pattern of
RAQ Report which is similar to EXCEL inherits the features of EXCEL.
Design interface of RAQ Report (similar to EXCEL)
Main design interface is the most common two-dimensional spreadsheet with rows and columns. Here when we set the format, we will find that RAQ Report and EXCEL have the same functions used for setting static format;
- Set the cell weight and height, background color, font color, display format, wrap text, borders etc.
- Set font-name, font-size, bold, italic, underline, etc.
- Set horizontal alignment, vertical alignment;
- Format painter;
It has no difference with EXCEL when defining the format, and besides static format, design environment of RAQ Report imports EXCEL cell expression as well. Do you remember how to define expression in EXCEL? When you want to summarize the data in A3-D3 and put the result in E3, you should write the expression: =SUM (A3:D3) in E3. You can try the same example in RAQ Report, and you will find that the expression processing in RAQ Report is rather similar to EXCEL.
RAQ Report can auto adjust the expression in position changed cells as EXCEL, in the table above, we insert a new column between B3 and C3, the expression of F3 (original E3) can be adjusted to:=SUM(A3:E3) automatically in EXCEL; likewise, in designed table of RAQ Report, when you inserts a row or a column, corresponding expressions will be adjusted automatically as well. Not only that, the flexible expressions such as: A2+B3-A4,(A1+E2*D4)/C3 can also be calculated accurately as in EXCEL.
RAQ Report implements the function of dynamic data expansion on the base of imported design habits of EXCEL. It is the function that can not be implemented by EXCEL, for example:
Its design interface is as follows:
In the terms of efficiency, when processing the reports as shown above, RAQ Report is the effective tool for report design. It is because of the advantaged design pattern of RAQ Report which is similar to EXCEL, the efficiency of making the same report can be increased by 90% compared with other report tools. And that is the reason why since the advent of RAQ Report, it is welcomed by report designer, programmers, and project managers. Compared with the traditional report tools，RAQ Report increases the efficiency of web report design, shortens the development cycle and reduces the development cost. It is an indispensable report tool and represents a new generation of report tools.