SUSTAIN Technologies Inc.
7K - views

SUSTAIN Technologies Inc.

eCourt: Intro to Crystal Reports. SUSTAIN Technologies Inc. Supported Versions. Connecting to eCourt. Creating a report. Parameters. Known Limitations. eCourt Report Administration. Advanced eCourt Report Administration.

Download Presentation

SUSTAIN Technologies Inc.




Download Presentation - The PPT/PDF document "SUSTAIN Technologies Inc." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.



Presentation on theme: "SUSTAIN Technologies Inc."— Presentation transcript:

Slide1

SUSTAIN Technologies Inc.

eCourt: Intro to Crystal Reports

SUSTAIN Technologies Inc

Slide2

Supported Versions

Connecting to eCourt

Creating a report

ParametersKnown LimitationseCourt Report AdministrationAdvanced eCourt Report Administration

Training Topics

SUSTAIN Technologies

Inc

Slide3

eCourt supports SAP Crystal Reports 2011.

SAP Crystal Reports 2013

Not officially supported

Supported Versions

SUSTAIN Technologies Inc

Slide4

Obtain and Install Crystal Reports.

Obtain JDBC drivers for your environment

Oracle:

oracle.jdbc.driver.OracleDriverhttp://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

SqlServer

:

net.sourceforge.jtds.jdbc.Driver

http://

sourceforge.net/projects/jtds/files/

jtds/1.2.6/**Newer versions may not work; 1.26 is known good version

Connecting to eCourt

SUSTAIN Technologies Inc

Slide5

Add driver file (.jar) to the Crystal Reports java directory

C

:\Program Files\SAP

BusinessObjects\SAP

BusinessObjects

Enterprise XI 4.0\java\lib\external

\

or

C

:\Program Files

(x86

)\

SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\

Connecting to eCourt

SUSTAIN Technologies Inc

Slide6

Locate CRConfig.xml

C:\Program Files\SAP

BusinessObjects

\SAP BusinessObjects

Enterprise XI 4.0\java\CRConfig.xml

or

C

:\Program Files

(x86

)\

SAP

BusinessObjects

\SAP BusinessObjects Enterprise XI 4.0\java\CRConfig.xml

In the <

Classpath

> node, add reference to the .jar file as C:\Program Files (x86)\SAP BusinessObjects\\SAP BusinessObjects Enterprise XI 4.0\java/lib/external/jtds-1.2.6.jar;Add a pre-named connection, if applicable:<JDBCURL>jdbc:jtds:sqlserver://10.1.3.17:1433</JDBCURL><JDBCClassName>net.sourceforge.jtds.jdbc.Driver</JDBCClassName>

Connecting to eCourt

SUSTAIN Technologies Inc

Slide7

New Report: Blank vs Wizard

Create

Connection

Environment infoin System Status page

Create a Report

SUSTAIN Technologies Inc

Slide8

Select

Table(s

)

Create a ReportSUSTAIN Technologies Inc

Slide9

Joins

Create a Report

SUSTAIN Technologies Inc

Slide10

Parameters

SUSTAIN Technologies Inc

Slide11

Date vs

DateTime

Ability to use Date Picker with database

DateTime fieldsMust Convert in Record Selection Criteria{tCase.filingDate

} >= CDATETIME({?Filing Date}) AND

{

tCase.filingDate

} < CDATETIME({?Filing Date} + 1

)

Date ParametersUse two parameters instead of one with ‘allow range values’

Dynamic vs Static ParametersBest Practice: Always ‘allow custom values’ on Static

Parameters

ParametersSUSTAIN Technologies Inc

Slide12

Inability to use same table multiple times

Known Limitations

SUSTAIN Technologies Inc

Slide13

Resolution

:

Use report command

Use SQL viewsUse SQL stored proceduresKnown Limitations

SUSTAIN Technologies Inc

Slide14

Download

Existing

Metadata tab, click on file link

Upload

New

eCourt Report Administration

SUSTAIN Technologies Inc

Slide15

Parameter Setup

eCourt Report Administration

SUSTAIN Technologies Inc

Slide16

Scheduling

/sustain/

cms

/reportsPrerequisites:

Workflow Process Group ‘Report Scheduling’Java Engine Business Rule ‘Generate

Report’

Save As: Set Name, this will then show up in ‘My Reports’

Add the appropriate schedule.

Advanced

eCourt Report

AdministrationSUSTAIN Technologies Inc

Slide17

Recipients

/sustain/

cms

/contactgroup

Advanced

eCourt

Report

Administration

SUSTAIN Technologies Inc