I have a series of reports that depend on a variety of differing SQL queries. They vary by joins and several other criteria, so simple parameter substitution is not an option. I need to set the SQL Select Command at the time the report is initiated on the ASPX page that contains the Report Viewer.
In another thread, I have found out how to access certain report variables using the following technique:
Dim report As Telerik.Reporting.Report = DirectCast(Me.ReportViewer1.Report, Telerik.Reporting.Report)
Dim txt As Telerik.Reporting.TextBox = TryCast(report.Items.Find("titleTextBox", True)(0), Telerik.Reporting.TextBox)
txt.Value = "
Updated Title Text"
How would I do the equivalent for the Datasource name, connection string or select command?
I need a clue as to the syntax and form, as the above "find" for a text control doesn't seem to apply.