Mindmajix

How to Publish Report to a Report Server in SSRS

Publish Report

Screenshot_142

Note:-   Before publishing ensure the following settings

a) solution explorer → project → properties →

Deployment

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

Screenshot_143

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

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.

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

Screenshot_144

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]

SSIS in complex implementation (or)creation:

1) SCD manual implementation

i) class rooms

(or)

ii)

Screenshot_145

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

Screenshot_146

6) Error loading records splitting

Screenshot_147

Enroll for Live Instructor Led Online MSBI Training


0 Responses on How to Publish Report to a Report Server in SSRS"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.