Friday, March 01, 2013 5:06 PM
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.
- Edited by Aladin92 Saturday, March 02, 2013 5:31 AM
Saturday, March 02, 2013 4:35 PM
ASP.NET Report Viewer control - here is a tutorial
Thanks! Josh Ash
Saturday, March 02, 2013 10:19 PM
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 AMModerator
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.
- How to pass parameters to Reporting Services from .Net applications
- ServerReport.SetParameters Method
Hope this helps.
TechNet Community Support
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Thursday, March 14, 2013 2:18 AM