Create new parameter field for stored procedure

[Former Member]

Hi All,

i am retrieving the infoobject from BO server using jsp and i am viewing the rpt using CrystalReportViewer,

But whenever i am viewing the rpt i want to pass stored procedure input parameters dynamically so that viewer can prompt for parameter fields for stored procedure.

how can i add the new parameter fields to prompt for stored procedure.

please give me any idea, if possible with code.

Regards,

Hanuman

[Former Member · Accepted solution]

ReportClientDocument boReportClientDocument = boReportAppFactory.openDocument((IInfoObject)boInfoObjects.get(0), 0, java.util.Locale.ENGLISH);

CommandTable boOldCommandTable = (CommandTable) boReportClientDocument.getDatabase().getTables().getTable(0);

CommandTable boNewCommandTable;

boNewCommandTable = (CommandTable) boOldCommandTable.clone(true);

String sql = "select * from \"Customer\" WHERE \"Customer ID\" < 30";

boNewCommandTable.setCommandText(sql);

boReportClientDocument.getDatabaseController().setTableLocation(boOldCommandTable, boNewCommandTable);