oztan

i have very serious problem...
i create a project and one of my sub program required to print a report function.
so i design a program for this purpose..this sub program contain a DataGrid(DataGrid1), Text (Text1), and several buttons (cmdPrint, cmdExecute, cmdClear, cmdClose)..
the program is work like that..
user have to key-in the SQL command in the Text1 then click on the the execute button then the datagrid will display all the data from the SQL command....is working at here...
then i have to make the report rigth ??
here is the problem....(i used datareport as my report generater..)
when user key-in "select * from Table1" ....it work fine(select all columns)...
but if user key - in something like....."select Name, age from Table1"
then a problem is come up....an error message prompt up...
"datafield "address" not found...
(the address is one of the coulmns but this case i did't to select it...bcoz i don't want to print....)
so do u guys understand what is my purpose ?? my program want to allow users to select the column they need to print only....and not to print all.....
is there any solution ?? can give me any source code relevent to this program??
urgent....please.......................

hardrain

Select that fields but just dont show it to the user.