CR 8.5 dies when a field is added to a report

[MJRBIM]

We are running CR 8.5 against PeopleSoft queries created in PeopleTools 8.16

We have a report that contains a number of field types (eg. Char1, Char6, Char11, Char50, Date) and runs fine.

However when we add a new field from the query that is of the Char type - the Crystal Reports application closes without an error message.

I'm guessing it is because the Char type has no defined length...How does Crystal handle the Char type? Does it convert it to a Memo, or a String(255)?

Has anyone seen this before? Any suggestions would be welcome.

Thanks in advance...

 

[synapsevampire]

Why not just explicitly state the char length?

I'm not aware of a generic char type, the legnth is specified.

You might also try applying the service pack, but I doubt it will resolve this:

http://support.crystaldecisions.com....asp_selectlist#Crystal Reports Service Packs

-k

 

[MJRBIM]

Thanks for the suggestions....Service Pack #2 for CR 8.5 is installed.

I'm not developing the PeopleSoft queries (or the reports) - just helping them when they get into trouble.

It appears to be a "generic CHAR type", which may just be the way PeopleTools 8.16 shows a LONG. Each record appears to hold thousands of characters.

I'm not sure how to explicitly state the CHAR length in PeopleTools 8.16, I will take your suggestion back to the PS people - and see if they can do it.

Any other ideas would still be welcome...

 

[synapsevampire]

You might be able to use a SQL Expression to CAST or CONVERT it to a varchar() or some such.

Sorry, I'm unfamiliar with Peoplesoft.

-k

 

[MJRBIM]

After further investigation, it looks like a field formatting problem from PeopleTools 8.16 - for some reason it's not diplaying the format as LONG, which it is in the Oracle data-source.

I'm going to post it on the PeopleSoft forum.

Thanks for you help.