Joined: 04 Sep 2009
Location: United States
Online Status: Offline
Posts: 31
Topic: Ranking in Crystal XI Posted: 15 Mar 2010 at 8:32am
We are trying to create a formula that would rank a record based on the date of the record (1, 2, 3, etc...). Is this possible without getting into that OLAP stuff?
Joined: 04 Sep 2009
Location: United States
Online Status: Offline
Posts: 31
Posted: 15 Mar 2010 at 10:02am
Thanks! This, plus a small formula to reset at each group, gave us the rank. Unfortunately we wanted to group based on rank (all the 1s, all the 2s, etc.) and you can't seem to do that because of the whileprintingrecords. We still learned something!
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 16 Mar 2010 at 3:15am
if you got the data via a stored proc, you could create a column that would be rank, and then you could easily group on that.
yeah, you can't group on a calculated value...at least not one like this(if it was one that could be derived from existing values in the data you could) since the value is not set at the time that the report is being read.
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
