how to use "create table" statement in ireport ? or how to create many tables in database using ireport ?

[sagarnikam123]

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

select distinct PEMID,PEMName from PEMs

 

select DoctorID from PodDoctorMap where PodID in ($P{PEM_ID}) and StartDate >= $P{StartDate} and EndDate <= $P{EndDate}