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

Background

When developing data input module based on web, users always have to provide a data submission solution. The complexity of the solution is determined by the complexity of the input web-page.

Some conditions in an increasingly complex order are showed below:
1. There is only one record on the web-page.
2. Records correspond to a table of a database.
3. Records correspond to many tables of a database.
4. Records correspond to many tables of different databases.

Difficulty

1. Keep the transactional database consistency, especially when there are several databases.

2. Convert data type. The type of submitted data from web page is unrecognized; as a result, it has to be converted to proper type in database in the background.

3. Update the mapping relationship between field and the input cell on web page, especially a record corresponds to several cells indifferent expansion regions, or a field corresponds to a expression composed by several cells.

Someone may say that all these difficulties can be solved by writing program. However, the program has no commonality, and the workload will be huge.

Solution

RAQ Report is a professional web-based reporting tool. For users’ convenience, RAQ Report provides an almost perfect data submission solution: Multiple Database/Dataset Input Report.

With the Multiple Datasource/Dataset Input Report solution of RAQ Report, users can relate different tables from different databases, and submit data to multiple tables/databases, and keep the transactional consistency of database easily.

Easy Operation

1. Design an input report.
2. Define the Update attribute of the report. As shown below:

3. Release the report.

Source: Knowledge Base of RAQ Report
Original Post: Submit data to multi-dataset/multi-source with web-based reporting tool - RAQ Report
Related Articles:
Six Quick Crystal Reports Design Tips;
Evaluation-Time functions in Crystal Reports Formulas;
Keep the matching between code and display value in reporting tool;
Writing to a database from Report Studio;
Useful Links:
Knowledge Base of RAQ Report;
Freezea’s Report Lesson;
Java Products and software download;
Vara Prasad S Manjula’s Blog;
Jackson’s Reporting Review

Tag after data input module, multi data source, multi dataset, RAQ Report, transactional database consistency, web-based reporting tool

RAQSOFT: Innovative Techology Makes Progress.

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

Video: Inside The Google Holodeck

At this past week’s Google I/O event in San Francisco, Google brought a contraption it calls the “Holodeck,” for event-goers to experience. Basically, it’s a near-360 degree way to view Google Street View in fast motion, high definition video. Danny Sullivan posted a bunch of pictures of the thing earlier in the week.

Unfortunately, Google only allows it to show the area at and around the actual Google campus in Mountain View, as I’m sure it doesn’t want any legal complaint from those caught sunbathing in their backyards. Also, while it does zoom past the area where the Google Goats were kept, it unfortunately failed to catch any of them on tape. Luckily, I did that for you a few weeks ago.

Google’s Holodeck isn’t quite as cool as the Star Trek Holodeck, but give them a few years, I’m sure they’ll figure out how to do that as well.

Data input solution after changing data source dynamically in RAQ Report

Problem

Sometimes, users may change the data source of input report template through RAQ Report API dynamically. However, after releasing the input report template with tag, an error message “Can’t find data source!” usually appears when users are inputting data in the web page.

Analysis

Through API of RAQ Report, users can only change the name of the data source of report template dynamically, but not change the data source in updated attribute correspondingly. As a result, the data sources in input template and updated attribute are different. Then, when users are inputting data, the system can’t find correct data source, and an error message pops up.

Solution

After changing the data source of report template, users should change the data source of updated attribute correspondingly.

With RAQ Report, users only need to get the corresponding relations between input report attribute and updated attribute, and change the data source of updated attribute.

Example

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

Source: Knowledge Base of Java Reporting Tool
Original Post: Data input solution after changing data source dynamically in RAQ Report
Related Articles:
Submit data to multi-dataset/multi-source with web-based reporting tool — RAQ Report;
Make drop-down calendar for web application with web reporting tool;
Design web report with graphical interface of reporting tool;
Wonderful solution for complex data input in web report ;
Useful Links:
Knowledge Base of Web Reporting Tool;
Reporting Insights from Raqman;
Live in Reporting;
Dynamic datasource selection for BIRT and e.Spreadsheets;

