Change data source dynamically while updating RAQ 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);
Source: Knowledge Base of RAQ Report
Related Articles:
The Function of Data Inputting; Using BIRT as View in Spring; 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; Why Will 2009 be a Great Year for Business Intelligence?; Vara Prasad S Manjula’s Blog; Jackson’s Reporting Review