Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create new parameter field for stored procedure

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.




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";


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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question