How to create Web report w/parameter

[Will]

Hi -
I want to create a report that requires a single parameter (to become part of the SQL WHERE clause) that will run on my web page or web user control.

I followed the steps on the online video for creating a report for a win form, but the same code does not work for a web form/app.  I want to have a page load and pass in the parameter to the report.

Is there a better example or can someone explain to me?

Thanks
 - will

[Chavdar]

Hi Will,

I'm attaching a sample Web Site solution which implements the same functionality as in the WinForms demo but for a web application. Take a look at it and let me know if all is good.

 
Sincerely yours,
Chavdar
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Will]

Thanks for the help.  Everything is working now.

[David]

Is there a way you could provide a C# solution.  

I'm trying to use a DataAdapter, DataTable, DataSet, etc..

David

[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;

[fnfzone]

is there anyway tp page break in report based on some value dynamically?

www.fnfzone.com