Data Reports

1.i have a dataenviroment with the connection set.
2.1 command added with the required query.. This is the parent command.
3. I Add a child command to the parent command.Set the query and the relation with the parent.

eg.
data enviroment.
connection
command1.
command2

this is the heirarchy..

Now @ run time
i want to change the query for the command 1 and want the relevant data from command2.
Thus display records on my report.

How can i achieve this..

hi,

Welcome to the Forums !! try this.,

VB Code:

Set DataReport1.DataSource = DataEnvironment1
If DataEnvironment1.rsCommand1.State Then DataEnvironment1.rsCommand1.Close
DataEnvironment1.Commands!Command1.CommandText = "Your SQL QUERY HERE"
DataEnvironment1.Command1          ' to execute the query ..
 
DataReport1.Show
DataReport1.Refresh

But first you have to set the datareport in the design mode. and change only the query in runtime.

This might help also.