Export image format PDF files with page break in web reporting tool

Background

In real application of web report, users often want to export report to PDF files. However, when users export web report to PDF file with API, there is usually no page break As a result, the exported PDF file may be very large, and the PDF file is of text mode.

Solution

RAQ Report is a Excel-like web-based Java reporting tool, and it provides a perfect solution to solve this problem.

With the API of RAQ Report, users can export web report as PDF file easily. Moreover, RAQ Report can export PDF files as image format with page break. As a result, the PDF file won’t be very large.

The only thing users need to do is setting the page break mode and image format for exporting web report to PDF file. The codes are as follows:

import java.io.FileOutputStream;
import java.io.OutputStream;
import com.runqian.report4.model.ReportDefine;
import com.runqian.report4.model.engine.ExtCellSet;
import com.runqian.report4.usermodel.Context;
import com.runqian.report4.usermodel.Engine;
import com.runqian.report4.usermodel.IReport;
import com.runqian.report4.util.ReportUtils;
public class ExportToPdf {
public static void main(String[] args) {
try{
String report = "D:/toExcel.raq"; //The location of report template
String pdfPath= "D:/test.pdf";
String licenceFile = "D:/2009-12-31V4.0Windows.lic"; //The location of authorization file
//Read report template
ReportDefine rd = (ReportDefine) ReportUtils.read( report );
//Second step: set report authorization file，and compute report.
ExtCellSet.setLicenseFileName( licenceFile );
Context context = new Context();
Engine enging = new Engine( rd, context);
IReport iReport = enging.calc();
ReportUtils.exportToPDF(pdfPath,iReport,true,true);
}catch(Exception e){
e.printStackTrace();
}catch(Throwable t){
t.printStackTrace();
}
}
}

The parameters of function exportToPDF(pdfPath,iReport,true,true):

The first parameter pdfPath is the path of the PDF file.

The second parameter iReport is the object of the report.

The third parameter is the page break mode of the PDF file. True means page break, while false means no page break.

The fourth parameter is the format of the PDF file. True means image, while false means text.

With this wonderful function, users can export perfect PDF file easily.

Source: Knowledge Base of Web Reporting Tool
Original Post: Export image format PDF files with page break in web reporting tool
Related Articles:
7 shortnesses of displayTag;
Comparison between RAQ Report and Crystal Report;
Business Objects - Get Crystal Report 2008 Prompts using InfoStore from CMS Repository;
Comma separated Column value in Crystal Report;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
*****## R.MARAN. ## *****;

Tag after Excel-like reporting tool, export image format PDF file, export pdf, page break, RAQ Report, web report, web reporting API

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.

Hide rows by adjusting row height in web report design

When design report, we often display all the content of web report. However, according to some special conditions, we may need to hide some corresponding rows in web report design.

Most designers choose to hide rows with condtion control. But in some conditions, it is very inconvenient. However, with RAQ Report, users can hide rows with some more flexible methods.

Here, I introduce a method which control row height with conditions to hide rows.

In grouping web report, when computing the sum of a group, it often need to hide the result. It can be realized by hiding rows according to conditions, but this may be inconvenient sometimes. In this condition, it can be also realized by adjusting row height.

Take 6.3.raq in the Quick_Start_Examples in the RAQ Report installation package. In this report, there is a sum of company number in each group. When the sum is 0, it should be hided.

With RAQ Report, users just need to write the height expression of the row as if(C3{}==7,0,8). Then, when the data of cell C3 is 0, the row height will be set as 0. So the row turned to invisible.

You could download RAQ Report from this URL: http://www.raqsoft.com/download/install-package/

Source: Knowledge Base of Web Reporting Tool
Original Post: Hide rows by adjusting row height in web report design
Related Articles:
Generating a Simple Crystal Report using VS 2005;
Comparison between RAQ Report and Crystal Report;
Hiding Detail Section In Crystal Reports (.Net);
The DataReport Designer;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
My Tutorial;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.

Export high precision time data from web report to Excel/Word file

Background

When exporting web report to Excel/Word file, the precision of high precision time data will decrease. That is because of the display format of Excel/Word. For example, if there are time data of millisecond, it will changed to second after being exported to Excel/Word.

This is troublesome for users of web report. then, is there a way to keep the precision of time data?

Solution

The answer is yes!

