Free Essay

Pos 410 Week 4 Research

In:

Submitted By rdmckeown54
Words 462
Pages 2
Week 4 Individual Research
Ryan McKeown
POS 410
31 August 2015
William Ragin

Week 4 Individual Research
This week’s topic was to find an article about SQL reports. I chose this article because it went into great detail on the SSRS or the SQL Server Reporting System. The SQL Server Reporting System (SSRS) is a server-based reporting platform that allows us to create and manage a wide variety of different types of reports, and deliver them in a range of formats (Kellenberger, 2014). SQL Server databases are not the only databases that it can draw from. It can also pull data from other relational database systems such as Oracle or XML-based data sources such as SQL Server Analysis Services, Teradata, or Parallel Data Warehouse (Kellenberger, 2014). When using the SSRS, a user can present their finished reports directly from the Reporting Services website, called Report Manager, or users can view them directly within their web- or Windows-based applications. End users can run reports on demand or schedule them as subscriptions (Kellenberger, 2014). The article goes on to describe building SSRS reports, customizing SSRS reports, SSRS visual controls, and deploying SSRS reports.
SSRS has been around for over a decade, with its first appearance being as an add-on for SQL Server 2000 and then becoming a full part of SQL Server 2005 (Kellenberger, 2014). Since its integration into SQL Server 2005, Microsoft has made a number of improvements and added many new features. It had a big overhaul in 2008 and acquired a bunch of new features with 2008 R2 including:

* The tablix data region which allows us to convert a report area from a table to a matrix and back again * Enhanced chart, and new gauge, data regions (thanks to the Dundas acquisition) * Complete redesign of the Report Designer including a new Grouping Pane * Formatting of text elements, not just at the textbox level * Performance enhancements * 2008 R2: KPIs, maps, sparklines, new functions, published Report Parts, and more
All SSRS deployments must be linked with an SQL server instance of some kind. There are two different types of databases on the instance, the ReportServer and the ReportServerTempdb. Below is an excellent diagram on how it all works.

This was a great article because it helped me learn a lot about the SSRS, how it works, and what it is capable of doing. This will be an article I will keep linked to reference back to as it was very informative and I am sure I will be dealing with the SSRS in the future when running reports.

Reference
Kellenberger, K. (2014). SQL Server Reporting Services Basics: Building SSRS Reports. Retrieved from https://www.simple-talk.com/sql/reporting-services/sql-server-reporting-services-basics-building-ssrs-reports/

Similar Documents

Free Essay

Working Capital

...Business Plans Handbook Business Plans A COMPILATION OF BUSINESS PLANS DEVELOPED BY INDIVIDUALS NORTH THROUGHOUT AMERICA Handbook VOLUME 16 Lynn M. Pearce, Project Editor Business Plans Handbook, Volume 16 Project Editor: Lynn M. Pearce Product Manager: Jenai Drouillard Product Design: Jennifer Wahi Composition and Electronic Prepress: Evi Seoud Manufacturing: Rita Wimberley Editorial: Erin Braun ª 2010 Gale, Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored, or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher. This publication is a creative work fully protected by all applicable copyright laws, as well as by misappropriation, trade secret, unfair competition, and other applicable laws. The authors and editors of this work have added value to the underlying factual material herein through one or more of the following: unique and original selection, coordination, expression, arrangement, and classification of the information. For product information and technology assistance, contact us at Gale Customer Support, 1-800-877-4253. For permission to use material...

Words: 121839 - Pages: 488

Free Essay

Feeling Bad on Facebook

