Crystal Reports in MultiMedia

[Maker1]

We have CCMM/CCMS/CCMA/CCT 6.0. Is it possible to import Custom Crystal Reports into the CCMA reporting?

 

[Utreg]

Yes no problem, I've created and imported a lot of them.

Since there are not many email reports I think it necessary to build them yourself.

To test a report a connection to the cache database has to be setup in Crystal reports.

 

[Maker1]

Where do you put them? I can connect to the base table just fine, but when I try to import a Crystal Report into CCMA for CCMM, I don't have the correct type of tables to import with. There is not an interval, daily, weekly, monthly, etc. view. How do you get around that?

 

[Utreg]

I import the reports via RCW (standard import via Reports, Import does not show the intervals).

Herewith the PC setup and CCMA report import steps;

* PC with Crystal Reports setup:

Step A: Install Caché.
Install the following Caché ODBC driver:
ftp://ftp.intersystems.com/pub/cache/odbc/windows-ia32/ODBC-5.0.12.5504.0-win.zip

Step B: configure DSEDIT
Go to START, RUN and type in ‘dsedit’.
Click OK on the Select ‘Directory Service window’.
Choose ‘Server Object’, ‘Add’ and give it a name like "CCMM_CR_Reports".
Now under attributes click on Server Address and add the IP address of the CCMM server and port 5000; f.e.: 192.168.12.123, 5000

Step C: Configure ODBC
Now go to "Data Sources (ODBC)" under Control Panel, Administrative Tools and click on the System DSN tab.
Click ADD and scroll down to select "Intersystems ODBC". Under the Data source name you can pick any name you want, f.e. "CCMM_Reports_ODBC"
In the server name field you must specify the name you setup in the 'dsedit' step above (i.e. CCMM_CR_Reports)

Copy Crystal Reports file to;

\\nortelccma\d$\Program Files\Nortel Networks\WClient\Apps\Reporting\Historical\rpt\RCW\Your_Reports

* CCMA report import;

1) Go to ‘Report Creation Wizard’ and click the ‘Import button’.
2) Fill in ‘Report title’ and ‘Browse’ to the Crystal report file and click ‘Open’. Choose ‘Report Mode’: ‘Private’ and select CCMS server.
3) The ‘Data Range’ is most of the time set automatically, if not add details (f.e. Table: ContactsbyContacts Timestamp: .ArrivalTime)
4) Click on Import to import the report.