Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,153,141 members, 7,818,432 topics. Date: Sunday, 05 May 2024 at 03:34 PM

How To Access Report Manager In SSRS 2012 - Educational Services - Nairaland

Nairaland Forum / Nairaland / General / Education / Educational Services / How To Access Report Manager In SSRS 2012 (199 Views)

How To Access Study Loans (2) (3) (4)

(1) (Reply)

How To Access Report Manager In SSRS 2012 by Lianamelissa: 10:30am On Feb 14, 2019
Working with Report Manager
1) It is a client tool to work with client reports and manger reports.
2) It does various operations such as

Subscription
Creating and manipulating folders.
Creating snap shots, caches, maintaining histories
Creating and working with linked reports etc.
Navigation:
HTTP://SERVERNAME:IP/REPORTS

SHOW DETAILS:
It displays various report manager items. They are creation date, modified date, created user and modified user names etc…

NEW FOLDER:
It creates a new folder in the report Manager
Click New Folder → Name → Ok
a) NEW Data source → Data Source credentials should be stored permanently in the Report server in the below situation

creating caches, snapshots, history
while creating subscriptions
Creating A Report From Excel Sheet
Create a Driver for excel sheet
Start → settings → control panel → Administrative tools → databases → rt Click → add → ODBC Ms Excel setup → Data source name → DS Excel → Select work book → desktop → folder → ok → ok → ok

→ View → report data → New Data source → General → Name → DST EXCEL → Embedded connection → type (odbc) → EDIT → click option string connection
→ Build → Machine data source driver name: DST_EXCEL → Ok → Ok → Ok
→ New data set → Name → dst Excel → click query builder → query designer → OK → OK

→ VIEW MENU → report data → tool box Properties → table → drag on to the layout
→ While working with site settings etc. click new data source

Name : DS-DB-MSBI
Description:
Data source type: Microsoft SQL Server
Connection string: Data source =.; initial catalog = DBMSB

Connect using:
? Credentials stored securely in the report server.
User name: Rawan administrator
Password:
Use the windows authentication
Click → apply
Upload file:- It uploads files to report manager.
Upload file menu → Click ok click → Click ok file to upload [ ] [Browse]
→ Click ok

Working with individual properties of a report:
View → It displays the report
Properties →
a) General → It displays

Modified date:
Modified by:
Created Date:
Created by:
Size:
Properties
Name : Party-report
Description:

(1) (Reply)

Philippines Is The Most Cheapest Country To Study Any Course Of Choice, / The Internet And Kids In This Lockdown Akwu Sunday Victor / Learn A Skill Today, Learn Video Editing And Motion Graphics

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.