report 50103 EmployeeConfidentialInfoReport
{
Caption = 'Confidential Information';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
DefaultLayout = RDLC;
RDLCLayout = 'EmployeeConfidentialInfoReport.rdl';
dataset
{
dataitem("Employee"; Employee)
{
RequestFilterHeading = ' ';
RequestFilterFields = "Office Location", "status", "No.";
column(No_; "No.")
{
}
column(First_Name; "First Name")
{
}
column(Last_Name; "Last Name")
{
Caption = 'Surname';
}
column(Office_Location; "Office Location")
{
}
// dataitem(EmploymentDetailsHeader; EmploymentDetailsHeader)
// {
// RequestFilterHeading = ' ';
// RequestFilterFields = "EmployeeNo";
// //DataItemTableView = sorting();
// }
dataitem("Confidential Information"; "Confidential Information")
{
RequestFilterHeading = ' ';
RequestFilterFields = "Confidential Code";
column(Confidential_Code; "Confidential Code")
{
}
column(Description; Description)
{
}
}
}
}
Above is the AL code for the report.
CASE 1:
As I have selected Employee No. as AH then the following report is generated
Data is getting linked to same Employee 2 times
CASE 2:
I have created the confidential code '1' and Information only for employee AH but it is displayed for all employees
NOTE: Two confidential codes have been created in the entire scenario '1' and '2', but for different employees. May be this is the reason why two records are displayed for the same employee.
I hope you got the scenario now !
