Joined: 19 Feb 2008
Location: Malaysia
Online Status: Offline
Posts: 62
Topic: Record Selection Based on Parameter Posted: 13 Jul 2010 at 12:45am
Hi there~
I need help in solving this problem. I got 2 parameter in my report. 1st Parameter = First Item and 2nd Parameter = Last Item. If the user key in the parameter in First Item and Last Item, it will displays a range between First Item and Last Item.
But if my user leave the First Item and Last Item parameter empty, then it will list out all the item. How can i do this? Kindly advice..
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 13 Jul 2010 at 3:36am
Likely you cannot leave the parameter blank.
You have to choose a value that is equal to blank. THis depends on the stat type of your field. Since you want a range I will guess it is numeric so use zero. If the
in your select statement you then do an OR statment
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
IP Logged
