Grouping on Text Field - Not building tree in Enterprise

[DavidSherring]

I have used the (very useful) tip of having dynamic grouping within a report by defining a parameter and then assigning it a field. See Example.

select {?group}
case 'COURSECODE': totext({MBDA_FREEZE_DATA.COURSECODE})
case 'CLOCK' : totext({MBDA_FREEZE_DATA.CLOCK})
case 'COURSE_TITLE' : totext({MBDA_FREEZE_DATA.COURSE_TITLE})

This works very well in crystal, and also builds a grouping tree for me. But within Enterprise, I can get a grouping tree on the first two, but not the last.

The enterprise version is Product: 9.0.1.558
The crystal version is 9.2.2.634
The field is a 255 character string with backend of Oracle.

Anyone got any ideas?

David

 

[lbass]

You don't need totext() around the last case, if it's already a string. Not sure this will solve the issue though.

-LB

 

[groggle]

What type of field does Crystal think your {MBDA_FREEZE_DATA.COURSE_TITLE} field is?

Right Click on it and choose Browse Field Data.

If it thinks it is a Memo field then this is why. If it says String, it should work unless it contains only nulls.

 

[DavidSherring]

I removed the () and made a calculatd field of 100 characters of the original. Both didn't work, but thankyou for trying to help anyway. Any suggestions as to where I may find a solution, or should I approach business objects? Don't forget, it works in crystal, just not in enterprise.

David

 

[groggle]

Have you tried different viewers?

ActiveX, Java, HTML, DHTML?