Hi, Folks,
I use IDataPreviewTask to preview a data
set.
But the last column's value does not show
up, the first column's values are replaced by 0,1,3,4….
This is an Employee table
EMPLOYEENUMBER should be 1002, 1056…..
but is replace by 0,1, 2,3…
The JobTitle’s values are gone. I
don’t what is wrong
Please help,
Chaohua
Please see the result.
-------------
EMPLOYEENUMBER--LASTNAME--FIRSTNAME--EXTENSION--EMAIL--OFFICECODE--REPORTSTO--JOBTITLE--
0--1002--Murphy--Diane--x5800--dmurphy@xxxxxxxxxxxxxxxxxxxx--1--null--
1--1056--Patterson--Mary--x4611--mpatterso@xxxxxxxxxxxxxxxxxxxx--1--1002--
2--1076--Firrelli--Jeff--x9273--jfirrelli@xxxxxxxxxxxxxxxxxxxx--1--1002--
3--1088--Patterson--William--x4871--wpatterson@xxxxxxxxxxxxxxxxxxxx--6--1056--
4--1102--Bondur--Gerard--x5408--gbondur@xxxxxxxxxxxxxxxxxxxx--4--1056--
5--1143--Bow--Anthony--x5428--abow@xxxxxxxxxxxxxxxxxxxx--1--1056--
6--1165--Jennings--Leslie--x3291--ljennings@xxxxxxxxxxxxxxxxxxxx--1--1143--
7--1166--Thompson--Leslie--x4065--lthompson@xxxxxxxxxxxxxxxxxxxx--1--1143--
8--1188--Firrelli--Julie--x2173--jfirrelli@xxxxxxxxxxxxxxxxxxxx--2--1143--
9--1216--Patterson--Steve--x4334--spatterson@xxxxxxxxxxxxxxxxxxxx--2--1143--
The following
is my code:
try{
//Open a report design
IReportRunnable design = reportEngine.openReportDesign(designFile);
//Create Data Preview task
IDataPreviewTask task = reportEngine.createDataPreviewTask(design);
//Execute Data Set, returning only 10 rows. Set binding map to null (We
have no data set parameters)
// IQueryResults actualResultSet = task.executeDataSet("parcelCount",
1, null);
IQueryResults actualResultSet = task.executeDataSet("Employes", 10,
null);
if ( actualResultSet != null )
{
//Iterate through results
Collection col = actualResultSet.getPreparedQuery( ).getReportQueryDefn(
).getRowExpressions( );
IBaseExpression[] expressions = (IBaseExpression[])col.toArray( new
IBaseExpression[col.size()]);
IResultIterator iter = actualResultSet.getResultIterator( );
int columnCount = expressions.length;
for ( int n = 0; n < columnCount; n++ )
{
System.out.print(
actualResultSet.getResultMetaData().getColumnName(n+1) + "--" );
}
System.out.println("");
while ( iter.next( ) )
{
for ( int n = 0 ; n < columnCount; n++ )
{
System.out.print(
iter.getString( expressions[n] )+ "--" );
}
System.out.println("");
}
actualResultSet.close( );
}
} catch ( BirtException ex ){
ex.printStackTrace(
);
}