I have a SQL View. In crystal report, I want to group by a certain field in this view, however when I go to Group Expert, why can't I find this field in the dropdown list to group by?
Carl probably hit on the answer above -- if the field you want to group on is a varchar, or a char of over a certain length, it will appear as a memo field and disallow grouping.
Now, I will take note of not creating UDFs with type VARCHAR(MAX), we should create a VARCHAR with a specified length to prevent Crystal Report from converting it to report data type MEMO.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.