Invalid Group error in Crystal Enterprise 10

[BruceBussell]

We have found that we are not able to run CR10 reports containing groups on CE10 Enterprise Manager even though we can run these same reports in the Crystal Report 10 design tool all day.

We keep getting an Invalid Group error in Crystal Enterprise 10, when a report containing group(s) is published and then run.

Anybody know of a solution.

 

[Turkbear]

Hi,
Can you access the data field that is being used for the Group when running from the Published version ( try ungrouping and placing that field in the details, to see)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[BruceBussell]

I tried your suggestion and the field we are trying to group on does not print in CE10 when it is put in the detail line. But it does print in CR10.

So it appears to be a field access problem?

Our runtime is on a DB2 / UDB database on a Unix system.

 

[Turkbear]

Hi,
What connection method ( ODBC? ) If so, be sure it has the needed permissions and is accessing the same data as the CR DSN is..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[BruceBussell]

We found that we had to Trim all the String Fields in Crystal before we ran the report on The DB2/UDB database as Crystal was seeing the string fields as twice the length that they were in the db.

Now the report runs a long time (many minutes) in CE10, where it only takes a few seconds in CR 10 on another matching db. It had run like 10 minutes plus and had not displayed data yet.

 

[Turkbear]

Hi,
Not normal behavior in CE - What method/drivers are you using to connect to the datasource?





To Paraphrase:"The Help you get is proportional to the Help you give.."