Floating date filter in report table filter

knaabis Member Posts: 37

2013-04-17 edited 2013-04-17 in NAV/Navision Classic Client

I need to set up in report table filter floating date filter.
That i mean, for example - Today-60days.
How to do this?

0

Comments

• 

  mohana_cse06 Member Posts: 5,506

  2013-04-17

  Check CALCDATE function.
  You can search the forum also..

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• 

  knaabis Member Posts: 37

  2013-04-17

  But how in this Value place?
  Image attached.

  filter2.bmp 172.1K

  0
• 

  mohana_cse06 Member Posts: 5,506

  2013-04-17

  You need to do it via code in OnPreDataitem..

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0
• 

  knaabis Member Posts: 37

  2013-04-17

  Isn't possible in OnPreDataitem...
  I confused...
  This option in need in Form (not report) designer - i need to set up (filter) in Nav menu.

  0
• 

  mohana_cse06 Member Posts: 5,506

  2013-04-17

  Sorry, Post subject contains "report table filter"
  
  It is not possible to set the floating filter..you need to write code fir this..

  
  -Mohana
  http://mohana-dynamicsnav.blogspot.in/
  https://www.facebook.com/MohanaDynamicsNav

  0