Completion of this task requires that:
The connection settings are configured in the CRConfig.xml file during theIBM InfoSphere Enterprise Records installation. See the IBM InfoSphere Enterprise Records Installation and Upgrade Guide.
To create the report template
Select F.PathName, RCR.ContainmentName, MK.MediaType, MK.DateCreated, MK.Creator from (Markers MK Inner join ReferentialContainmentRelationship RCR on MK.This=RCR.Head) Inner join RMFolder Fon F.This=RCR.Tail where MK.DateCreated >= {?start_date} And MK.DateCreated <= {?end_date} And MK.MediaType = '{?media_type}' And MK.this insubfolder '/{?fileplan_browse}'
NOTE The parameter name must match the symbolic name of the CE Property Template.
start = Date(Left({?start_date},10))
end = Date(Left({?end_date},10))
EntityName= {Command.PathName} + {Command.ContainmentName}
Creator: Command.Creator
DateCreated: Command.DateCreated
MediaType: Command.MediaType
@EntityName: Formula EntityName.
C:\Program Files\Business Objects\BusinessObjects Enterprise 12\Samples\en\Reports\ Detailed Physical Records By Media Type Created.rpt
Parameter |
Value |
Comments |
---|---|---|
fileplan_browse | Records Management/<FilePlanName> | |
start_date | 2008-01-01 | Check the datetime format setting in Crystal Reports Designer |
end_date | 2008-12-31 | Check the datetime format setting in Crystal Reports Designer |
media_type | paper |
You have now created the detailed report template, Detailed Physical Records By Media Type Created.rpt.
NOTE