Tag after API, data input, data source, dynamic data source, input report, input report template, java, RAQ Report, web input, web reporting

RAQSOFT: Innovative Techology Makes Progress.

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

Analyse the error of database connection factory in web report development

Problem

For the users of web report tool, when developing web report, they need to configure dataset at first. When data source is complicated, they often want do some special handling to dataset. With the dataset factory listener class of RAQ Report, they can realize this idea.

However, users may meet a few problems in the use of dataset factory listener class. Next, we will introduce the common problems to help users to develop web report correctly with RAQ Report.

Error information

Error code 500 Message: : Failed to generate dataset factory: com.runqian.report4.dataset.SQLDataSetFactory Error source: : In dataset ds1, datasource report/core_epm is setted falsely or not running, please check data source: Abnormity: : Failed to generate dataset factory: com.runqian.report4.dataset.SQLDataSetFactory Error source: : In dataset ds1, datasource report/core_epm is setted falsely or not running, please check data source: at com.runqian.report4.model.CalcReport.calcDataSet(Unknown Source:317) at com.runqian.report4.usermodel.Engine.calc(Unknown Source:96) at ep.verify.expression.VerifyExpression.reportExpressionCalc(VerifyExpression.java:57) at ep.commons.init.InitShowReportParams.verifyReport(InitShowReportParams.java:63) at ep.commons.init.InitShowReportParams.(InitShowReportParams.java:43) at org.apache.jsp.reportJsp.showReport_jsp._jspService(showReport_jsp.java:68) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Possible Reasons

1. Check the contxet of public void beforeCreated method which is setted to the IDataSetFactoryListener interface. If there is only connection in it, you’d better to set dataset factory. Then, if the connection in context is closed, data can be got from dataset factory.

2. Print connection. If it isn’t empty, the reason may be that datasource is configured repeatedly. If data source information is configured in reportConfig.xml before, users are not allowed to configure it in custom codes again. Or else, it will report error. To solve the problem, users only need to delete those configuration codes.

Source: Knowledge Base of Java Reporting Tool
Original Post: Analyse the error of database connection factory in web report development
Related Articles:
Analyse the error of database connection factory in web report development;
Make cell unassailable to random content with reporting tool;
Built-in dataset: an innovation in reporting tool;
Keep the matching between code and display value in reporting tool ;
Useful Links:
Web Report Software;
Freezea’s Report Lesson;
Jackson’s Reporting Review;
Using a supplied connection with BIRT;

Tag after data source, database connection factory, dataset factory listener class, error analysis, free reporting tool, Java report, RAQ Report, web report, Web reporting tool

RAQSOFT: Innovative Techology Makes Progress.

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

Better integration solution of Web reporting tool

Background

Report development is only a part of application program, therefore, the integration of Web reporting tool is of great importance.

All the traditional Web reporting tools provide an independent report server without exception. With an independent report server, the application architecture is shown below:

The application architecture of traditional reporting tool

The disadvantages of an independent report server:
● The independent report server communicates with application program via network protocol, and this degrades system performance seriously.
● It is unable to use all the advantageous functions of application server, such as the cluster capability, the management capability of connection pool, etc.
● Report server has an independent management mechanism of user permissions, which can not adapt the requirements of particular user role management from various industries and applications. It is insufficient, while it force application program to obey its rules.
● With too few APIs and weak control, it is hard to integrate.

Solution

RAQ Report is a professional Web reporting tool.
As a pure Java reporting software, RAQ Report provides integration as Jar package to programmers. Without independent report server, application infrastructure, and independent management mechanism of user permissions, RAQ Report can help programmers to implement integration conveniently. Its application architecture is shown below:

The application architecture of RAQ Report

The advantages of no independent report server:
● The server of RAQ report is submitted as Jar package or application of application server. Therefore, it can get integrated with application program seamlessly to achieve the peak operating efficiency.
● Share the cluster capability and the management capability of connection pool of application server.
● Make unified deployment. Use the user role management mechanism of Web application directly to avoid the incompatible problem of two management mechanisms. Provide a unified login screen, and end users need not to log in twice.

