Crystal Reports Passing Parameter Range

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Passing Parameter Range

Author	Message
Tolik888 Newbie Joined: 21 Apr 2010 Online Status: Offline Posts: 4	Topic: Passing Parameter Range Posted: 21 Apr 2010 at 4:44am
	Hello, I have a report that have 2 parameters, 1st parameter is date range and 2nd parameter is numeric data range. My question is: How do i pass parameter chosen values to Report Header of the report. It should look like this : Detail Report from date MM-DD-YYYY to MM-DD-YYYY. and Price range from 0.00 to 0.00 according to user entries in parameter. Thank you.
	Tolik
	IP Logged


DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Apr 2010 at 4:51am
	'Details report from date ' + totext(Minimum(?DateParam),'MM-dd-yyyy') + ' to ' + totext(Maximum(?DateParam),'MM-dd-yyyy') + ' and Price range from ' + totext(Minimum(?RangeParam),2) + ' to ' + totext(Maximum(?RangeParam),2) Edited by DBlank - 21 Apr 2010 at 4:52am
	IP Logged

Tolik888 Newbie Joined: 21 Apr 2010 Online Status: Offline Posts: 4	Posted: 21 Apr 2010 at 5:15am
	I copy everything and change names on parameters,but it says: "Missing )" do you know why? Thanks.
	Tolik
	IP Logged

kevlray Admin Group Joined: 29 Oct 2009 Online Status: Offline Posts: 1587	Posted: 21 Apr 2010 at 5:16am
	I normally do the 'minimum({?DateParam})' and 'maximum({?DateParam})' in formulas and drop the formulas into a text box.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Apr 2010 at 5:19am
	Replace the (?DateParam) with your actual datae parameter field and repalce the (?RangeParam) with your actual other paramter field and try it.
	IP Logged

Tolik888 Newbie Joined: 21 Apr 2010 Online Status: Offline Posts: 4	Posted: 21 Apr 2010 at 5:31am
	I did replace (?DateParam) with my actual parameter and (?RangeParam). It still doing same thing saying: "The ) missing." Do i need to put curly braces around parameter or parenthesis is just fine.
	Tolik
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 21 Apr 2010 at 5:36am
	Both. the {} always goes around the field name The Parenth goes around the field when using the Maximum/Minimum and totext fucntions. will look something more like: 'Details report from date ' + totext(Minimum({?Date}),'MM-dd-yyyy') + ' to ' + totext(Maximum({?Date}),'MM-dd-yyyy') + ' and Price range from ' + totext(Minimum({?Range}),2) + ' to ' + totext(Maximum({?Range}),2) Edited by DBlank - 21 Apr 2010 at 5:37am
	IP Logged

Tolik888 Newbie Joined: 21 Apr 2010 Online Status: Offline Posts: 4	Posted: 21 Apr 2010 at 5:51am
	Very good,everything working now according to the plan. Good Job. Thank you. Respectfully Tolik.
	Tolik
	IP Logged

Printable version

Forum Jump

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