...(2011) Research Article FEELING BAD ON FACEBOOK: DEPRESSION DISCLOSURES BY COLLEGE STUDENTS ON A SOCIAL NETWORKING SITE Megan A. Moreno, M.D. M.S.Ed. M.P.H.,1Ã Lauren A. Jelenchick, B.S.,1 Katie G. Egan,1 Elizabeth Cox, M.D. Ph.D.,1 Henry Young, Ph.D.,2 Kerry E. Gannon, B.S.,1 and Tara Becker, Ph.D.1 Background: Depression is common and frequently undiagnosed among college students. Social networking sites are popular among college students and can include displayed depression references. The purpose of this study was to evaluate college students’ Facebook disclosures that met DSM criteria for a depression symptom or a major depressive episode (MDE). Methods: We selected public Facebook profiles from sophomore and junior undergraduates and evaluated personally written text: ‘‘status updates.’’ We applied DSM criteria to 1-year status updates from each profile to determine prevalence of displayed depression symptoms and MDE criteria. Negative binomial regression analysis was used to model the association between depression disclosures and demographics or Facebook use characteristics. Results: Two hundred profiles were evaluated, and profile owners were 43.5% female with a mean age of 20 years. Overall, 25% of profiles displayed depressive symptoms and 2.5% met criteria for MDE. Profile owners were more likely to reference depression, if they averaged at least one online response from their friends to a status update disclosing depressive symptoms (exp(B) 5 2.1, Po.001), or...

Words: 6600 - Pages: 27

Premium Essay

Sex Discrimination

...SEX DISCRIMINATION IN EMPLOYMENT Fifth Edition Maryland Commission for Women 311 W. Saratoga St. Ste 272 Baltimore, MD 21201 410-767-3049 The Women’s Law Center, Inc. Copyright: 1982, 1986, 1995, 2001, 2008 The Women’s Law Center, Inc. Sex Discrimination in Employment Fifth Edition Revisions Provided By: Jill Wrigley, Women’s Law Center of Maryland With Editorial Assistance From: L. Tracy Brown, Women’s Law Center of Maryland Laurence Ruth, Women’s Law Center of Maryland Jessica Morgan, Women’s Law Center of Maryland Funding for production and distribution of the fifth edition was provided by Open Society Institute, Baltimore Community Foundation, The Marjorie Cook Family Foundation and Brown, Goldstein & Levy, LLP. Fourth Edition Revisions Provided By: Kevin O’Connor of Ober, Kaler Grimes & Shriver Melvina C. Ford, Women’s Law Center of Maryland With Editorial Assistance From: Denise Davis, Women’s Law Center of Maryland Funding for production and distribution of the fourth edition was provided by the Maryland Legal Assistance Network and Maryland Legal Services Corporation. Third Edition Written By: Rieyn Delony Sally L. Swann Louise Dean Williams With Editorial Assistance From: Robyn Mazur Kathleen Fantom Shemer Funding for production and distribution of the third edition was provided by the Baltimore Bar Foundation and the Marjorie Cook Foundation. Second Edition Written By: Kathleen Fantom Shemer With Editorial Assistance From: Jane Murphy Carol Polowy Emily Rody...

Words: 14532 - Pages: 59

Premium Essay

Choosing the Channels of Communication

...IS FO TR R IB L U IM TI IT O E N D O N LY D Choosing the Channels of Communication A Review of Media Resources for 11 Countries in the Western Pacific Region This document is part of a continuing project of the Tobacco Free-Initiative and the Health Promotion Unit, World Health Organization, Western Pacific Regional Office. Tobacco-Free Initiative & Health Promotion Unit World Health Organization Regional Office for the Western Pacific P Box 2932, 1000 Manila, Philippines .O. Tel: (632) 528-8001 Fax: (632) 521 1036 http://www.wpro.who.int Choosing the Channels of Communication Choosing the Channels of Communication A Review of Media Resources for 11 Countries in the Western Pacific Region Introduction .................................................................................................................................. 1 Key elements in choosing the channels of communication ................................................ 2 Cambodia Summary of media resources ...................................................................................................... 8 Media directory ............................................................................................................................ 10 China Summary of media resources ........................................................................................................ 18 Media directory .........................................................................................

Words: 21258 - Pages: 86

Premium Essay

Lakeside Case Book

...permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. To obtain permission(s) to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, One Lake Street, Upper Saddle River, New Jersey 07458, or you may fax your request to 201-236-3290. Many of the designations by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed in initial caps or all caps. 10 9 8 7 6 5 4 3 2 1 ISBN 10: 0-13-013256725-3 ISBN 13: 978-0-13-256725-1 The Lakeside Company:...

Words: 48183 - Pages: 193

Free Essay

