How to proceed in SSRS report.. RRS feed

  • Question

  • i have 3 excel files:newclients,served,terminated.
    Most of the columns are same in 3 files.
    i need to design ssrs report take the reference from excel files.
    the conditions are going to be changed as per date fields.
    is it possible to merge 3excel files to 1 srrs report?
    what is the best way to proceed?
    Tuesday, June 14, 2011 6:00 PM


All replies

  • Please go through the following blog post and let us know if you have any specific questions or if you run into any issues.

    Using Excel as a Reporting Services data source - http://weblogs.sqlteam.com/joew/archive/2008/08/22/60695.aspx

    Hope this helps!

    Saturday, June 18, 2011 6:28 PM
  • Hi,

    I would also consider using Data Flow(s) within an SSIS package to ETL your Excel files into SQL Server table(s) and use your SQL Server table(s) as a data source for your SSRS reports. My gut feeling is that if this is a one off exercise then go withn Shahfaisal's solution. If these Excel spreadsheets into SSRS is going to form part of a repeatable business process I vote for the SSIS route.

    Kind Regards,


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI, PGD SoftDev (Open), MBCS, MCC http://uk.linkedin.com/in/kieranpatrickwood
    Saturday, June 18, 2011 10:10 PM
  • I would use SSIS package to merge the files into SQL Server table and then just create a dataset points to that table in SSRS
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, June 19, 2011 5:34 AM