I am trying to create a report with design time support for parameterized queries. Just the same as shown on this video. The problem is that I cannot use the wizzard, nor a SQLDataAdapter. I have a function that given the parameters, returns a dataTable.
I know I can use the following code:
Me.DataSource = dt
But then I lose the design time support as the IDE doesn't know which fields are declared on the dataTable.
Is there any way I can work with a DataAdapter over a middle tier so I can process the data before sending it to the report, declaring the fields I'm going to use so I don't lose the design time support?
Thank you
#ERROR# The expression contains object 'BankEmployeeName_A' that is not defined in the current context.
Why doesn't it find the field? I set a breakpoint in the ItemDataBinding event handler and the report's datasource property does in fact contain this field within the targeted datamember (datatable). Am I missing something?
I am only using the typed dataset for design-time--I will be returning the exact same result set from an Oracle stored procedure and I don't want to use typed datasets for this purpose. Theoretically, this scenario should work perfectly, and in fact, is the way in which we were binding all of our Crystal Reports report objects previously.
Any ideas on why this isn't working??
Thanks,
Larkin
TR.BS_TrackingDataSet1TableAdapters.
Subpoena_OrdersTableAdapter s = new TR.BS_TrackingDataSet1TableAdapters.Subpoena_OrdersTableAdapter();
TR.
BS_TrackingDataSet1.Subpoena_OrdersDataTable t = new TR.BS_TrackingDataSet1.Subpoena_OrdersDataTable();
t = s._Get(4);
TR.
Report3 r = new TR.Report3();
r.DataSource = t;
rvFTBReport.Report = r;
rvFTBReport.DataBind();