I would like to be able to drive the Data Report Designer programmatically.
I can do simple tasks:
If you setup TextBoxes on the DataReport1 and set their DataField property to the name of the field in the rs recordset and then:
Dim MyReport as New DataReport1
Set MyReport.DataSource = rs
works and shows the report as expected.
However I cannot get it to work with report sections. I guess this is beacuse the DataMember is not being setup.
However I do not want to setup loads of Commands in a Data Environment Designer.
Has anyone got any examples of code which DIRECTLY (not DataEnvironmentDesigner driven) uses DataReporter using code.
The reason I need this is I build recordsets on the fly using dynamic SQL and although I could create and drop commands I actually have the disconnected recordsets available. All I want to do is use these already available recordsets as a feed to DataReport. I do not want to do work already done twice and the recordsets are already available.