queryA.getParameters().add(new JdbcParameter(2, DataType.INTEGER, maxParam));
report.getDataQueries().add(queryA);
/* create data table, set the data query */
DataTable table = new DataTable();
table.setCellPadding(1);
table.setDataQuery(queryA);
/* create table header rows */
GridRow tableHeader = new GridRow();
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Name")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Description")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("City")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("State")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Zip")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Price")));
tableHeader.addCell(new com.googlecode.g2re.html.GridCell(new RawHTML("Image")));
table.getHeaderRows().add(tableHeader);
/* create table body rows */
GridRow tableBody = new GridRow();
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col1, 0)));
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col2, 1)));
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col6, 2)));
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col7, 3)));
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement(col8, 4)));
tableBody.addCell(new com.googlecode.g2re.html.GridCell(new DataElement("\"<img src='\" + row[4].toString() + \"' />\"",6)));
/* add formatted price column */
DataElement priceCellElement = new DataElement(col4, 5);
priceCellElement.setNumberFormat("$###,###,###,##0.00");
tableBody.addCell(new com.googlecode.g2re.html.GridCell(priceCellElement));
/* add rows to table */
table.getBodyRows().add(tableBody);
/* add the table to the report */
report.getWebPage().addChildElement(table);
/* create and add a map */