Tuesday, March 5, 2013

SSRS Setup Report

Setup an SSRS Report


  1. Right-click on the Reports Folder 
  2. Add, New Item…
    1. This ends up being easier than clicking Add New Report
    2. An Add New Item window will open and select Report as the template.  Insert a new Name.
      1. Try as much as possible to use a single naming convention to make your life and others' easier.
    3. Press Add
  3. This will automatically open the Report
    1. If it doesn't, double click on the report 
      1. i.e. ReportName.rdl
  4. Open the Report Data View
    1. Add Report Items to Report:
    2. Connect report item to a Dataset
      1. In the Report Data view, right-click on Datasets, Add Dataset…
      2. A Dataset Properties window will open similar to the Shared Dataset window. You can either utilize an existing shared dataset, or you can create your own query here. 
        1. NOTE: I suggest creating a shared dataset and then selecting it from a list here.
      3. Make sure to name your dataset.
        1. If you are using a shared dataset I HIGHLY recommend you name it exactly like the shared dataset to eliminate confusion.
      4. If done correctly Fields should auto-populate
      5. Set any Filters as required or desired
      6. Set any Parameters as required or desired
Add an Existing Report
  1. Right-click on Report Folder
    1. Add
      1. Existing Item
  2. Navigate to your existing project workspace
  3. Double click on your project work folder
  4. Sort by type make it easier to find
  5. Select 
    1. ReportName.rdl
    2. You can select multiple by holding shift or cntrl
  6. Add
  7. Double click on ReportName.rdl in Solution Explorer to open report
  8. Click the Preview and ensure that no errors occur
  9. If no errors occur your Report is functioning properly
See our next tutorial: SSRS Configure Deployment

17 comments:

  1. Great information you have share I really like it. Thanks for sharing check it once through MSBI Online Training Bangalore for more information on msbi courses.

    ReplyDelete
  2. I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I am looking forward to reading new articles. Keep up the good work.Thank’s for sharing such kind of content.
    SSRS Tutorial

    ReplyDelete
  3. This is a much needed information thank you for sharing and it's very helpful to know about this information. Thanks for sharing it MSBI Online Training

    ReplyDelete
  4. Windows 8.1 has new features and features, but Microsoft says it uses between 8 and 15 percent less disk space.
    best solar blog

    ReplyDelete
  5. Thank you for taking the time and sharing this information with us.
    msbi training in Hyderabad

    ReplyDelete
  6. The possibility of a sun oriented fueled light may lead critics to kill about counterfeit light being somewhat repetitive if the sun is thumping, however disregard them - this has a decent charge, is shoddy, light and spares space, and is naturally smart. https://www.techpally.com/office-makeover-without-budget/

    ReplyDelete
  7. In addition, it also offers the wireless access to the Internet and the Kindle Store that you can purchase and download more e-books directly to your device.text to audio online

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
  9. A devoted server for your web facilitating enables you to have a server exclusively committed to your site(s). What's more, a devoted server will permit you complete specialist to control and regulate your server. wmware dedicated server

    ReplyDelete
  10. There are three sorts of servers that facilitating organizations offer. These incorporate oversaw servers, semi-oversaw servers and unmanaged servers. Linux VPS

    ReplyDelete
  11. let's talk about Windows XP. Microsoft will withdraw technical and any kind of Microsoft support for Windows XP by the mid 2013. It would even stop rolling out patches, updates, and security definitions required for the smooth and safe functioning of Windows XP. reset windows 10 password

    ReplyDelete
  12. A big thank you for your blog.Really looking forward to read more. Great. microsoft toolkit 2.6.6 download free

    ReplyDelete
  13. thanks for your proclaim. Ive been thinking about writing a totally similar publicize a ways alongside than the closing couple of weeks, sick probably cash it immediate and adorable and associate to this in any other case if thats cool. thanks. Error 30126-27

    ReplyDelete
  14. thanks for imparting recent updates concerning the scenario, I see attention on to gain into more. Windows 10 Pro Keys Office 2019 Professional Plus CD Keys.

    ReplyDelete