how to change datareport sgl in code

I know that with this code I can change the SQL statement behind command, but I don't know where to place it.

DataEnvironment.Commands("Companies").CommandText = "SELECT Name, State FROM Companies WHERE State =' " & Text1.Text & " ' "

I have tried many procedures, for instance: DataEnvironment_Initialize(), DataReport_Initialize() etc. but any of them don't work.

I have tested my datareport and it works just fine so all the settings are right.

So if any of you know how to do this then please inform me, I would appreciated it a lot. Thanks.


:confused: :confused:

I think you should put that in the form, where you call to the report to show
like

report.commands blablabla

report.show

just a line before you show it

sorry i mean dataenviroment.commands blablabla

I think this is the right place because im doingsomething like

dataenviroment.commandofthereport parameter, parameter
report.show

the parameters afeccts directly to the sql expression

hope i explain fine and this helps