Table value inserted to another Table's grouping 1

[mdelgado100]

Using Crystal 8.5 - Oracle Database
I have two tables:Incidents and WorkOrders. The tables are link WorkOrders to Incidents with a left outer join.
WordOrders MAY have a corresponding Incident number. An incident is open and a work order is spun off, but not all ways. WorkOrder maybe created independantly.
In the Edit Selection Formula I have: {workorders.state}=Open
I have 3 groups from the WorkOrders Table in the following order:
WorkOrders.dateTime.
WorkOrders.Location
WorkOrders.Part#
Details
-------------
Problem:

When I insert the Open_date_time from the Incident table in the details section, the value is incorrect. I get a MM,DD,YY,HH,MM,SS displayed, But the value is incorrect.

Appreciate any help...Maria

 

[synapsevampire]

On what field is "The tables are link WorkOrders to Incidents with a left outer join."

I doubt that anyone can tell you why a date is wrong if they don't know your table structures, and joins required.

A datetime field should not normally have commas in it. so perhaps you are misunderstanding the datetime field, and it is a string of some sort?

-k

 

[mdelgado100]

Synapsevampire,
Thank you. I'll try to answer the questions.

On what filed is the WorkOrders and Incidents joined.
I've linked the Fields: WorkOrder# to Incident#.
The Incidents can be have many WorkOrders
but WorkOrders can have only one incident.
Datetime Fied commas.
No commas are really associated, not a string field,
I used example(MM,DD,YY,HH,MM,SS)to indicate the
value that was returned. The value TYPE is correct
The Value itself is not.

Again, I appreciate any help you can offer - Maria

 

[synapsevampire]

Try changing your connectivity type to either the Crystal native connectivity for Oracle, or the Crystal supplied Oracle ODBC, don't use the Oracle supplied ODBC.

-k