• Home
  • MSBI
  • How to Publish Report to a Report Server in SSRS

How to Publish Report to a Report Server in SSRS

  • (5.0)
  • | 5131 Ratings

Publish Report

 Publish Report

            Note:-   Before publishing ensure the following settings

a) solution explorer → project → properties →
Overwrite Data sources: False
Target Data source folder: Data Sources
Target Report Folder: MRG_REPORT
Target server URL:HTTP://RAWAN-8080/REPORTS  DWH
b) Configuration manager
Project contexts (Check the project configuration to build or Deploy
project                configuration                     platform                          Build                  Deploy

 solution explorer
Debug → publishing to test environment
Debug local → Previewing the report in the local
Release → Publishing to production server
c) The user who is publishing the report should belongs to publisher role

Learn how to use MSBI, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free MSBI Training Demo!

Developer responsibilities:

  1. Creating & working with standard, complex, Adhoc reports by using report server   project, report builder
  2. Parameterization, actions
  3. Report manipulations, various data regions, report items
  4. Expressions, calculations writing
  5. Data sources, datasets, connectivity
  6. Linked reports……etc.

Related Page: How To Deploy SSRS Report In Server

DBA (or) Super user (or)Managers Responsibilities:

  1. Publishing reports
  2. Subscriptions
  3. Snapshots, caches
  4. Folders, data sources creation
  5. Report definition pupation security….etx

 Managers Responsibilities

Complex creation:

1) Complex single report with queried, non queried, cascade multi value, drill through and drill down processes.
2) Create partial dashboard by using cross tab (or) Matrix reports
[various actions implemented]

Frequently Asked MSBI Interview Questions & Answers

SSIS in complex implementation (or)creation:

1) SCD manual implementation
i) class rooms

 SSIS in complex implementation

Related Page: SSIS Training

2) Multi files loading using forced load
3) Multiple worksheets loading through script task
4) Incremental loading
5) Optimized mapping using various performance tuning methods

 Optimized mapping

6) Error loading records splitting

 Records splitting

Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

List of Related Microsoft Certification Courses:

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Ravindra Savaram
About The Author

Ravindra Savaram is a Content Lead at His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter. Protection Status