report 50101 EmployeeBirthdayReport
{
Caption = 'Birthday';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
DefaultLayout = RDLC;
RDLCLayout = 'EmployeeBirthdayReport.rdl';
dataset
{
dataitem(EntitlementSetup; EntitlementSetup)
{
DataItemTableView = sorting(No);
column(FORMAT_TODAY_0_4_; Format(Today, 0, 4)) { }
column(COMPANYNAME; COMPANYPROPERTY.DisplayName) { }
column(EmployeeFilter; EmployeeFilter) { }
// trigger OnAfterGetRecord()
// var
// myInt: Integer;
// begin
// EmployeeFilter := Employee.GetFilters;
// DateFilter := Employee.GetFilter("Birth Date");
// end;
dataitem("Employee"; Employee)
{
RequestFilterHeading = ' ';
RequestFilterFields = "Office Location", "Status";
// column(FORMAT_TODAY_0_4_; Format(Today, 0, 4))
// {
// }
// column(COMPANYNAME; COMPANYPROPERTY.DisplayName)
// {
// }
// column(CurrReport_PAGENO; CurrReport.PageNo)
// {
// }
column(No_; "No.")
{
}
column(First_Name; "First Name")
{
}
column(Last_Name; "Last Name")
{
}
column(Birth_Date; format("Birth Date"))
{
}
// column(EmployeeFilter; EmployeeFilter)
// {
// }
column(DateFilter; DateFilter) { }
trigger OnPreDataItem()
var
myInt: Integer;
begin
If (FromDate > 0D) and (ToDate > 0D) then
SetRange("Birth Date", FromDate, ToDate);
EmployeeFilter := Employee.GetFilters;
// FromDateFilter := Employee.GetFilters;
end;
// trigger OnAfterGetRecord();
// begin
// SetRange("Birth Date", FromDate, ToDate);
// end;
}
}
}
requestpage
{
layout
{
area(Content)
{
field("From Date"; FromDate)
{
ApplicationArea = All;
}
field("To Date"; ToDate)
{
ApplicationArea = ALL;
}
}
}
trigger Onopenpage() //sets default value for the Status filter as 'Active'
var
myInt: Integer;
begin
Employee.SetRange(Status, Employee.Status::Active);
//Employee.SetRange("Birth Date", FromDate, ToDate);
end;
}
var
CurrReport_PAGENOCaptionLbl: Label 'Page';
FromDate: Date;
ToDate: Date;
EmployeeFilter: Text;
DateFilter: Text;
}
Hi All,
In the above report, there are two date filters named From Date and To Date. I need that these filters should filter data according to date and month, by ignoring the year part.
Is it possible to achieve ?
If yes, how this could be done ?
Please suggest asap !
Thanks !
