Basics

Report & Charts panel

Summarize Data

Summarize

Attorney/Firm BM Maiden Name City/State of Adoption Country County/Province of Birth Date Created Date Modified Gender I am In Search of Last Modified By Race Record ID# Record Owner Registration # To Register your Search or Contact Registry Administrator # of Records    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab Select a field... Attorney/Firm BM Maiden Name City/State of Adoption Country County/Province of Birth Date Created Date Modified Gender I am In Search of Last Modified By Race Record ID# Record Owner Registration # To Register your Search or Contact Registry Administrator # of Records    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count Median    Display As:  Normal Value Percent of column total Percent of crosstab total Running total down column Running total across crosstab

Hide totals

Hide totals row

Grouping and crosstabs

Sorting

Sort	Default order    Sort on the default column Custom order
	Sort by     from low to high from high to low then by     from low to high from high to low then by     from low to high from high to low

Columns to display (for left side of the timeline)

Report formulas (None added)

Summary formulas (None added)

A summary formula lets you add a column to this summary with numbers, such as averages, that would otherwise require a separate table to "roll up".

Step 1: Define summary variables Summary formulas use variables you define here, not ordinary fields. The variables are recognized only in these formulas.

Select a field... Attorney/Firm BM Maiden Name City/State of Adoption Country County/Province of Birth Date Created Date Modified Gender I am In Search of Last Modified By Race Record ID# Record Owner Registration # To Register your Search or Contact Registry Administrator Number of Records    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:  Select a field... Attorney/Firm BM Maiden Name City/State of Adoption Country County/Province of Birth Date Created Date Modified Gender I am In Search of Last Modified By Race Record ID# Record Owner Registration # To Register your Search or Contact Registry Administrator Number of Records    Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:     Summarize By:  Totals Averages Maximums Minimums Std. Deviation Distinct Count    Name:

Step 2: Write summary formulas Use your variables as you would normally use fields. For example, an Income formula might be "[Revenue (tot)] - [Expense (tot)]". Add a summary formula

Step 3: Next you can... Go to Summarize to show your summary formulas in columns. Go to Sorting to sort your rows by your formulas.

Filters

Initial	Defines the results when the report is first displayed
	Show all Record records    Filter Record records Adoption_Database cconluvsjd@gmail.com janetgagner@aol.com lamerritt67@hotmail.com rainbowmoon@shaw.ca Adoption_Database cconluvsjd@gmail.com j0ysea@comcast.net janetgagner@aol.com rarylee@yahoo.com Show Record records where of these conditions are true Show Record records where and Select a field... <Some field> Adoptee Name at Birth Adoptees DOB Adoption Agency Attorney/Firm Birthfather BM Maiden Name BM Name at Adoptees Birth City & State of Birth City/State of Adoption Comments Country County/Province of Birth Date Created Date Modified DNA Companies I have tested with DOB Range Gender Hospital I am In Search of Last Modified By Race Record ID# Record Owner Registration # Status foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy and foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy and foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy and foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy and foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy and foo foo the value the value in the field <ask the user> checked the value in the field <ask the user> the previous the current the next the date --------------- day(s) in the past yesterday today tomorrow day(s) in the future --------------- the date in the field <ask the user> day week month quarter fiscal quarter year fiscal year day(s) week(s) month(s) quarter(s) fiscal quarter(s) year(s) fiscal year(s) Ddd mm/dd/yyyy - Ddd mm/dd/yyyy
Dynamic	Defines how your users can refine and search the report when viewing it
	Use the dynamic filters defined in default report settings (Change)    Custom    None All dynamic filters are restricted for your role Available Select up to 5 dynamic filters Maximum number of filters selected Reset to default (Dynamic filters won't be turned on in this report) Allow users to search using the Quick Search field.

Options

Color-Coding

Drilldown Report