Checking datatype dynamically?

Happy · 2009-09-05T23:14:27+00:00

Hi there, I have a situation where datasets are being generated dynamically and populated into a table (also dynamically generated using javascript). The issue I am facing is that I wish to know what datatype a particular column is, and set a drill-through action depending on the result. In…

Happy

Hi there, 
I have a situation where datasets are being generated dynamically and populated into a table (also dynamically generated using javascript). 
 
The issue I am facing is that I wish to know what datatype a particular column is, and set a drill-through action depending on the result. 
 
In particular, if the datatype assigned to a column is a 'blob', I wish to set a hyperlink to another report to process the blob data. Or, if easier, if the datatype != 'blob', I wish to remove the existing hyperlink action. 
 
Cheers 
 
 
for reference, here is the script as it stands, located in the onPrepare for a table. 
 
importPackage( Packages.org.eclipse.birt.report.model.api ); 
importPackage( Packages.org.eclipse.birt.report.engine.api.script); 
 
//get a reference to the ElementFactory 
myTable = reportContext.getReportRunnable().getDesignHandle().findElement("dynamicTable"); 
elementFactory = reportContext.getReportRunnable().getDesignHandle().getElementFactory(); 
//structureFactory = reportContext.getReportRunnable().designHandle.getStructureFactory(); 
myDS = reportContext.getReportRunnable().designHandle.findDataSet("DynamicDataSet"); 
 
//header = table.getHeader( ).get( 0 ); 
HeaderRow = myTable.getHeader().get(0); 
DetailRow = myTable.getDetail().get(0); 
 
computedSet = myTable.getColumnBindings( ); 
//reportContext.getReportRunnable().designHandle. 
 
//FirstRow.setProperty("style", "table-detail"); 
DetailRow.getCells().get(0).setProperty("style", "table-detail"); 
 
columnNameArray = params["ColumnNameList"].value.split(","); 
var i=0; 
for (i=1;i<params["COLUMNCOUNT"].value;i++) 
{ 
myTable.insertColumn(i, 1); 
DetailRow.getCells().get(i).setProperty("style", "table-detail"); 
 
} 
for (i=0;i<params["COLUMNCOUNT"].value;i++) 
{ 
myHeaderCell = HeaderRow.getCells().get(i); 
Headerlabel = elementFactory.newLabel( null ); 
Headerlabel.setText( """ + columnNameArray + """);//$NON-NLS-1$ 
myHeaderCell.getContent( ).add( Headerlabel ); 
 
//myTable.insertColumn(i, 1); 
myCell = DetailRow.getCells().get(i); 
cs1 = StructureFactory.createComputedColumn( ); 
cs1.setName(""" + columnNameArray + """); 
cs1.setExpression( "dataSetRow["" + columnNameArray[i] + ""]"); 
computedSet.addItem(cs1); 
data = elementFactory.newDataItem( null ); 
data.setResultSetColumn(""" + columnNameArray + """); 
 
//elementFactory. 
//if (dataSetRow[columnNameArray].getParams("dataType") == 'BLOB') 
// This does not work, should action everything 
 
drillAction = StructureFactory.createAction(); 
datahandle = data.setAction(drillAction); 
datahandle.setLinkType("drill-through"); 
datahandle.setReportName("BlobConverter.rptdesign"); 
datahandle.setTargetFileType("report-design"); 
datahandle.setTargetWindow("_blank"); //CHANGE ME 
 
myCell.getContent().add(data); 
}

Find more posts tagged with

Comments

mwilliams

Hi Happy,

In the onCreate method of the data element, you can do something like the following to figure out the class of the data:

this.getValue().getClass().getName();

When I did this on an integer data element and printed this value out to the report, I got, "java.lang.Integer". Let me know if this helps at all.

Happy

Thanks, I discovered this method after I changed my approach. Currently I have 1 dataset per DB table, one table per dataset, a report parameter to select the dataset and an initialisation script to delete all tables but the selected.

I'll probably combine both my templates into a mega template of doom soon enough.

(so far the feasability study into using BIRT as a database Retrieve/Filter web viewer is going well, just need to see how difficult it is to add in some kind of form to filter by a list of database tables with an input text box, feeding into the same report as a report parameter)

Fun times
Oh, and that Birt-Viewer application is pretty much the sole reason I have been looking at BIRT rather then Jasper Reports at the moment, it is very well made.

mwilliams

Happy,

Well, let us know whenever you have questions. We'll try to help.