Monday, November 15, 2010

IReport dynamic table sql

In IReport tool, you can dynamically generate SQL by changing table name.

1) Create parameter for table name. Ex :- $P{tableName}
2) Change IReport SQL as following.

      SELECT * FROM $P!{tableName}

No comments:

Post a Comment