Where The #s are a value in a different field. It is currently sorted by the information in the field that contains the levels. I'd like it to show like:
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Posted: 23 Jan 2017 at 9:59am
Is all of this in a single table? Does each record have a "parent id" of the record that's the next higher one in the hierarchy? What's the max number of levels you might have? Does the data say which level any given record is at?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Posted: 24 Jan 2017 at 8:55am
There is no way to do this directly in Crystal since there is no information about which level each is at. However, I can see ways to do this using either a Stored Function or a Stored Procedure so that you get a data set that has the level information that you're looking for.
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
IP Logged
