Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Topic: Parameter range Posted: 06 Dec 2007 at 6:13am
In my report I have a requirement where a user
can input a range of values say 'emp#' 100 through 500 as a parameter
and also not input any values.
I need to do grouping per emp#.
I have a field which gets it value based on parameter input (I have
to use this field Eno_Dept as a formula field. I am trying to use the
formula
If {?param} in {emp#} then {emp#}+{dept#}
else if {?param}='' then emp#)
How can I accomplish this grouping and the filed Eno_Dept?
I appreciate help with any portion of the problem.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 06 Dec 2007 at 11:12am
You can group on formula fields in the Group Options. Have you tried this or is it not working?
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
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