Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to create user reporting dashboard in ASP.Net ?

Answered How to create user reporting dashboard in ASP.Net ?

  • Friday, March 01, 2013 5:06 PM
     
     
    Sign In to Vote
    0

    Hi.

    I am working on data warehouse in SSIS and SSAS. I want to build a user end reporting dashboard in which a user can select different ranges of date, specific customer, all customers, year range (i.e. user can filter records) from lists, combo box, check boxes etc etc. My advisor said that I should use ASP.NET reporting and I google it with many keywords but couldn't found any useful tutorial. Please suggest me a link, an ebook or tutorial which fulfills my requirements of ad hoc reporting.

    It is appreciable if you please suggest me any simple, free and easy to use reporting tool which supports sql server.

    I want to provide an interface like that.

    Thanks

    Hamid


    • Edited by Aladin92 Saturday, March 02, 2013 5:31 AM
    •  
     

All Replies

  • Saturday, March 02, 2013 4:35 PM
     
     
    Sign In to Vote
    0

    ASP.NET Report Viewer control - here is a tutorial

    http://weblogs.asp.net/rajbk/archive/2010/05/09/creating-an-asp-net-report-using-visual-studio-2010-part-1.aspx

    Thanks! Josh Ash

     
  • Saturday, March 02, 2013 10:19 PM
     
     
    Sign In to Vote
    0

    Thanks Josh Ashwood. I have already checked this link but not found required details that I want. Please if you know any other free reporting tool that supports sql server instead of ASP.Net please tell me.

    thanks in advance

     
  • Tuesday, March 05, 2013 2:58 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Hamid,

    To display a report in a custom ASP .NET Application, you need to use a ReportViewer control which embeds report processing and viewing capabilities directly into custom application. Based on your scenario, you can create custom parameter in the ASP .NET Web application, and then pass the parameters to the ReportViewer control using the SetParameters Method.

    References:

    Hope this helps.

    Regards,

    Mike Yin
    TechNet Community Support