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.







18 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. 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
  6. I simply want to tell you that I’m all new to blogs and truly liked you’re blog site. Very likely I’m likely to bookmark your site .You surely come with remarkable articles. Cheers for sharing your website page.

    MSBI Training in Chennai

    Software Testing Training in Chennai

    ReplyDelete
  7. Thanks for such a great article here. I was searching for something like this for quite a long time and at last I’ve found it on your blog. It was definitely interesting for me to read  about their market situation nowadays.
    Selenium training in Chennai

    Selenium training in Bangalore

    ReplyDelete
  8. Thanks For Sharing the Information The Information Shared Is very valuable Please Keep Updating us Time Just Went On Reading The article Python Online training Hadoop Online training Data Science Online training AWS Online training

    ReplyDelete
  9. It was Very amazing post and thanks for creating this.I always like and such a super contents of these post.Excellent and very cool idea and great
    content of different kinds of the valuable informations you gave.
    Java training in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Online Training

    ReplyDelete