Creating Crystal Reports OUTSIDE of RE - looking for database schema

Kristin Tito · June 2016

Hi -

We are about to begin creating our own Crystal Reports outside of RE. Has anyone created or located a database schema to help you match a field you see on the screen to it's specific field name and table on the backend?

Thanks!

Chester Bammel · June 2016

I have had to do this once. I have not
seen any sort of metadata list, though I’m not saying one does not
exist.

What I did, was created a query in RE. I
then exported that query to SQL and reviewed the SQL.
Although they used a different SQL than we did, it was enough to
identify the correct tables and fields that I needed to
use.

Hope this maybe helps a little bit.

Chester

Chester Bammel

Business
Analyst

IT Enterprise
Services

Division of
Information Technology

Sam
Houston State University

Box
2397 Huntsville, TX 77341

Office - (936) 294-2351

Kristin Tito · June 2016

I wasn't able to export a query into a SQL format BUT I realized that I could take a canned report and export it into Crystal. Thank you!

Joshua Bekerman bCLO bCRE · June 2016

Check to see if you have access to the "Read-Only Database Assistance Query Tool" in RE, under Plug-ins. This includes the schema on the Tables tab. If you don't I don't think you'll be able to access the SQL tables to begin with.

There's also a RE7schema.chm help file somewhere like C:\\Program Files (x86)\\Blackbaud\\The Raisers Edge 7\\Help.

Also I don't think it always (if ever) specifically mentions the name of the field that shows in RE so you'll need to figure that out. You'll also need to follow the yellow brick road and connect the tables and fields together. When I needed to pull phone numbers I think it took five or six tables just to get the number I needed.

Kristin Tito · June 2016

Shazaam! I found the RE7Schema right where you said it would be on my C drive.

The Crystal Report export that I tried before was a bit of a useless Trojan Horse as the underlying tables and fields were still hidden, so the schema will hopefully be a big help. Thank you!

I have access to Plug Ins, but I don't see that specific Plug In on the list.

Creating Crystal Reports OUTSIDE of RE - looking for database schema

Comments

Categories