Date Interval In Report

Hi, I wish to have a report prepared in different intervals such as daily, weekly, yearly and etc by requesting a user to select an option of a period type in Request Form. I know that we can SETRANGE on date filter for relevant tables according to period type such as weekly, quarterly or yearly. However, I’m hoping for other ways or perhaps more efficient with faster performance. Thanks in advance.

There are several ways to go here: 1) Modify codeunit 1 date function to recognize new shortcuts i.e. x=week,y=ytd,etc. 2) In your report, creat a global variable of option type with values such as Today, Week, Month, Year. Then in the OnPreDataItem trigger, create a case statement to setup your date filters. Bill Benefiel Manager of Information Systems Overhead Door Company (317) 842-7444 ext 117

See you report 105 (Customer - Summary Aging). There are a good solution Best regards from BCN. Agustí