Web Parameterized Query

[David]

This is the code I have now, and I'm trying to tweak it to make it work.

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();

[David]

I worked this out.   You have to had in a generic DataSet created on the fly.
Then add your table which captures the TableAdapter data based on your criteria.  rvFTBReport is the variable I used for the Report Viewer.

Hope this helps, David

TR.BS_TrackingDataSet1TableAdapters.

BS_TrackingDataSet1TableAdapter s = new TR.BS_TrackingDataSet1TableAdapters.BS_TrackingDataSet1TableAdapter();

TR.

BS_TrackingDataSet1.BS_TrackingDataSet1TableDataTable t = new TR.BS_TrackingDataSet1.BS_TrackingDataSet1TableDataTable();

int TrackingID = Convert.ToInt32(lblAutoNum.Text);

t = s.GetData(TrackingID);

DataSet ds = new DataSet();

ds.Tables.Add(t);

TR.

Report1 r = new TR.Report1();

r.Report.DataSource = ds;

rvFTBReport.Report = r;