The Physiologic Effects of the Crude Concoction from Euphorbia Hirta (Tawa-Tawa) Using Staphylococcus Aureus for Anti-Bacterial Tests and Animal Inoculation Assay for Toxicity 1

...in the middle. In the axils appear numerous involucres, purplish or greenish, dense, axillary, short stalk clusters or crowded cymes, about 1 mm long. The capsules are broadly ovoid, hairy, three-angled, about 1.5 cm. The small green flowers constitute the inflourescence characteristics of the euphorbias. The stem and the leaves produce white or milky juice when cut (Lind and Tallantire, 1971;Anonymous 2005). In some parts of Africa, extract of the plant are used in the treatment of asthma and respiratory tract inflammations (Kokwaro, 1993). The plant contains relatively abundant white latex. The white latex is capable of causing dermatitis (Oliver, 1960). The plant shows antibiotic activity (Sofowora, 1993). Upon reading some medical research studies on Euphorbia hirta...

Words: 8195 - Pages: 33

Premium Essay

Zara International

...Chapter 9 health and disability insurance |CHAPTER OVERVIEW | Planning a health insurance program needs careful study because the protection should be shaped to the needs of the individual or the family. However, the task is simplified for many families because a foundation for their coverage is already provided by group health insurance at work. We begin the chapter by recognizing the importance of health insurance in financial planning and define health insurance. Then we analyze the benefits and limitations of the various types of health insurance coverage. Private and governmental sources of health insurance and health care are presented next, with a complete coverage of health maintenance organizations (HMOs). Then, we discuss the importance of disability insurance in financial planning and identify its resources. Finally, we explore why the costs of health insurance and health care have been increasing and what is being done to curtail them. |LEARNING OBJECTIVES |CHAPTER SUMMARY | After studying this chapter, students will be able to: |Obj. 1 |Recognize the importance of health |Health insurance is protection that provides payments of benefits for a covered sickness | | |insurance in financial planning. |or injury. Health insurance should be a part of your overall insurance program to | |...

Words: 8147 - Pages: 33

Premium Essay

S.a Curriculum

...ACCOUNTING SCHOOL-BASED ASSESSMENT EXEMPLARS – CAPS GRADE 12 LEARNER GUIDE ACCOUNTING SCHOOL-BASED ASSESSMENT EXEMPLARS – CAPS GRADE 12 LEARNER GUIDE CONTENTS Introduction................................................................................................................... Task A First Term Report: Companies This task is suitable for Grade 12 learners from 2014 (CAPS). Question paper ............................................................................................. Answer book ................................................................................................. 1 2 5 Task B First Term Test: Financial statements of a company This task includes shares of no par value and repurchase of shares. This task is suitable for Grade 12 learners from 2014 (CAPS). Question paper ............................................................................................. Answer book ................................................................................................. 10 14 Task C Second Term Project: Published financial statements of Famous Brands Ltd This task is suitable for Grade 12 learners from 2014 (CAPS). Combined question paper and answer book ................................................ Source material ............................................................................................ 18 25 Task D Third Term Case Study: Cash budget and debtors This task is suitable for Grade 12 learners...

Words: 6044 - Pages: 25

Premium Essay

Accounting

...ACCOUNTING SCHOOL-BASED ASSESSMENT EXEMPLARS – CAPS GRADE 12 LEARNER GUIDE ACCOUNTING SCHOOL-BASED ASSESSMENT EXEMPLARS – CAPS GRADE 12 LEARNER GUIDE CONTENTS Introduction.................................................................................................................... Task A 1 First Term Report: Companies This task is suitable for Grade 12 learners from 2014 (CAPS). Question paper.............................................................................................. Answer book.................................................................................................. Task B 2 5 First Term Test: Financial statements of a company This task includes shares of no par value and repurchase of shares. This task is suitable for Grade 12 learners from 2014 (CAPS). Question paper.............................................................................................. Answer book.................................................................................................. Task C 10 14 Second Term Project: Published financial statements of Famous Brands Ltd This task is suitable for Grade 12 learners from 2014 (CAPS). Combined question paper and answer book................................................. Source material............................................................................................. Task D 18 25 Third Term Case Study: Cash budget and debtors This task...

