Publish Report
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
Debug → publishing to test environment
Debug local → Previewing the report in the local
Release → Publishing to the production server
c) The user who is publishing the report should belong to the publisher role
developer responsibilities:
- Creating & working with standard, complex, Adhoc reports by using report server project, report builder
- Parameterization, actions
- Report manipulations, various data regions, report items
- Expressions, calculations writing
- Data sources, datasets, connectivity
- Linked reports……etc.
Related Page: How To Deploy SSRS Report In Server
DBA (or) Superuser (or)Managers Responsibilities:
- Publishing reports
- Subscriptions
- Snapshots, caches
- Folders, data sources creation
- Report definition pupation security….etx
Subscribe to our youtube channel to get new updates..!
Complex creation:
1) Complex single report with queried, non queried, cascade multi-value, drill through and drill down processes.
2) Create the partial dashboard by using the cross tab (or) Matrix reports
[various actions implemented]
SSIS in complex implementation (or)creation:
1) SCD manual implementation
i) classrooms
(or)
ii)
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
6) Error loading records splitting
Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download Now!
List of Related Microsoft Certification Courses:
SSIS | Power BI |
SSAS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |