This page contains example Crystal Reports that
may help programs get started on designing their own custom reports
for use with Biotics. These reports are designed to work with
a generic read-only oracle user, biotics_report, that all Biotics
programs can create in their database. By designing standard reports,
it will facilitate sharing them among the network. If your program
has a sample crystal report that you would like to include on
this web site, please submit to Product_Support@natureserve.org
with the words [web site update] at the start of the subject line.
For more information about the report standards for designing
and using reports, please refer to the instructions document below.
Unless otherwise indicated, example reports were developed by
NatureServe staff. Reports submitted by a member program will
be indicated and you may contact that person directly if you have
questions about using the report. Contact information for Biotics
users can be found on our Current
Users page.
|
|
Links
|
| General
instructions for using the reports |
|
Example Reports in PDF format for Heritage Programs
without Biotics 4.
submitted by Shelley Cooke, ID and Bob Gottfried, IL
|
PDF_Examples.zip
EOR Example |
| Crystal Reports 8.5 ODBC driver for Oracle 8i |
Click
to get driver from Crystal Reports Website |
| SQL Script to grant biotics_report select privileges
on all tables and views. |
report_grant.sql |
|
Subject Area
|
Crystal Reports Version 8.5
|
| Determine Working List IDs |
Working_List_ID
- All
Working
List ID - by list type
|
| Element for SWG Planning -- includes required
view, SWG_EL_VW |
SWG_Elements
- All |
| Element Global Ranking |
Central
EGR dump report - by working list name
EGR
dump report - by Element ID
EGR dump report - by working list ID
EGR
dump report - by working list name |
| Element Management |
Element Management Group Dump Report |
| Element Group |
Element Group Dump Report |
| Element Occurrence |
|
Element Occurrence for 2-Sided Printing
(new records begin on odd # pages)
|
EO
dump report - by EO ID Full Duplex |
Element Occurrence
submitted by Bob Gottfried, IL
|
Customized
EO dump report - by working list name
EORs
grouped by County - with special instructions
|
Element Occurrence
submited by Shelley Cooke, ID |
EO
logbook for animals - select by EST ID
EO
logbook for plants - select by EST ID |
| Element Occurrence Ranking Specs |
EO
Rank Specs dump - by Element Global ID
EO
Rank Specs dump - by Element Group ID
EO
Rank Specs dump - by Working List ID
EO
Rank Specs dump - by Working List Name |
| Element Occurrence Specs |
EO
Specs dump - by Element Global ID
EO
Specs dump - by Working List ID
|
Element Ranking - Subnational
Submitted by Rachel Novak, NY |
ESR
dump report - by working list name |
| Element Tracking - Subnational |
EST
dump report - by working list name |
Element Tracking - Subnational
Submitted by Rachel Novak, NY
|
EST
dump report - by working list name |
Element Tracking - Subnational
submitted by Shelley Cooke, ID |
Species
that are NOT tracked - listed by elcode
Species
that are NOT tracked - listed by sname
Species
that ARE tracked - listed by elcode
Species
that ARE tracked - listed by sname
Species
listed by county |
Reference (Source Abstract)
submitted by Shelley Cooke, ID
|
Reference
report - by working list name
Reference
short report - by working list name
|
| Managed Area |
MA
dump report - by working list ID
MA dump
report - by working list name
MA dump report
- by MA ID |
| Scientific Name |
Scientific
Name - by Scientific Name |
| Site |
Site
dump report - by working list ID
Site
dump report - by working list name
Site dump
report - by Site ID |
Site
submitted by Bob Gottfried, IL
|
Site
dump report - by working list name |
Source Feature
submitted by Shelley Cooke, ID
|
Eo_source
subreport - sort by SF Descriptor
Eo_source
subreport - sort by SF_ID |
|
Subject Area
|
Crystal Reports Version 9
***THESE WILL NOT WORK WITH CR VERSION 8.5***
|
Plant CAS
submitted by Shauna Dunham, KY
|
Plant
flowering times
Plants
by physiographic region |
EOR
submitted by Shauna Dunham, KY |
core_eo_fields.sql
***Necessary for KY's EO Report
EO
long report from EO_ID |
Element Tracking - Subnational
submitted by Shauna Dunham, KY |
Element
report for scorecard
Endangered,
threatened, special concern, historical biota
Extirpated
biota |
Scorecard/Site
submitted by Shauna Dunham, KY |
best_eo_rank_script.sql
***Necessary for certain KY Site Reports
ksnpc_site_megastie_vw.sql
***Necessary for certain KY Site Reports
Scorecard
(biodivsig)
Scorecard
(macro/mega)
Scorecard
(standard site) |
EGR
submitted by Fagan Johnson, CO |
EGR
by Element Working List
EGR
by EO Working List
Tricky!!!
EGR
by Element_Global_ID |
EOR
submitted by Fagan Johnson, CO |
EOR
for Land Managers by EO_ID
EOR
for Public by EO_ID
EOR
for Land Managers by Working List Name
EOR
for Public by Working List Name |
ESR
submitted by Fagan Johnson, CO |
ESR
by EO Working List Name
ESR
by Element Working List Name
ESR
by Element_Subnational_ID |
PCAG
submitted by Fagan Johnson, CO |
PCAG
by Element Working List Name
PCAG
by EO Working List Name
PCAG
by Element_Global_ID |
PCAS
submitted by Fagan Johnson, CO |
PCAS
by Element Working List Name
PCAS
by EO Working List Name
PCAS
by Element_Subnational_ID |
Site
submitted by Fagan Johnson, CO |
Site
for Public by Conservation_Site_ID
Site
for Public by Working List Name
Site
for Land Managers by Conservation_Site_ID
Site
for Land Managers by Working List Name |
Element Subnational Ranking Review
submitted by Rebecca Boehm, MI
|
Threatened
and Endangered by Working List Name |
