J2EE 1.3.1

[Former Member]

Server Configuration: Red Hat Linux AS 2.1, DB2 8.2, J2EE 1.3.1

Client Configuration: Windows XP SP2

Application Type: Thick client

Question: Can I use Crystal Reports 2008 to develop a report that is printed by my application with the above configuration? What do I need to deploy on the server to accomplish this task if it is possible?

Thanks,

Tom

[Former Member]

Ted,

Thanks. I will try your suggestion and get back to you later this week.

-Tom

[Former Member]

Ted,

For example:

1. End User enters an order

2. End User later wants to print order details

3. End User chooses menu item to display order list

4. End User selects order from list

5. Report appears in a second window

6. End User either hits print or cancel

EJB 1.3.1 usage:

1. Orders are stored using an EJB

2. Customer information is stored using a secong EJB.

Currently, I believe the following:

1. I can design/format the report with the CR design tool.

2. I place the report and other files on the server or include them with the application.

3. I can call the appropriate CR methods from a CR jar file to accomplish point #5 above.

4. To actually populate the report, I will make an SQL query that gets the order and customer information. The thick client will need to include the CR jar file.

I hope this scenario clears up any confusion.

Thnaks,

Tom

[ted_ueda]

So I'm assuming you're using the EJB only as a data source - that the report processing is happening on the client.

Crystal Reports for Eclipse SDKs support use of Plain Old Java Objects (POJOs) as data source.

So that would mean retrieving the data from your EJB with whatever EJB framework lib you're using, then wrap them in a POJO collection and use CR to report off that.

Sincerely,

Ted Ueda

[Former Member]

Ted,

We tried to design the report tables so that using a "key", we can retrieve the desired data with SQL query(ies). So, currently I do not have a preference. If I am limited due to the old 1.3.1, that may be OK.

Thanks,

Tom

[ted_ueda]

Tom, there's a disconnect here.

You have a thick client. You want to display Crystal Reports. You want to use Java.

You're trying to connect to EJB. Is the EJB supposed to be the data source or the report source?

What is the thick client doing? Where are you housing the reports?

How is the thick client connecting to the EJB?

Sincerely,

Ted Ueda

[Former Member]

Ted,

We use EJB (CMP) and Transactions. We usually access the DB for read only via SQL and jdbc connections.

Thanks,

Tom

[ted_ueda]

Next question: do you want just the data housed in the EJB, or do you want the report processing done on the EJB?

Sincerely,

Ted Ueda

[Former Member]

Ted,

The 1.3.1 classes are used by the DB and our thick client application.

From my current understanding, the tasks are:

1. Install CR on one of our XP boxes

2. Design the report(s)

3. Place the report on the server with the other CR required files

4. Access the report via our application when the user wants

As far as I know, we do not actually have much in the way of server side workflow after design time. Am I correct?

Thanks,

Tom

[ted_ueda]

J2EE contains several different components and containers, including EJB, Servlet, Transactions, etc.

Which container?

Sincerely,

Ted Ueda

[Former Member]

Hi Ted,

Within my application, I want the end user to be able to print a report. So, I will design the report using CR, then within the application, I will provide a button to preview/print the selected report. Since we are using J2EE 1.3.1, I wanted to know if there were any issues prior to proceeding.

Thanks,

Tom

[ted_ueda]

When you say J2EE 1.3.1, what exactly are you using in J2EE 1.3.1?

I'm specifically asking about server-side workflow, not client.

Sincerely,

Ted Ueda

[ted_ueda]

There's no thick-client component SDK for Crystal Reports 2008 that will work with J2EE, if you're talking EJB containers.

What specific workflow are you looking at?

Sincerely,

Ted Ueda

[former_member11696]

Hi Tom,

Legacy forum is for old CR technologies, moving your post to Java forum.

Thank you

Don