The guide states: "It is not necessary to use Crystal Reports to run Advanced System Reports against the statistics database. Other reporting software programs may also be used ." What other reporting software programs can I use? Thanks, Lisa
The guide states:
"It is not necessary to use Crystal Reports to run Advanced System
Reports against the statistics database. Other reporting software programs may
also be used ."
What other reporting software programs can I use?
Thanks,
Lisa
Hi Lisa,
There is a free building block that does reporting as well, here is some information: http://connections.blackboard.com/posts/3b168675b4
Sincerely,
Eric
Lisa,
My understanding is that the Advanced System Reporting database is just a read-only database containing a subset of data from the system, so you should be able to use whatever reporting software you like that has the capability of doing SQL queries.
ASTRO, the reporting tool building block that Eric mentioned, isn't quite the same as ASR, but it''s also very good, especially if you don't want to try and set up all your own SQL queries.
Mike
How do we query the database with our software, ie what db name, table name, credentials, etc must be used?
Etienne,
Generally speaking, the database name will be either BB_BB60 for Learn systems that were upgraded from Bb 6/7/8, or BBLEARN for those that are fresh installs. Stats information is also copied in a stripped-down version to the BB_BB60_stats/BBLEARN_stats database. There are dozens (hundreds?) of tables, so the table names you use will depend on exactly what information you're looking for. The table definitions are available in the OpenDB database schema available on Behind the Blackboard. I gave you a link in the other thread that you just posted.
Did you install Blackboard locally, or are you hosted? If you installed it locally, all the database credentials will be what you put in when you installed the system.