As a professional web-based Java reporting tool, RAQ Report pays a lot of attention to details. For this problem, RAQ Report provides a wonderful function — str().

Easy Operation

Users only need to write the function as str(value(),”yyyy-MM-dd HH:mm s.S”) as shown below. Then, time data can be displayed correctly after being exported to Excel/Word file.

Source: Knowledge Base of Web Reporting Tool
Original Post: Export high precision time data from web report to Excel/Word file
Related Articles:
7 shortnesses of displayTag;
Comparison between RAQ Report and Crystal Report;
HTML report dengan VB;
Exports generated crystal report into Excel Format & download;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
Dotnet SourceCode;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.

Make drop-down calendar for web application with web reporting tool

Background

A drop-down calendar will be very convenient for end users, it can increase efficiency greatly. The developers of client-side program all know this.

Programmer have 3 choices:

1. Develop a drop-down calendar by themselves.

It is a waste of time and energy. Like the tyre of a car broken, and you don’t mend it or buy a new one, but produce one yourself.

2. Download a free control from Internet. There are many disadvantages:
(1) Open source controls are only developed by programming enthusiast, so no one can guarantee its qualiti and performance.
(2) It is impossible to ask the makers to modify code for you. If you want to modify them by yourself, the workload may be huge.
(3) If you use many open source controls in a project, the application may be very unstable.

3. Buy a commercial web reporting development tool.

Solution

In fact, this is the best choice, and RAQ Report is a wonderful development tool which can solve all the problems easily.

RAQ Report is a professional Web-based reporting tool pays a lot of attention to users’ requirement. Therefore, users can solve all the common problems in web report easily with RAQ Report without writing program. Such as radio button for single choice or multiple choices, drop-down list, automation computation, automation sequential number, data validity check, and batch operations, etc.

Moreover, common functions have been encapsulated in RAQ Report, and users can use them without writing programs. Such as export Excel/Word file, printing, page break, image upload, etc.

Easy Operation

With RAQ Report, the only thing users need to do is setting Edit style. As shown below:

Graphic Illustration

Source: Knowledge Base of Web Reporting Tool
Original Post: Make drop-down calendar for web application with web reporting tool
Related Articles:
7 shortnesses of displayTag;
Comparison between RAQ Report and Crystal Report;
A few tricks working with Crystal Report Designer;
SQL Server Reporting Services (SSRS) Versus Browser Compatibility ;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
SharePoint, ASP.NET and more;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.

Design web report with graphical interface of reporting tool

Background

In the business of web input report, developers often need to design graphical interface for it.

If they have to use popular SSH structure (strust + spring + hibernate), the workload will be huge. Moreover, if they want to make it universal, it will be more difficult.

In this condition, I believe that programmers will miss those days in which client side programming was popular. For users’ data input, programmers can make a web input report with graphical interface easily with tools like Powerbuilder (PB).

Solution

Now, you have a wonderful choice!

RAQ Report is a professional web-based Java reporting software, it has a powerful programming class libraries without code. As a result, users can solve common problems in web programming easily. Such as drop-down box, automatic computation, sequential number generation, validity check, etc.

Moreover, common functions have been encapsulated in RAQ Report, and users can use them without writing programs. Such as export Excel/Wordfile, printing, page break, image upload, etc.

With the real Excel-like design interface of RAQ Report, the alignment of controls is very convenient. You can see the design interface of RAQ Report shown below. Is it much better than those client-side design tools?

Compared with open source control can be downloaded from Internet, RAQ Report has many advantages:

1. RAQ Report is a commercial product, so the quality and performance is better. While open source controls are only developed by programming enthusiast, so no one can guarantee its qualiti and performance.

2. The company RAQSOFT will maintain and update RAQ Report. But for open source controls, it is impossible to ask the makers to modify for you. If you want to modify them by yourself, the workload may be huge.

3. RAQ Report is designed and developed congruously, so you can develop a application project with it. However, if you use many open source controls in a project, the application may be very unstable.

4. RAQ Report has a graphical design interface, and it can increase the efficiency of web data maintain and input greatly.

Graphic Illustration

A web input report with graphical interface is showed as below:

