i have a project connected with sql server 2000...
i want to generate the some reports, for that user should itself enter the dates or codes for reports..
i have created a data environment, called the tables.
now in general tab, i have selected SQL Statement to filter my data from database.
now where i am comparing the field with parameter
SELECT * from customer where customercode=text1.text when i am clicking on apply button it errors...
"to retrieve field information for this command, the command must be executed.you may need to specify input parameters values in input parameter tab before the command is executed.execution may add to or modify data in database. execute command?"
if i am clickin "yes", nothing happens, and pressing No, tit cancels it.
where as the parameter tab is disable, where from i should input the parameter values.