Query Refresh Problems

[jsaint]

I added columns to an existing query.
Then I followed the steps recommended in other threads on this subject:
1. Set Location and changed to the new query, which had all the same columns as the old plus 3 new additional columns.
2. Verify Database.
3. Field Explorer shows all fields including new ones fine.
Problems:
I. Select Expert does not show me any of the new columns.
II. When I change an existing group and try to use the new column as the custom name of the group, only the old columns show up as possibilities - do I need to delete and re-add the group?
Any help would be great!
Thanks,
Jack

 

[chris777]

If the query field are not showing up in the report selection and the Group Definition selection you may have a field type problem. If the field length is too long (for example) Crystal will treat it like a blob field and you can only insert the field, but cannot group or select on it.