Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How are reports stored in CE10???

Status
Not open for further replies.

eo

MIS
Apr 3, 2003
809
Hi

I need to understand how reports are stored within the CE10 environment, and have some knowledge on the subject, but only bits and pieces, and can therefore not see the whole picture...

In a normal and most basic CR10 environment reports are stored in a flat file by their names, for example
C:/File/report1.rpt
C:/File/report2.rpt
C:/File/report3.rpt
Q:/AnotherFile/report4.rpt

How does this translate to the CE10 environment. Are the actual objects stored within the input and output file respositories, or is this simply where instances are kept? In these locations, objects are stored with long untranslatable object Id's. How does the system then relate this to the object names, as we see them on the screen. Are design templates therefore kept somewhere else, and if so where...

...or do understand the whole concept of report storage within CE totally wrong.

Please help.



EO
Hertfordshire, England
 
Input FRS stores the actual report copy, txt files, DOC files, PDF files etc.
Output FRS stores instances related to .rpt file in Input FRS.
CE uses a compex algorithm to transtale the name and path in FRS. These files names and paths must not be altered.

Log to CMC, go to the properties tab of any report object and you will see the full path where file is stored for input FRS. Same is true when u click at "Success" on any instance. Which means CE saves that path as part of object and knows where to look at the files.

About templates, I am not sure, but I think they are not stored on the CE side. When template is ready, it gets applied to report object to give standard look and feel and then that report object gets published to CE.
 
So am I therefore correct in assuming, I will not be able to do much useful analysis on reports stored in the CE env, as they are not stored by report name anywhere, but CE rather uses algorithms to "allocate" the given report/ object name to that object, and should rather investigate third party tools for this? [blush]

EO
Hertfordshire, England
 
Hi,
It all depened on what kind of analysis you want to do..

You still have the original .rpt files, only copies are actually stored in the FRS locations.( and, in spite of the odd names, the stored versions are just .rpt files and can be treated like any other .rpt ( BUT, it is not a good idea to do that outside of the Business Objects framework..too much chance of causing a problem ))


The Administrator launchpad has several utilities for analysis of the CE system and its objects..

What do you want to do?





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
To get a good overview of CE10 download the sdk help file. I downloaded ce_sdk_chm.
This documentation has general information on the CE10 structure.

For example, here is a brief explanation of the APS from the documentation.

APS InfoStore
The APS InfoStore is used to store each InfoObject, as well as most of the information needed by the Crystal Enterprise system to run.

Note: In the case of reports, only the InfoObjects representing the reports in the system are stored in the InfoStore. The actual report files (.rpt) are stored in the File Repository Server (FRS).

From this documentation, I was able to write some vba code in Microsoft Access to extract information about reports and put it in a Access database.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top