As with Joda (prev posted topic)

I'm also having difficulty using or changing a commandtext value (or SQL String)of a grouped command object under connection1 within the DataEvironment(DE) during runtime for a given dataReport...

Does anyone have any example code that dynamically changes the SQL for a given dataEnvironment?

If the answer remains to use the ADO Recordset then how can I group items in the select so that I may perform page breaks on group items?

I have been successful in listing in the detail area of a datareport but have not had luck with getting the group header defined in a datareport for a given recordset...


Thanks for any ideas...
Stuck,
Marc