Vista views report building
Download
1 / 22

Vista Views Report Building - PowerPoint PPT Presentation


  • 117 Views
  • Uploaded on

PowerCampus. Version 8.3.2. Vista Views Report Building. 102. Recap of 101 – What is Vista views?. A tool used to create custom views with Vista Reports Users can select pre-defined tables and other custom views

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Vista Views Report Building' - ayla


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Vista views report building

PowerCampus

Version 8.3.2

Vista Views Report Building

102


Recap of 101 what is vista views
Recap of 101 – What is Vista views?

  • A tool used to create custom views with Vista Reports

  • Users can select pre-defined tables and other custom views

  • Views and tables can be secured by profile, user name/operator id, or formal name(this view is not for you)

  • Users can add columns, create joins, develop where clauses, group by, sort, and customize data, etc


Recap of 101 what is vista views continued
Recap of 101 – What is Vista views Continued

  • Custom views, pre-defined tables, security settings, and other important features (joins, where clauses, group by, sort, compute, syntax preview)

Preview shows results from the SQL syntax tab

Data Tables – Holds data on students, applicants, inquires, etc

Code Tables – Hold the various user-defined code tables for your institution

System Views – Hold any system-defined views which are currently on the system

User Views – Hold any views that you have created

System Tables – Holds the various system tables which are currently on the system

  • Compute allows the user to:

  • Customize reports for requestor’s use, personal use, or meeting other reporting needs by

  • Group By is a feature used to group data. Examples include:

  • Displaying the number of classes a student is taking

  • Displaying the number of terms a student has been enrolled in

  • Where clauses filter data. Some examples include:

  • Defining a specific year, term, and/or session

  • Defining a specific program, degree, and/or curriculum

  • Separating enrolled from withdrawn students

  • Eliminating non-credited students from results

Rows can be unique by clicking Distinct

Syntax tab allows the user to edit the SQL syntax directly (System Administrator Role)

  • Manipulate strings

  • Perform mathematical computations

  • Working with null values


Vista views 102 joins make all the difference
Vista Views 102 - Joins Make All the Difference

  • Joins are needed when selecting more than one table

  • Tables need to relate to each other in order for syntax to run successfully

  • Joins help to relate tables to one another

  • Three types of joins can be created

    • Equal Join

    • Right Outer Join

    • Left Outer Join


Vista views 102 joins make all the difference cont
Vista Views 102 - Joins Make All the Difference Cont.

Illustration – Equal Join

A&B

All of the matching records from Table A and Table B

Equal Join = A&B intersected


Vista views 102 joins make all the difference cont1
Vista Views 102 - Joins Make All the Difference Cont.

Example – Equal Join

Table A = People

Table B = Telecommunications


Vista views 102 joins make all the difference cont2
Vista Views 102 - Joins Make All the Difference Cont.

Illustration – Right Outer Join

A&B

All of the records from Table B and all the records from Table A that match Table B

Right Join = Table B + (A&B) intersected


Vista views 102 joins make all the difference cont3
Vista Views 102 - Joins Make All the Difference Cont.

Example – Right Outer Join

Table A = People

Table B = Telecommunications


Vista views 102 joins make all the difference cont4
Vista Views 102 - Joins Make All the Difference Cont.

Illustration – Left Outer Join

All of the records from Table A and all the records from Table B that match Table A

A&B

Left Join = Table A + (A&B) intersected


Vista views 102 joins make all the difference cont5
Vista Views 102 - Joins Make All the Difference Cont.

Example – Left Outer Join

Table A = People

Table B = Telecommunications

Where clause is the same as the example for the Equal Join and Right Outer Join


Vista views 102 joins make all the difference cont6
Vista Views 102 - Joins Make All the Difference Cont.

Overall Results

  • Equal join results include students from the People Table that have alternative email addresses

  • Right join results have all the students from the Telecommunications that have alternative email addresses and those students in common with both tables (Telecommunications and People)

  • Left join results include all students from the People table with or without an alternative email address


Vista views 102 trouble joining tables quick access slide
Vista Views 102 – TROUBLE JOINING TABLES? Quick access Slide

Phone, Address, Demographics and IPEDS Ethnicity




Vista views 102 changes in join tab
Vista Views 102 – Changes In Join Tab Slide Cont.

  • Join tab changes start with PowerCampus version 8.4 and higher

  • Joins are between Tables as opposed to Tables and Columns

  • Left Outer, Right Outer, and Equal Joins can be set up between Tables

    • Columns will have to be set up for Left and Right Outer Joins

    • Equal Joins are Cross Joins instead of Inner Joins (Cross Joins act like an Inner Joins with a Where Clause)

  • Filters have been added for Outer Join Tables. “And” is given for all filters

  • Syntax for Vista Views are now written in new SQL. Square brackets are used to differentiate between Tables, Columns, and custom column names


Vista views 102 changes in join tab cont
Vista Views 102 – Slide Cont. Changes In Join Tab Cont.



Vista views 102 modifications
Vista Views 102 – Modifications Slide Cont.

Case When Examples – Undergraduate Population


Vista views 102 modifications cont
Vista Views 102 – Modifications Cont. Slide Cont.

Left, Right, and Substring Examples


Vista views 102 useful web resources for modifications
Vista Views 102 – Slide Cont. Useful WEB Resources for modifications

Websites:

Stackover flow - http://stackoverflow.com/

Sql Server Helper - http://www.sql-server-helper.com/default.aspx

Microsoft Developer Network - http://msdn.microsoft.com/library

W3schools - http://www.w3schools.com/sql/default.asp

Google – http://www.google.com (your problem sql or sql your problem)


Vista views 102 references
Vista Views 102 - References Slide Cont.

  • PowerCampus Vista User Guide Release 8.1, June 2012

  • PowerCampus Release Guide Release 8.4, November 2013


Vista views 102 discussion
Vista Views 102 - Discussion Slide Cont.

Questions/Comments

Contact Information

Name: Anthony Williams

Title: Dir. Institutional Research

College: Metropolitan College of New York

Email: awilliams@mcny.edu

Office #: 212-343-1234 ext 2830