Source: Knowledge Base of Java Reporting Tool
Original: Design web report with graphical interface of reporting tool
Related Articles:
Make dynamic association filtering for report’s data input;
Make drop-down box for multiple choices with reporting tool;
Make radio button effortlessly with reporting tool;
Make title area always aligned with data area ;
Useful Links:
Excel-like Web-based Java Reporting Software;
Freezea’s Report Lesson;
Reporting Insights from Raqman;
The business questions your performance measures should answer;

RAQSOFT: Innovative Techology Makes Progress.

For more about reporting tool, you are welcome to refer to freezea's blog.

Implement high precision computation in Java reporting tool -- RAQ Report

Background

For many reporting softwares, in order to accelerate operation speed, inputted decimal fractions will be set as double precision by default. However, in real business of web report, users sometimes need high precision computation of decimal fractions.

For example, in a financial report, when computing (5588.4 + 288.4)* 0.7, if we input “(5588.4 + 288.4)* 0.7″ in the cell, the operation result of the reporting tool is 4113.75999, while the precise result is 4113.76.

How to solve it?

Solution

RAQ Report is a professional Java Web-based reporting tool. With the function decimal() of RAQ Report, it’s very easy to solve the problem. Users just need to write the expression: (decimal(’5588.4′) +decimal(’288.4′))* decimal(’0.7′) in the cell. Then, users can get the precise result.

Source: Knowledge Base of Web Reporting Tool
Original Post: Implement high precision computation in Java reporting tool — RAQ Report
Related Articles:
BIRT Tips for Java Developers;
Save printing configuration at client-side with Java reporting tool;
Eclipse BIRT and AccuWork;
BIRT automatic odd even rows highlighting using style;
Useful Links:
Excel-like Web-based Java Reporting Tool;
Freezea’s Report Lesson;
Software Configuration Management;
Over 480 Open Source Applications and Resources;
Jackson’s Reporting Review

Display current page number and page amount with RAQ Report extHtml Tag

Background

Sometimes, in real business of web report, the volume of data may be very huge. Then, when reading, displaying and exporting the report, problems like low speed, memory overflow, and system crash may appear.

How to solve the problem?

As a professional Java Web reporting tool, RAQ Report always tries best to make users convenient. RAQ Report provides advanced paging tag extHtml which expands the functions of original Html tag, and realizes reading, displaying, and exporting data by page. Therefore, it decreases memory footprint, enhances operating efficiency, and avoids memory overflow.

Then, how to display a specific page or several specific pages in cell with RAQ Report extHtml paging tag?

Solution

There are two solutions.

1. Supposed that the number of default cache page is 100, set the value of cachePageNum as 1. Input expression “beginRow/20+1” in a cell to display current page number, and input the expression “totalCount/20” in a cell to display total number of pages. If the value of cachePageNum is not set as 1, the value of beginRow will not change, and the current page number will be 1 all the time.

2. Set the data type of a cell as html, and input the js code below to the cell.

<script>

document.write(report1_getCurrPage());

</script>

Then the current page number will be displayed when clicking “next page”.

