arrown Member May 7, 2011 #1 i am enetring an year . for eg: 2010 in the processing option.Then i need to get all the data correspond to (TRDJ- order date )starting form 1 jan 2010 to 31 dec 2010.How to do with this ,easiest method?
i am enetring an year . for eg: 2010 in the processing option.Then i need to get all the data correspond to (TRDJ- order date )starting form 1 jan 2010 to 31 dec 2010.How to do with this ,easiest method?
MagarG VIP Member May 9, 2011 #2 In your Event Rules take the year from the processing options and build the from and start dates 1/1/<year> to 12/31<year>. Then use the function Set Selection to add data selection on the fly.
In your Event Rules take the year from the processing options and build the from and start dates 1/1/<year> to 12/31<year>. Then use the function Set Selection to add data selection on the fly.
aidy Well Known Member May 9, 2011 #3 Try using the business function N0701020. This takes in the Year (TAXYR) and returns First day of year (DTE) and Last day of year (DTE). Then set the data selection Where TRDJ >= First day of year and TRDJ <= Last day of year Hope this helps
Try using the business function N0701020. This takes in the Year (TAXYR) and returns First day of year (DTE) and Last day of year (DTE). Then set the data selection Where TRDJ >= First day of year and TRDJ <= Last day of year Hope this helps
arrown Member May 14, 2011 #6 If i want to hide footer section, based on certain conditions,on which event i have to write logic?
Zaki Ahmed Well Known Member May 17, 2011 #7 You can use SUPPRESS SECTION WRITE system function on DO SECTION