I have built a report template at design time with its datamember set to a DE command that is structured with a grouping on a specified field. For reference, the command name is "cmBalPerBranch_Grouping".
At runtime, using different table but with the same structure with the orig table (field names,types and the no. of fields), I have setup a SQL statement (identical to the orig statement, but using the other table) and attempted to change the commandtext using:
This doesn't seem to work.
In another scenario, if I apply the same to a none grouped command, e.g. "cmBalPerBranch", changing the commandtext works fine.
What must I consider to change commandtext when the command in the DE has grouping?
TIA
At runtime, using different table but with the same structure with the orig table (field names,types and the no. of fields), I have setup a SQL statement (identical to the orig statement, but using the other table) and attempted to change the commandtext using:
Code:
de.Commands("cmBalPerBranch_Grouping").CommandText=strSQL
This doesn't seem to work.
In another scenario, if I apply the same to a none grouped command, e.g. "cmBalPerBranch", changing the commandtext works fine.
What must I consider to change commandtext when the command in the DE has grouping?
TIA