Words: 6044 - Pages: 25

Premium Essay

5 Theroies

...Electronically. You may submit electronic comments on this regulation to http://www.regulations.gov. Follow the ‘‘Submit a comment’’ instructions. 2. By regular mail. You may mail written comments to the following address only: Centers for Medicare & Medicaid Services, Department of Health and Human Services, Attention: CMS–3239– P, P.O. Box 8010, Baltimore, MD 21244– 8010. Please allow sufficient time for mailed comments to be received before the close of the comment period. 3. By express or overnight mail. You may send written comments to the following address only: Centers for Medicare & Medicaid Services, Department of Health and Human Services, Attention: CMS–3239–P, Mail Stop C4–26–05, 7500 Security Boulevard, Baltimore, MD 21244–1850. 4. By hand or courier. If you prefer, you may deliver (by hand or courier) your written comments before the close of the comment period to either of the following addresses: a. For delivery in Washington, DC— Centers for Medicare & Medicaid Services, Department of Health and Human Services, Room 445–G, Hubert H. Humphrey Building, 200 Independence Avenue, SW., Washington, DC 20201. (Because access to the interior of the Hubert H. Humphrey Building is not readily available to persons without Federal government identification, commenters are encouraged to leave their comments in the CMS drop slots located in the main lobby of the building. A stamp-in clock is available for persons wishing to retain a proof of filing by stamping in and retaining...

Words: 34753 - Pages: 140

Premium Essay

Holcim Bd

...Analysis of Consumer Behavior And Marketing Strategies. 1. Introduction Background of the Study: The research report titled as “Holcim cement Bangladesh Ltd.” is originated from the partial requirement of the course Consumer Behavior, MkT-410. It is actually a student– practical-learning experience. Where the students learn the application of quantitative, qualitative evaluation, facts and observation and report writing in Consumer Behavior point of view as well. It took nearly one week to gather relevant information and prepare the report and has been submitted on 28t h November 2007. Objective of the Study: This report seeks overall information on the questionnaire survey, which was carried in several retail shops, outlets. It is an attempt to draw the true picture of the Holcim cement in Bangladesh and also to know the Consumer Behavior towards Holcim cement. Basically there are two objectives behind doing this report and they are as follows: The first and the foremost objective are to fulfill the partial requirement of the course Consumer Behavior (MKT 410). The second objective is to measure consumer behavior towards Holcim cement. Scope: In our survey we like to focus on consumer perception and Holcim’s performance that are up to the mark or not. We have to go several outlets, retail shops to find out consumer belief about Holcim cement. The report focuses on the consumer’s belief, perception, lifestyle etc. and currently what...

Words: 7216 - Pages: 29

Free Essay

2009-Report to Congress of the Us-China E and S Review Commission

...use of the U.S.-China Economic and Security Review Commission Available via the World Wide Web: http://www.uscc.gov dkrause on GSDDPC29 with K1 VerDate Nov 24 2008 08:23 Nov 10, 2009 Jkt 052771 PO 00000 Frm 00003 Fmt 6012 Sfmt 6602 M:\USCC\2009\52771.XXX APPS06 PsN: 52771 M:\USCC\USChina.eps Report Documentation Page Form Approved OMB No. 0704-0188 Public reporting burden for the collection of information is estimated to average 1 hour per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Washington Headquarters Services, Directorate for Information Operations and Reports, 1215 Jefferson Davis Highway, Suite 1204, Arlington VA 22202-4302. Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to a penalty for failing to comply with a collection of information if it does not display a currently valid OMB control number. 1. REPORT DATE 3. DATES COVERED 2. REPORT TYPE 01 NOV 2009 4. TITLE AND SUBTITLE 00-00-2009 to 00-00-2009 5a. CONTRACT NUMBER 5b. GRANT NUMBER 5c. PROGRAM ELEMENT NUMBER 2009 Report to Congress of the U.S-China Economic and Security Review Commission 6. AUTHOR(S) ...

Words: 185166 - Pages: 741

Free Essay

Psychosocial Variables and Self-Rated Health in Young Adult Obese Women

