Crystal Reports Parameter if not entered

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

Topic: Parameter if not entered
	Page of 4 Next >>

Author	Message
Minco Groupie Joined: 28 Nov 2012 Location: United States Online Status: Offline Posts: 62	Topic: Parameter if not entered Posted: 12 Sep 2013 at 4:58am
	I have a parameter that selects a certain customer number, but if the user does not put a value in the parameter [leaves it blank] - I need the report to return ALL customers. How do I accomplish this? Thanks-
	Be kind to those less fortunate.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 5:34am
	are you using 2008?
	IP Logged

Minco Groupie Joined: 28 Nov 2012 Location: United States Online Status: Offline Posts: 62	Posted: 12 Sep 2013 at 5:48am
	Yes I am....
	Be kind to those less fortunate.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 6:24am
	(not(hasvalue(param)) or (hasvalue(param) and param=field))
	IP Logged

Minco Groupie Joined: 28 Nov 2012 Location: United States Online Status: Offline Posts: 62	Posted: 12 Sep 2013 at 6:26am
	This statement goes into the select record formula, I assume?
	Be kind to those less fortunate.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 6:28am
	yes
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 6:29am
	if you have other conditions parenth the whole statement above to keep it together Edited by DBlank - 12 Sep 2013 at 6:29am
	IP Logged

Minco Groupie Joined: 28 Nov 2012 Location: United States Online Status: Offline Posts: 62	Posted: 12 Sep 2013 at 6:33am
	Thanks DBlank, I will try this -- I do have another parameter to consider... the user has the choice of running the report by customer (or) by State, and if either param is blank, the report runs for everyone. How would I specify the State part of it?
	Be kind to those less fortunate.
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 6:35am
	what happens if they enter both? does one trump the other or do they work in concert?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2013 at 6:35am
	do they have to enter at least one in either?
	IP Logged

Page of 4 Next >>

Post Reply

Post New Topic

Printable version

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

This page was generated in 0.031 seconds.