Source: Knowledge Base of Web Reporting Tool
Original Post: Better integration solution of Web reporting tool
Related Articles:
How to arrange card type reports with ease?;
Input type of RAQ Report;
Which one is better for reporting tool: open source or charge?;
Keep the matching between code and display value in reporting tool;
Useful Links:
Excel-like Web-based Java Reporting Tool;
Freezea’s Report Lesson;
Insights from Raqman;
Live in Reporting;
Jackson’s Reporting Review

Tag after Java reporting software, RAQ Report, Report Deployment, Web reporting tool

RAQSOFT: Innovative Techology Makes Progress.

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

Contenture Wants To Fail Whale Your Ad Network

The web is increasingly filling up with ads. Many sites, including this one, have a bunch of them all around with the hopes that you’ll find one relevant to you, and click on it. Of course, most of you don’t. And if you do, it may be by accident. As you can tell, I’m not exactly bullish on the model. But the problem is that there are few alternatives. Contenture is trying to offer one.
The service has been getting some buzz over the past few months, but mostly because no one seemed to know what the hell it was all about. An email today finally revealed their model. Contenture wants to be the “anti-ad network.” What it means by that is that it wants sites to adopt their monthly-fee based network to offer visitors the option to do things like turn off ads. Yes, this would basically turn your site to the subscription-based model.
But there’s a somewhat interesting twist. Contenture wants to sign up a bunch of sites to this model and have users pay one flat monthly fee to have access to all of these sites. That money would then be distributed to all of these sites. These sites could determine what Contenture subscribers get as a part of their subscription. Some may lose the ads, some may have special commenting ability, etc.
A similar model has been tried by the likes of TipJoy and others, but grouping sites together and offering users a place to pay one-fee for multiple sites is interesting if nothing else. Plus the site has a comic homepage that features a drunk Twitter Fail Whale and makes fun of its competitors. That’s pretty cool in our book.
The service is still in private beta testing, but apparently it’s getting ready to launch on May 21.

Don’t let sub report uglifies your report

Background

In Web Report, Sub report is a inportant technology, which is used to deal with some complex reports that can’t be achieved by basic models. In other words, you can design a relatively independent part of a report as a sub report, and add it to the main report.

For users’ consideration of report’s neatness, it’s very important to align the gridlines of main report and sub report.

Then, is it easy? No.

Difficulty

For traditional reporting tools, the report frame is built on some basic controls. As this type of reporting tools is not Excel-like/grid-shaped construction, it is impossible to design accurate aligned gridlines.

For new grid-shaped reporting tools, the report frame is formed by straight lines. As they have a real construction of the gridline, if they follow the method of the traditional-control reporting tools (it’s called embedded), unaligned gridlines will bring down the neatness and beauty of report, and even affect the reusing of the report. For example, report data with unaligned gridlines can’t be organized in the form of Excel or export to Excel.

In aligning gridlines, the biggest difficulty is how to align rows and columns between main report and sub report.

Solution

As a real Excel-like reporting tool, RAQ Report pays great attention to details in report design. With the combination of cell expansion and sub report model, RAQ report made the model of Imported Sub Report. With imported sub report, users can align gridlines easily.

Easy Operation

1. Design main report and sub report separately.

2. Import the sub report into the main report, and select the import type: Imported.

3. Browse and release it.

Graphic illustration

Source: Knowledge Base of Web Reporting Tool
Original Post: Don’t let sub report uglifies your report
Related Articles:
Dynamic appearance can make a report seems clearer;
7 shortnesses of displayTag;
Implementing IReportServerCredentials Interface;
Crystal Reports and SQL Server CE;
Useful Links:
Excel-like Web-based Java Reporting Tool;
Freezea’s Report Lesson;
Jason Irwin dot Net;
a developer’s breadcrumb;

Tag after align gridlines, insert sub report, RAQ Report, sub report, web report design, web report Java reporting tool

RAQSOFT: Innovative Techology Makes Progress.

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