To Print The SalesId’s In the same row with multiple coulumn:

Make a programmable section in the design and drag the SalesID from SalesTable. Now override fetch method. And write the following code.

/*Remember to Make the property of the Field Salesid in report design as “AutoDeclaration = YES”*/

.public boolean fetch()
{
boolean ret;
int l;
;

l =0;

SalesTable_SalesId.height(2.5, Units::char);

while select * from SalesTable where SalesTable.SalesId != 'SalesID '
{
l++;
if (l mod 2 == 0)
{
SalesTable_SalesId.leftMargin(0,units::mm);
SalesTable_SalesId.topMargin(0,Units::mm);

}
else
{

SalesTable_SalesId.leftMargin(50.0,units::mm);
SalesTable_SalesId.topMargin(-7.0,Units::mm);

}
element.send(SalesTable);
element.executeControlColumnHeadings(2);
element.execute(1);
}



return true;





This will print the result in following format

SB001 SB002
SB003 SB004
SB005 SB006
SB007 SB008
SB009 SB010
SB011 SB012
SB013 SB014
SB015 SB016
SB017 SB018
SB019 SB020


}