need help to call datareport from command line and to pass parameters
need help to call datareport from command line and to pass parameters. if it wont use dataenvironment it will be great :wave:
Re: need help to call datareport from command line and to pass parameters
i find using using dataenvironment is not that much user friendly
Re: need help to call datareport from command line and to pass parameters
Moved to Reporting section.
Re: need help to call datareport from command line and to pass parameters
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