Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Reporting issues and Peregrine SC

Reporting issues and Peregrine SC

Reporting issues and Peregrine SC

Just want to pick the collective brain here :)

Within our org here, we're running Service Center and reporting against it using Crystal. Been hitting the wall recently (I'm the reporting guy) as reporting reqs are getting far more complex, P4 being non-relational and subreports only getting me so far. I'm currenlty writing up a document for management to try and justify a merge or copy of the p4 db over to our Oracle db (or something to facillitate the reporting process?).

This would make reporting a breeze and would leverage our existing Cognos tools allowing us to get into OLAP/MOLAP, etc.

So folks, what do you see as greatest limitations to reporting in SC against the P4 db? Or what kinds of common probs do you guys find yourselves running into when reporting??

thx for any input ...


RE: Reporting issues and Peregrine SC

I wasn't able to get the sub reports working correctly (in CR v8.x) so we had to shadow the P4 DB to a SQL DB.
If you just "shadow" the p4 database to another server, the reporting DB server doesn't become a vital part of the ticket system.
I love Crystal Reports for complex reports, but we don't use it anymore, because most ppl don't understand how Crystal Reports works.
I'm using some smart sql views so that even ms office users are able to pull off some amazing reports.
With some Excel, a little VBA, SQL Views and Pivot "self service" becomes mutch easier.
In short: Trying to pull off the relational part in CR because P4 isn't able to do that, is a really bad idea.

If you need to argue, say that all reports that need sub-reports might not work correctly.

English isn't my native tongue, so sorry for my spelling :).

RE: Reporting issues and Peregrine SC

Definitely recommend pushing out at least tables you're going to be reporting on to an RDBMS.  We do that, then have processes that copy that data over to another DB instance to actually report on.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close