...Applied Nursing Research 27 (2014) 67–71 Contents lists available at ScienceDirect Applied Nursing Research journal homepage: www.elsevier.com/locate/apnr Psychosocial variables and self-rated health in young adult obese women Mary Jane Smith, PhD, RN a,⁎, Laurie Theeke, PhD, FNP-BC a, 1, Stacey Culp, PhD a, 2, Karen Clark, MD b, 3, Susan Pinto, MSN, RN a, 4 a b WVU School of Nursing, PO Box 9600, Health Sciences Center South, Morgantown, WV 26506-9600 School of Medicine, Student Health Services, PO Box 9247, Health Sciences Center South, Morgantown, WV 26506-9247 a r t i c l e i n f o Article history: Received 10 October 2013 Revised 4 November 2013 Accepted 4 November 2013 Keywords: Obesity Self-rated health Stress Loneliness Self-esteem a b s t r a c t Aim: The aim of this study is to describe relationships among self-rated health, stress, sleep quality, loneliness, and self-esteem, in obese young adult women. Background: Obesity has steadily increased among young adults and is a major predictor of self-rated health. Methods: A sample of 68 obese (BMI 30 or higher, mean 35), young (18–34 years, mean 22) adult women were recruited from a health center. Survey data were gathered and analyzed using descriptive and bivariate procedures to assess relationships and group differences. Results: Scores reflected stress, loneliness, poor sleep quality, and poor self-esteem. There were positive correlations among stress, loneliness, and sleep...

Words: 5610 - Pages: 23

Premium Essay

Discovery Recovery Plan for Kudler

...Executive Summary Kudler Fine Foods was first established in 1998 with an objective strongly focused on providing its clients the opportunity to buy fresh ingredients used to make delicious cuisines. Since then, Kathy Kudler (founder) has opened two more locations to satisfy her target market’s thirst for her product(s). Although this small business expansion has increased the customer base and or revenue pursued by its owner, the induction of additional services provided has also slightly altered the projected operations plan and or business plan. Kudler Fine Food’s mission states that it will “provide its customers with the finest selected foodstuffs, wines, and related needs in an unparalleled consumer environment“(Apollo Group, 2008). In order for Kudler to meet the needs of the consumer at all times, administration has proposed a review of the companies operations and or communication plan(s) be reviewed for contingency of any unforeseen threats to daily operations. Scope To assist the company in their daily functions, Kudler Fine Foods stores information used to determine market conditions, customer demographics, individual store sales, employee demographics, payroll, administrative functions, and other human resource related information. A post review of Kudler’s fixed operations reveals the company is currently unprepared for any and all potential threats that may halt daily operations for an over-extended period. Potential threats that Kudler may face are: breach and...

Words: 5884 - Pages: 24

Premium Essay

Pain

...Pain Assessment and Management G u i d e l i n e f o r Marlene Walden, PhD RNC NNP CCNS Sharyn Gibbins, PhD RN NNP P r a c t i c e , 2 n d E d i t i o n Pain Assessment and Management Guideline for Practice, 2nd Edition This guideline is an outline of the pain assessment and management practices that currently are accepted and documented by experts in the field of neonatal care. In addition, it summarizes and recommends pain assessment and management practices based on the best evidence for the nursing care of infants. This guideline does not preclude the use of manufacturers’ recommendations or other acceptable methods of assessing and managing pain in infants. The use of other practices known to improve the quality of neonatal care is encouraged and not restricted by this document. The National Association of Neonatal Nurses (NANN) developed this guideline in response to members’ requests. Broad in scope, it can provide a foundation for specific nursing protocols, policies, and procedures developed by individual institutions. Authors Marlene Walden, PhD RNC NNP CCNS Sharyn Gibbins, PhD RN NNP Reviewers Daniel Batton, MD, American Academy of Pediatrics Sandra Sundquist Beauman, MSN RNC Jim Couto, MA, American Academy of Pediatrics Mary Ann Gibbons, BSN RN Melinda Porter, RNC CNS NNP Ann Stark, MD FAAP, Chair of AAP Committee on Fetus and Newborn Carol Wallman, RNC NNP MS, NANN/AWHONN Liaison to AAP Committee on Fetus and...

Words: 13773 - Pages: 56