Input the expression “=floor(query(‘SELECT count(*) FROM Dataset ’/20,0)+1” in a cell to display total number of pages.

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Change data source dynamically while updating web input report

Background

In web-based input report, users sometimes need to change data source dynamically. For example, in a web report, inputted data often need to be saved to different databases according to end users’ different options.

Then, how to achieve it?

Solution

RAQ Report is a professional Web-based Java reporting tool, and it can help users to make report easily.

As a real Excel-like reporting tool, RAQ Report provides a wonderful solution to change data source dynamically while updating web report. With RAQ Report, users only need to call RAQ Report API. Then, data sources will be dynamically changed when it’s runing.

ReportDefine rd = (ReportDefine)ReportUtils.read(raq);
INormalCell cell = rd.getCell(2, (short)1);
InputProperty ip = cell.getInputProperty();
ArrayList al = ip.getUpdateList();
UpdateProperty up = (UpdateProperty)al.get(0);
// Get the corresponding relation
Object relations = up.getRelation();
if(relations instanceof com.runqian.report4.usermodel.input.TableRelations){
TableRelations trs = (TableRelations)relations;
System.out.println(trs.getDataSourceName());
trs.setDataSourceName(“northwind”);
up.setRelation(trs);
ArrayList ups = new ArrayList(1);
ups.add(up);
ip.setUpdateList(ups);
cell.setInputProperty(ip);

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

How to achieve batch selection and deletion in row report with RAQ Report

Background

For users of report, efficiency is very important. However, sometimes users have to do some simple operation time and again.

For example, there are a lot of data on a web page when making a row input report. Users may want to delete the data of 28 rows. If they have to click the “Delete” button every time when they delete a row, the page will be refreshed 28 times. That’s very inefficiency.

Then, how to solve it?

Solution

RAQ Report is a pure Web-based Java reporting tool. As it is a professional Web reporting tool, RAQ Report can help users to achieve batch selection and deletion in a row input easily.

Operation

With RAQ Report, you only need 4 steps.

Step 1: Design the report as shown below:

Note: A2 is set as checkbox. Set “Off” 0 and “On” 1.

Step 2: In the jsp file, add batch deletion javascript as follows:

function deleteRows(){
var report = document.getElementById(’report1′);
for(var i=report.rows.length-2;i>0;i–){
var row = report.rows[i];
if(!row.all.tags(”input”)[0].checked) continue;
var cell = row.cells[1];
report.currCell = cell;
_deleteRow(report);
}
}

Step 3: In the jsp file, add checkbox javascript as follows:

function selcheck() {
var objs = report1.getElementsByTagName(”input”);
for(var i=0; i<objs.length; i++) {
if(objs[i].type.toLowerCase() == “checkbox” )
objs[i].checked =event.srcElement.checked;
}
}

Step 4: In the jsp file, add operating button javascript as follows:

<table>
<tr>
<td style=”background-color:”>
<div noWrap style=”font-family: Ming;font-size:13px;color:;”>
Select all:<INPUT type=”checkbox” onclick=”selcheck()”>&nbsp;
<span style=”cursor:pointer” onclick=”_insertRow( report1 )”>Insert</span>&nbsp;
<span style=”cursor:pointer” onclick=”_appendRow( report1 )”>Add</span>&nbsp;
<span style=”cursor:pointer” onclick=”deleteRows()”>Delete</span>&nbsp;
<span style=”cursor:pointer” onclick=”_submitRowInput( report1 )”>Submit</span>
</div>
</td>
</tr>
</table>

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Display process bar in cell directly with reporting tool -- RAQ Report

Background

For users of report, graphics is much more intuitive than data. As a result, statistical chart is widely used in report. However, sometimes users may want to display the process bar in cell directly to compare data.

Solution

RAQ Report is a professional Web-based Java reporting tool, and it can help users to make all kinds of complex reports with statistical chart.

At the same time, as RAQ Report is a real Excel-like reporting tool, users can display process bar in cell directly with it. Moreover, users even can make process bar with data in cell.

Example

Design a report like the one below:

A3=&B3
B3= ds1.select(Order ID,true,,ShipVia)
C3= ds1. ShipVia
D3=(C3/C3[`0]{}[1])*100
E3=”<table width=”+D3[`0]{}[A3]+”% border=0 cellspacing=0 cellpadding=0> <tr> <td bgcolor=#990033><div color=#ffffff align=right>”+C3+”</div></td> </tr> </table>”

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Realize default value/sequential number with reporting tool

Background

Default value is commonly used in the data input interface of Web report. With it, some fields of newly added record can be generated automatically. Sometimes it is for the convenience of users. Sometimes, it is used when users aren't allowed to input these fields.

Sequential number is a particular case of default value. It has a steady increment or decrement, while complex default values don't have this rule.

Difficulty

For a Web report without dynamic addition and deletion, it may be not very difficult to realize default value/sequential number in input interface.

However, for a Web report with dynamic addition or deletion, it will be very difficult, especially for sequential number.

One of the most important characteristics of sequential number is that it is non-repetitive. But under B/S mode, in the condition of concurrent access, users’ browsers don't need to interact with server for addition or deletion of row. Otherwise, the interaction cost is too must huge. Therefore, it is very difficult to keep sequential number non-repetitive in every browser in B/S mode.

Solution

For users' convenience, RAQ Report provides thoughtful function of default value/sequential number. With RAQ Report, client-side browser can dynamically compute the starting value of sequential number by expression, and realize perfect sequential number function through flexible rules of steady increment or decrement.

Easy Operation

1. Set Report style as Row report and set Input type as Input Report. As shown below:

2. Write starting value expression and define rules for steady increment or decrement. As shown below:

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Make importable drop-down box with reporting tool

Background

For its outstanding advantages, drop-down box is common in the data input interface of Web report. However, usually it is only for selection. If drop-down box can be used for both selection and data input, it will be more useful.

Difficulty

To make importable drop-down box, difficulties below need to be solved.

1. Make a drop-down box which can be used for both selection and input.

2. Judge user's input is display value or truth value.

3. If user's input is display value, it needs to be matched to corresponding truth value.

4. Add a switch used to decide whether users are allowed to input a new value.

5. For multiple choices, it needs to provide controls like empty and check all.

Solution

According to users’ requirements in real business, RAQ Report provides a complete set of drop-down boxes. With RAQ Report, the only thing users need to do is checking needed options in the properties box of edit style. As shown below:

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Make dynamic association filtering for report’s data input

Background

The data of report usually have various interrelations. Therefore, when designing a data input interface, we usually meet two drop-down boxes with direct relations. In this condition, dynamic association filtering will be very helpful for data input.

For example, one is province, and another is city. Then, after selecting a province, only the cities of that selected province should be available.

Difficulty

It is very difficult to realize dynamic association filtering by writing JavaScript. According to the example above, difficulties are as follows:

1. Save a JavaScript dataset which contains all the cities.

2. In the province drop-down box, keep a record that which cell is the city drop-down box. Then, when the value of the province drop-down box changed, the dynamic association filtering of corresponding cell will be triggered.

3. Write dynamic association filtering algorithm. Each time the value of the province drop-down box changed, the algorithm will be used. Therefore, the efficiency of the JavaScript should be much high. But it is very difficult.

Above is only a case with two drop-down boxes. In fact, there are some more complex situations.

Sometimes, a drop-down box controls several drop-down boxes. When the value of it changed, the values of all related drop-down boxes should be changed correspondingly.

Another complex condition is cascade association filtering. It means that drop-down box A controls drop-down box B, and drop-down box B controls drop-down box C, and so on.

Even if dynamic association filtering can be realized by writing programs, the workload must be very huge.

Solution

For users’ convenience, RAQ Report provides the function of dynamic relation filtering directly. With RAQ Report, users only need to define condition expression for dynamic association filtering and select a trigger cell. As shown below:

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Make drop-down box for multiple choices with reporting tool

Background

Drop-down box has many advantages. Such as simplifying data input, avoiding wrong input and realizing the mapping between display value and code, etc. Therefore, it is very common in the input interface of Web report.

Usually, drop-down box is made for single choice. But in real business, the value of a field may have several choices. In this condition, a drop-down box for multiple choices will be helpful.

Take an employee information report for an example. An item is specialty foreign languages, and someone may be good at several foreign languages. If users have to design a column for each foreign language, the structure of the report will make users crazy. Then, if users can make a drop-down box for multiple choices, and those selected foreign languages can be saved in only one field, the problem will be solved.

Difficulty

It seems that the function is easy to realize. But this is not the case. Main difficulties are as follows:

1. The data submitted from multiple choices box to background is an array. Before saving it into database, programmers have to write program to transform it to a string separated by comma.

2. The data saved in database is a string. Before modifying the data in multiple choices box, programmers have to write program to transform the string to an array, and then display it in the input interface.

3. When there are too many options, drop-down box will be inefficient. In this condition, a drop-down tree will be helpful. However, as leaf node allows multiple choices, and branch node doesn’t allow doing this, programmers have to set different properties for them. Therefore, it is much more difficult.

Solution

As a professional Web reporting tool, RAQ Report does everything to make users feel convenient. With thorough consideration of corresponding detail, RAQ Report provides a multiple choices option for many edit styles directly. Such as drop-down list, drop-down dataset, and drop-down tree, etc. With this wonderful function, users can realize multiple choices easily.

Easy Operation

1. Set Report style as Row report and set Input type as Input Report. As shown below:

2. Define the edit style of the report. Such as drop-down list, drop-down dataset, and drop-down tree, etc.

3. Check the Multi Selection option in the properties box of edit style.

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Categories -- Something Else

Categories -- Else about Report

Implement high precision computation in Java reporting tool -- RAQ Report

Display current page number and page amount with RAQ Report extHtml Tag

How to achieve batch selection and deletion in row report with RAQ Report

Give you enough string functions in reporting tool

The matching between code and display value in reporting tool

Do you want more date time functions in reporting tool?

Built-in dataset: an innovation in reporting tool

Make cell unassailable to random content

How to insert local report with report wizard?

7 shortnesses of displayTag

Preformatted Paper Printing of RAQ Report

The Integration Solution of WEB Report—with RAQ Report

Categories -- Web Input Report

Wonderful solution for complex data input in web report

Implement validity check in input report with web reporting tool

How to customize prompt confirm message box for web input report?

Achieve checking multiple selections and batch deletions in row input report with RAQ Report

Realize remote design with web-based reporting tool — RAQ Report

Make importable drop-down box with reporting tool

Make dynamic association filtering for report’s data input

Make drop-down box for multiple choices with reporting tool

Dynamic Row & Automatic Computation for Input Report

Dynamically add or delete a row when inputting data

Import Excel files easily in reporting tool

Highlight current row and column when inputting report data

Make radio button effortlessly in reporting tool

Save report's inquiry condition for convenience

Dropdown tree makes report's data input faster

Dynamic appearance can make a report seems clearer

The Function of Data Inputting

Categories -- Report Design

Connect to data source when making web report with Java reporting tool — RAQ Report

Hide rows by adjusting row height in web report design

Make drop-down calendar for web application with web reporting tool

Design web report with graphical interface of reporting tool

Submit data to multi-dataset/multi-source with web-based reporting tool -- RAQ Report

Change data source dynamically while updating web input report

Display process bar in cell directly with reporting tool -- RAQ Report

Realize default value/sequential number with reporting tool

Make title area always aligned with data area

Don't let sub report uglifies your report

Easy pagination of mergence cell

How to arrange card type reports with ease?

How to easily set page break as you like?

How to fix report head easily?

High-Efficiency Report Design

Categories -- Reporting tool

Are you seeking for a user-friendly Java development tool?

A good Java installation package can make things much easier

Comparison between RAQ Report and Crystal Report

The Excel-like Design Style of Reporting Tool

Making Java Report by Drag and Drop?

The Basic Standard of Excel-like IDE

The Procurement Cost of Web Reporting Tool

Reporting Tool: Open Source or Charge?

Dynamic Row & Automatic Computation for Input Report

Background

With the popularization of B/S mode, data input is transferred to web page gradually, and the most common requirements of data input are dynamic addition and deletion of row, and automatic computation.

Dynamic addition and deletion of row means that users can add new rows or delete some existing rows when input data. Except for data, newly added rows should have the same properties with existing rows.

Automatic computation means to compute some other cell values according to the cell values inputted by user. It can simplify data input and avoid wrong input.

For an input report which allows dynamic addition and deletion of row, its automatic computation is more complex. The data of newly added rows need to be added to the expressions, such as sum(), count(), etc. While the data of deleted rows should be subtracted from them.

Difficulty

In html page, it is difficult to realize the automatic computation of input report with dynamic rows. While in C/S mode, it's easy to realize

In pure html pages, only JavaScript is a universal reporting tool. In theory, writing automatic computation expression with JavaScript is feasible. But in real business, it is infeasible. Two main reasons are as follows:

1. As a script programming language, JavaScript's efficiency is relatively low.

2. The function of JavaScript is relatively weak. Writing versatile program to realize the function with it, the amount of code will be very big. Then, web page will be too big to download.

Then, in order to realize the automatic computation with JavaScript, the only way is writing program according to specific condition. It means to write a piece of JavaScript code for each kind of report. However, this method has no commonality, and the workload will be too huge.

Solution

RAQ Report is a wonderful Web reporting tool. In order to reduce the workload of users, RAQ Report invented a new algorithm after intensive study. With this algorithm, users can realize the automatic computation of input report with dynamic rows easily.

Easy Operation

1. Design the report.

The Excel-like IDE of RAQ Report

2. Set Report style as Row report and set Input type as Input Report. As shown below:

3. Write automatic computation expression according to business requirement.

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Import Excel files easily into reporting tool

Background

As Excel is easy to use, a great number of end users like to make report, save and submit data with it. Therefore, before involving a reporting tool or starting an information project, users may have had a lot of Excel files. Then, it will be helpful if the report styles and data of these Excel files can be imported into reporting tool.

Accordingly, the requirement should be divided in two:

(1) Import the report style of Excel file into reporting tool.

(2) Import the data of Excel file into reporting tool.

Difficulty

(1) Import the report style of Excel file into reporting tool

As the purpose is to reduce the workload of redesigning report style, imported report style must be exactly the same with that in Excel file. Or else, users have to re-modify it, and the function is meaningless.

For most reporting softwares, the design mode is a combination of control (drag and drop) and band, rather than Excel-like mode. Therefore, the design interface is different with Excel, and it is usually impossible to import the report style of Excel file directly.

What about importing report style by programming?

For the design interface of common reporting softwares is divided into several regions by bands, and programmers can't get the dynamical relations between the content of Excel file and bands, programmers have to import all the content into only one band. Then, it is impossible to use the characteristics of band.

Then, someone may wish to use the characteristics of band by writing several programs for reports of different styles, and fixing the number of rows for each region. However, with the powerful mergence cell of Excel, there may be innumerable report styles, and only a few of them fit band style. Consequently, it is also infeasible.

(2) Import the data of Excel file into reporting tool

It means to import the data of Excel file into report, and submit the data to database. Then, the requirements are as follows:

1. Report can submit the data to database.

2. Report can match cells with database fields and records freely.

3. There is a one-to-one relationship between report cell and the data of Excel file.

4. Check data validity and user rights before submitting data to database.

Moreover, even for a simple manifest report, it is difficult to import the data of an Excel file with uncertain number rows. Programmes have a lot of problems to answer. How to import the data into html input interface? How to update newly additive rows to database? How to establish the relation with database? Although it can be realize by programming, the workload will be huge and the commonality must be bad.

Solution

As a real Excel-like reporting tool, RAQ Report provides a perfect solution for users. With wonderful Excel-like design mode, its report style is compatible with Excel naturally, and can be imported seamlessly. Combined with the free connection technique for database and report, users can easily import the data of Excel file into RAQ Report, and then submit the data to database after checking data validity and user rights.

Easy operation

1. Import the report style of Excel file.

2. Set Input type as Input Report, and define the logic of Update and Validation.

3. Release the report on web.

4. Import the data of Excel file and save the report.

For an Excel file with uncertain number of rows, users just need to set Report style as Row report.

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Highlight current row/column when inputting report data

Background

Sometimes, there are too many records in a Web report. Therefore, it may be dazzled for users' data inputting. Especially when the report is too wide, users may be confused and forget which cell is the current cell after dragging scroll bars horizontally or vertically.

Then, it will be very convenient for users if reporting tool can highlight current row and column in data inputting.

Difficulty

Most reporting tools don't provide this function, and programmers have to realize it by programming. Then, two main problems need to be solved are as follows:

(1) Get the current location of the cursor.

(2) Reload onClick event or similar focus event.

However, as common reporting tools don't open these properties, it is difficult for programmers.

Solution

Now, there is a wonderful available choice for users! As a professional Web reporting tool, RAQ Report provides this function with easy operation, the only thing users need to do is defining corresponding properties in JSP, like background color and border.

Graphic Illustration

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.

Make radio button effortlessly with reporting tool

Background

Radio button and drop-down box are two common styles in the data input interface of Web report.

When there are not too much options, radio button is better than drop-down box.

Think about your usage of these two styles in Web report. With drop-down box, you have to click the mouse at least twice. While only once is enough with radio button. Moreover, radio button is more intuitive as you can get to know available options at a glance.

An example is shown below:

Difficulty

Some programmers may think that it is easy to make a radio button by programming. In fact, it is much more difficult in real business. Users have to pay great attentions to the problems below:

(1) Dynamic number of options. In a radio button, the number of options is dynamically determined by data.

(2) The widths of the radio button. It is dynamically determined by the number of options.

(3) The width of the cells at the right side of the radio button. When the width of the radio button changed, they need to be changed dynamically.

(4) The locations of the cells below the radio button. When the radio button is too wide to be displayed in a row, they need to be changed dynamically.

Solution

With RAQ Report, users can make radio button effortlessly in Web report now. All things users need to do are defining options and set the number of options for each row easily. Then, RAQ Report will do anything else.

Graphic Illustration

The screenshot of RAQ report’s IDE

A report with radio button made by RAQ Report

RAQSOFT: Innovative Techology Makes Progress.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.