Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change data source dynamically while updating web input report Expand / Collapse
Author
Message
Posted Tuesday, September 15, 2009 7:24 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 04, 2009 5:07 AM
Points: 5, Visits: 66
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.

As a professional Web-based Java 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);


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 his blog.


Welcome to my blog.:P
Post #788663
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse