Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX 7 Historical Reports Tool Question

Hi, I'm new to this tool and was wondering how I can see the report builds for the existing reports within the historical reports tool.  Is there a way to get into the pre-existing reports using Crystal Developer?  Any help and all help is appreciated.

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

UCCX 7 Historical Reports Tool Question

Hi

dbo is part of the name (well, it identifies the owner of the table, which is the main system user).

ado is the MS technology that Crystal uses (Active Data Objects methinks) to access the DB - so it's just how Crystal references it.

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
6 REPLIES
Super Bronze

Re: UCCX 7 Historical Reports Tool Question

Hi

Yes - the Crystal templates go into the program directory (c:\program files\cisco uccx historical reports\templates) when you install the program.

The SQL procedures are in the DB and easy to get at on V7 - if you connect to the server using RDP/VNC or whatever you can run SQL Enterprise Manager to view the procedures in the db_cra database.

Regards

Aaron

Please rate helpful posts..

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

UCCX 7 Historical Reports Tool Question

Thanks for your reply Aaron.

So I'm still learning my way aroud the Crystal dev tool since I only just got it last week. (I do all of my work in Oracle SQL Dev tool) Anyways, so my question is would I have to establish a new connection thru the ODBC or the OLE DB(ADO)?

New Member

UCCX 7 Historical Reports Tool Question

Aaron,

One more thing.  So when I get into the UCCX server to look at the data tables I notice that the table prefix (owner) is dbo. When I go into the reports design view and look at the database fields, their prefix is ado.  Is there another table set out there or are there interim tables being created as these reports are running?

Regards,

Super Bronze

UCCX 7 Historical Reports Tool Question

Hi

dbo is part of the name (well, it identifies the owner of the table, which is the main system user).

ado is the MS technology that Crystal uses (Active Data Objects methinks) to access the DB - so it's just how Crystal references it.

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

UCCX 7 Historical Reports Tool Question

Ok, but if you look at the field explorer under Database Fields, some of those are obviously pre-calculated fields which are then used on formulas for the report fields. So are the (Active Data Objects) stored long enough for the report to run or are they kept elsewhere?  I'm confused.

Super Bronze

UCCX 7 Historical Reports Tool Question

Hi

Each report basically runs a single Stored Procedure, which returns a single dataset.. ADO is just the technology used to do it. Crystal then builds the report from that, and the formulas can be based on the returned data or on various things built into Crystal (e.g. current time, various other variables).

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
551
Views
0
Helpful
6
Replies
CreatePlease login to create content