[birt-report-engine-dev] the last column's values do not show up, the fi

["Chaohua Wang" <chaohua.wang@xxxxxxxxxxxxxxx>]

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--REPOR
TSTO--JOBTITLE--

0--1002--Murphy--Diane--x5800--dmurphy@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

1--1056--Patterson--Mary--x4611--mpatterso@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
--

2--1076--Firrelli--Jeff--x9273--jfirrelli@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
-

3--1088--Patterson--William--x4871--wpatterson@xxxxxxxxxxxxxxxxxxxxxxxxx
056-

4--1102--Bondur--Gerard--x5408--gbondur@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

5--1143--Bow--Anthony--x5428--abow@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

6--1165--Jennings--Leslie--x3291--ljennings@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
3--

7--1166--Thompson--Leslie--x4065--lthompson@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
3--

8--1188--Firrelli--Julie--x2173--jfirrelli@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
--

9--1216--Patterson--Steve--x4334--spatterson@xxxxxxxxxxxxxxxxxxxxxxxxxxx
43--
 

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( );
               }