Pages

Tuesday, 24 July 2012

Create SSRS report using Excel Data Source Step by Step

By creating a report using Excel as a Data Source we will follow the following steps ...



Right click on Shared Data Source folder and choose Add New Data Source. A new popup screen will open. Give the Data Source Name and Choose ODBC from the dropdown box.


Then Click on Edit button. A new screen will open. From the new screen i.e. Connection Properties go to the Use user or system data source name and from the drop down choose Excel Files .




Then Choose the Use Connection String and click on Build button. A new pop up screen will open . Click on New button.






Then click on Next button



Choose the Microsoft Excel Driver and click on Next button and then click on Finish button.



Then click on Select Workbook button and choose the file and click on OK button.





Click on OK.




Test the connection and press OK.







Click on OK.
Click on Reports folder and choose add new items and choose Report. Map your Data Source and click OK.



Right click on Dataset Folder and Write the query for the table. (I have used a very simple query .For ex.)



This is Your Report from Excel data source.







7 comments:

  1. Hi Hussain

    Its a Nice Post.
    Now when I am uploading this RDL file and creating a new ODBC DataSource in Report Manager I am getting error

    (ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified)

    Can you please guide me

    Thanks - Jayanta

    ReplyDelete
  2. I have given Login information when creating ODBC connection. Now used Credentials stored securely in the report server option in Manager and click on Test Connection. I get the error msg that time.



    ReplyDelete
  3. Exceptional procedure. Thank you so much. Huge help!!

    ReplyDelete
  4. wow that's great happy to read this article and this is very effective and helpful for every one thanks for shareing with us and keep posting these type of content daily i will come and read your blog

    ReplyDelete
  5. RPO Services arranges it’s Technical Expertise to scrap data and CVs from multiple Job Boards networking sites. Data sourcing services is one of the demanding services in service delivery domain.
    visit: www.rposervies.com

    ReplyDelete
  6. Advantages of analytics
    Data Mining
    Profiling
    Regression
    Purchases
    Monte Carlo Simulation
    “Statistically Significant”
    Predicting Customer Behavior
    Churn/Attrition.
    thanks for sharing this article the above article useful article.

    ReplyDelete