Print Page | Close Window

Query the CMC

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16854
Printed Date: 21 Apr 2025 at 10:16am


Topic: Query the CMC
Posted By: ongrpt
Subject: Query the CMC
Date Posted: 26 Jun 2012 at 1:33am
Hello everyone, I am trying to query CMC's user profile from a Crystal Report. Is it possible? Appreciate your help. Thanks in advance.

-------------
Thanks


Replies:
Posted By: hilfy
Date Posted: 26 Jun 2012 at 3:07am
You can't query the CMC directly.  Most of the data in the CMC is stored in a proprietary binary format that is only readable through using the query language in one of the SDK's (.NET or Java).
 
What I have done in the past is write a .NET application that queries the CMC and stores the data in an in-memory dataset and then calls a Crystal report that connects to that dataset to display the information.  You can find an example of this in the BOEUserAudit example app that's available on my website - http://www.dellstinnett.com/sample_code.html - www.dellstinnett.com/sample_code.html .
 
There are also some third-party tools available to retrieve this information.  http://www.kenhamady.com/bookmarks.html - www.kenhamady.com/bookmarks.html has a good list of these tools to get you started.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: ongrpt
Date Posted: 26 Jun 2012 at 4:43pm
Thanks Dell for clearing my doubts.

-------------
Thanks


Print Page | Close Window