Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Training Question of the Week for December 7, 2007

Updated on September 10, 2021

How can I use Crystal Reports to report on data stored in a PRPC database? I was told that I can "expose" PRPC data in a database, but I'm not too clear on what that means.

Answer by Bob Lloyd
PRPC stores work objects in a standard relational database table. By default, the value of all properties are stored in a BLOB (Binary Large Object) column. If an outside tool wants to access some of these properties in the database, a system administrator can expose specific properties by creating columns in the work table that match property names. PRPC will then replicate those properties from the BLOB into the newly created columns.

Crystal Reports just needs to access the table (typically using a JDBC connection) to be able to read the data, as it does with any other database table.

Specifics on exposing database columns are discussed in the System Administration course. You can also refer to the PDN article How to expose a work object property as a column and update data views for more information.

Answered by Bob Lloyd

See Index: Training Questions of the Week for more questions and answers.

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us