I am taking input using "Input Control",using that i want to generate/create many table in mysql database....& ultimately final table(which can be directly used to show output)
but when i am puting text "create table",inside query designer ,it show error about "can not issue data manipulation statement with execute query()"
so i go by differnt way......as...giving two queries in one table.
but when i am giving more than one query(by editing .jrxml file as below ),it again gives error
edited source code---->