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

7 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