Topic: Why are fields not appearing for me to Group by? Posted: 31 Jan 2010 at 8:02am
Hi!
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?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 01 Feb 2010 at 11:21am
There are certain data types you are not allowed to group on. Like in SQL server you cannot use the 'image' field type. I know that there are others, but I do not remember them all.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum