Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 13 Mar 2014 at 9:53am
Yes, you can drop the parameter on to the report. If is a date range, I create two formulas, one for the beginning date, the other for the ending date: minimum({?Date Range}), maximum({?Date Range}). If it is a multivalued parameter, you can use the join function. I think the format is join({?parameter},", "). That will show the values separated by commas.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 13 Mar 2014 at 11:45am
When you say you cannot get it to work, what do you mean? Of course I am assuming that the {?parameter} is a string parameter. If not then you may need to put in the totext function, example: totext({?Parameter}).
Joined: 10 Sep 2013
Location: United States
Online Status: Offline
Posts: 13
Posted: 14 Mar 2014 at 4:53am
Please forgive me. I am very new. Pretty computer savy, but just learning and having to teach myself. I have the basics down but not sure what you are talking about.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 14 Mar 2014 at 5:05am
Ok, parameters come in different varieties (numeric, date, string, etc.), basically it determines what kind of data you want to filter on (normally what a parameter is for).
In using the join function, it wants a string as one of the arguments. If the parameter you are trying to display is numeric, then the join function will generate an error. Where as you can use the totext function to convert a number (or date, etc.) to a string. Crystal Reports (and the web) have good resources describing how to use join and totext.
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