Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,153,141 members, 7,818,432 topics. Date: Sunday, 05 May 2024 at 03:34 PM |
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 |