How to create Web report w/parameter

6 posts, 0 answers
  1. Will
    Will avatar
    45 posts
    Member since:
    Aug 2007

    Posted 16 Aug 2007 Link to this post

    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
  2. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 17 Aug 2007 Link to this post

    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
  3. DevCraft banner
  4. Will
    Will avatar
    45 posts
    Member since:
    Aug 2007

    Posted 19 Aug 2007 Link to this post

    Thanks for the help.  Everything is working now.
  5. David
    David avatar
    52 posts
    Member since:
    Feb 2008

    Posted 26 Mar 2008 Link to this post

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

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

    David
  6. David
    David avatar
    52 posts
    Member since:
    Feb 2008

    Posted 26 Mar 2008 Link to this post

    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;

  7. fnfzone
    fnfzone avatar
    2 posts
    Member since:
    Jun 2008

    Posted 16 Jun 2008 Link to this post

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

    www.fnfzone.com
Back to Top
DevCraft banner