Accessing Biotics 5 via Third-Party Applications and using them

Accessing Biotics via third-party applications, such as: Tora, Toad, SQLDeveloper, Crystal Reports, ArcGIS.

ArcGIS: OID field renumbered when exporting
Problem: Follow the instructions to Connect to Biotics 5 Database within ArcGIS.  When exporting the query layer to a feature class or geodatabase tabl...
Wed, 22 Jan, 2014 at 1:25 PM
ArcMap/Catalog requires 32-bit Oracle installation
ArcMap/Catalog requires the 32-bit Oracle installation even on a 64-bit machine.  Failing to install the 32-bit version of Oracle will result in the followi...
Tue, 5 Apr, 2022 at 7:52 AM
TORA versus SQL Developer and how to work in both
Following are comparisons between various third-party tools which allow you to manipulate the Biotics database.  TORA & Toad are equivalent, so only...
Fri, 24 Mar, 2017 at 8:28 AM
MS Word macros for use with Biotics
Here is a set of Word macros (tools) for Biotics users and instructions for using and installing them. The macros are: Comma_Delim_Numbers & Comm...
Mon, 17 Nov, 2014 at 3:25 PM
View, Print, Export, and Schedule Crystal Reports
The following third-party solution was shared with NatureServe by one of the member programs.  NatureServe does not support this software, we are merely ...
Wed, 5 Nov, 2014 at 8:58 AM
Resolving problems when exporting to Word or Rich Text from Crystal Reports
PROBLEM: Exporting to Word or Rich Text from Crystal Reports (CR) results in a document with formatting that makes it difficult to edit and use as a ...
Wed, 19 Nov, 2014 at 12:20 PM
Allowing for multiple-value selections in Crystal Reports
This card was written by Kristin Snow.   You may want the users of your report to be able to choose multiple values for the parameter that selects records i...
Thu, 1 Jun, 2017 at 2:46 PM
Start Record on Odd Pages for Duplex Printing in Crystal Reports
There are times when you want all groups to start printing on an odd page number.  Usually this comes up when you are printing on both the front and back ...
Fri, 8 May, 2015 at 3:12 PM
Why does my Crystal Report have unexpected records?
If a Crystal Report selects records based on working_list_name, the report may contain extra/unexpected records. This is because in Biotics, two differen...
Wed, 5 Nov, 2014 at 9:07 AM
How do I add a consistent, blank row after a section of a Crystal Report?
If you vertically stretch a details section in a Crystal Report, it does not necessarily leave a blank row in your report. The easiest way to add a blank ...
Wed, 5 Nov, 2014 at 9:11 AM