| Author |
Message |
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
   Posted: 14 Sep 2010 at 6:36am |
Again I do not have 2008 but I think under the param under the options you can set if it is required or not.
|
 IP Logged |
|
swapna123
Newbie
Joined: 14 Sep 2010
Online Status: Offline
Posts: 15
|
Posted: 14 Sep 2010 at 7:30am |
Hi..when i select the startdate(08/01/2010) and leave enddate as balnk..it displays all the data for all the months..i think there is some problem with the selection..
(hasvalue({?StartDate}) and date({Command.TRANSDT}) >= {?StartDate}) and (hasvalue({?endDate}) and date({Command.TRANSDT}) <= {?enddate}) or (NOT (hasvalue({?endDate})) and date({Command.TRANSDT}) < ={@ffenddate}to currentdate)
can you please look at this..
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Sep 2010 at 7:32am |
(NOT (hasvalue({?endDate})) and date({Command.TRANSDT}) in {@ffenddate} to currentdate)
Edited by DBlank - 14 Sep 2010 at 7:33am
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Sep 2010 at 7:34am |
Sorry that is not right either...
(NOT (hasvalue({?endDate})) and date({Command.TRANSDT}) in {?startdate} to currentdate) |
|
IP Logged |
|
swapna123
Newbie
Joined: 14 Sep 2010
Online Status: Offline
Posts: 15
|
Posted: 14 Sep 2010 at 8:49am |
|
Hi..Could you get any solution for that problem?
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Sep 2010 at 8:52am |
the last post did not work?...
(NOT (hasvalue({?endDate})) and date({Command.TRANSDT}) in {?startdate} to currentdate)
|
|
IP Logged |
|
swapna123
Newbie
Joined: 14 Sep 2010
Online Status: Offline
Posts: 15
|
Posted: 14 Sep 2010 at 9:02am |
|
when i use that last post..it gives the data for all the locations..eventhough if i select only one location..
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Sep 2010 at 9:04am |
you did not mention having another parameter of location.
Add that as another condition
(NOT (hasvalue({?endDate})) and date({Command.TRANSDT}) in {?startdate} to currentdate) and
({?location_param}= table.location)
|
|
IP Logged |
|
swapna123
Newbie
Joined: 14 Sep 2010
Online Status: Offline
Posts: 15
|
Posted: 14 Sep 2010 at 9:12am |
Sorry About that..i thought date was showing problem..so thought of discussing this first..but i have used the other parameter also..
(not HasValue({?Storeroom}) OR {Command.STOREROOM} = {?Storeroom})
and the code which you provided..but it still shows for all locations.
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 14 Sep 2010 at 9:18am |
AND
(not (HasValue({?Storeroom})) OR {Command.STOREROOM} = {?Storeroom})
Edited by DBlank - 14 Sep 2010 at 9:19am
|
|
IP Logged |
|
|
|
