Help in report generation

[monil]

Hi,

We are new to VB Report generation.

What we have at our end is a form that shall have some input fields. Say Age, gender, Active from and Active to (dates)

Now, based on the input from the user, I would like to build a dynamic query and set it to the "CommandText" property of Command in the Data Environment .

This query should be used to generate the report.

What ever be the query generated, the output fields on the report shall always remain the same. As in our case, we would be displaying the ID, Name, Age

We do not want to set the parameters from the text box in the "CommandText" property of Command in the Data Environment.

Please guide us.

Thank you.

[kulitag]

like if you put the id no, you will generate a report with the id, or if it's name then it will produce a report?

[monil]

Oh no. I am sorry, but, thats not what I am expecting.

Well, let me try to explain it again.

We would like to set the "CommandTEXT" property of the Command in the Data Environment through VB code.

Thats it. IS it possible?

Any sample code would be apppreciated.

Thank you.

[kulitag]

i hope it will help

[monil]

Thank you. It helped :-)

[kulitag]

walang problema!