Sub Report - Assign SQL Query at runtime

[V6]

Hi all,

In my application, i assigned the main report's sqlquery property value at run time. In the same way, i want to assign the subreport sqlquery at time time. I didn't know that property for doing that one. If any one of them, let me know the way of achieving that one i am so much thankful to them.

Thanks in advance.

Thanks,
Venkatesan.

 

[V6]

Hi All,

It would be possible by using the following property settings

crystalReport1.SubreportToChange = "sub.rpt"
CrystalReport1.SQLQuery = SQL
CrystalReport1.SubreportToChange = ""
CrystalReport1.Action = 1

It's works well.

Thanks,
Venkatesan