Crystal Reports Parameter fields, if null then all

Report Design

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

Topic: Parameter fields, if null then all

<< Prev Page of 2

Author	Message
Takesen Senior Member Joined: 29 Dec 2008 Location: United States Online Status: Offline Posts: 143	Posted: 06 Mar 2009 at 2:26pm
	yes i did change the {?parameter} to the actual name {?id_nbr}... neither work.
	IP Logged


Takesen Senior Member Joined: 29 Dec 2008 Location: United States Online Status: Offline Posts: 143	Posted: 06 Mar 2009 at 2:29pm
	*Originally posted by DBlank* FYI - I have almost stopped a reply or 2 because hitting the wrong post button after a lengthy typing session This time though on the above post I held down my CTRL key too long and set filters on accidently and then couldn't get them back off. Had to log out of the OS and then back in just to finish that one. Making me laugh though. lol i just read that... yea, the original post before i lost it was a lot more in depth and thorough haha... yea i hate that button sometimes =( because the "post your reply" and the "reply" buttons are labeled the same thing.... lol ah well
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Mar 2009 at 2:30pm
	You could also convert this to using numbers. May be more reliable than text. Change your paramater to a NUMBER type Change your select to if {?parameter} < 999999 then {?parameter}= tonumber({person.id_nbr},0) or you can add in the else part but I don't think you need it if {?parameter} < 999999 then {?parameter}= tonumber({person.id_nbr},0) else {person.id_nbr}={person.id_nbr}
	IP Logged

Takesen Senior Member Joined: 29 Dec 2008 Location: United States Online Status: Offline Posts: 143	Posted: 06 Mar 2009 at 2:38pm
	sigh when i go to put 999999 into the criteria i get: "this array must be subscripted. For example: Array"
	IP Logged

Takesen Senior Member Joined: 29 Dec 2008 Location: United States Online Status: Offline Posts: 143	Posted: 06 Mar 2009 at 2:52pm
	Alright, i got it. I used the text you suggested the first time. just needed to reverse the order.... if {?id_nbr} <> "999999" then {@id_nbr}={?id_nbr} else {@id_nbr}={@id_nbr} on the then part, yours had {?id_nbr}={@id_nbr} but it was filling the left with the right side. when i reversed it, it worked perfectly. Thank you very much Dblank! couldn't have done it without you! =)
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Mar 2009 at 2:54pm
	Weird, didn't know the order in the then matters but that is good to know. Thanks for the update and good luck finishing it up
	IP Logged

Takesen Senior Member Joined: 29 Dec 2008 Location: United States Online Status: Offline Posts: 143	Posted: 06 Mar 2009 at 3:02pm
	Thanks! I thought it was kinda odd too... But it works! i'm not gonna complain! lol
	IP Logged

<< Prev Page of 2

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