Bruce Knox Database Programmer/Analyst
date
last updated 02/28/09
Using
SQLPass-Though Queries for Banner Reporting
Logon (Ours looks like the Banner Client Server
Logon).
Logon with separate DSN and
DBQ. (MS vs. Oracle)
My Favorite BannerAccess
Query.
Predefined Queries as Building
Blocks.
Predefining all those Queries will take Forever! Not really, you Let the
Server Help.
Let Oracle Create your Code from the Data
Dictionary.
Banner Reporting Requires All the Tools You Can Bring to the
Task. At some point you need the Oracle Guys!
This is mostly a series of screen print with a bit of narrative. This is how we set up BannerAccess and use it for Banner Reporting.
Disclaimer
Use this information and these scripts at your own risk. As a condition of using these
scripts and information from this site, you agree to hold harmless both the
University of Arkansas Cooperative Extension Service and Bruce Knox for any
problems that they may cause or other situations that may arise from their use,
and that neither the Extension Service nor I will be held liable for those
consequences. The scripts and
information are provided "as is" without warranty, implied or
otherwise. Limitation of liability will
be the amount paid to the University of Arkansas specifically for this
information. (It was free:)
Any
materials posted here from other authors, all logos, images, and
trademarks in this site are property of their respective owners.
visits