need help to call datareport from command line and to pass parameters

[binilmb]

need help to call datareport from command line and to pass parameters. if it wont use dataenvironment it will be great

[binilmb]

i find using using dataenvironment is not that much user friendly

[Hack]

Moved to Reporting section.

[rush_shri]

there is nothing as such. it always works. In ur SQL query use @ and any parameter variable. E.G select * from dept where dept_code = @d

then click on the parameters tag and check for the correctness of ur parameter like its datatype etc.

then on any command_click write the code this way ----

'the value u r passing through text1.text
____________________________________

DataEnvironment1.Command1 text1.Text
DataReport1.Show
Set DataEnvironment1 = Nothing