You’re offline. This is a read only version of the page.
700
Hi All,
In the above screenshot, the office 'location filter' is actually a lookup. But, on the filter page the lookup option is not available.
Is there any way to fix it ?
Yes, it has LookupPageID
TableRelation has been put on the Office Location field in the table.
When you put Office Location as RequestFilterFields, BC will look at the table and use whatever properties in that specific field.
Because the Office Location in table Employee does not have table relation, you do not get the lookup.
I think you are not getting my question. Why I will use table extension in the creation of report.
Can you plz refer to the screenshot and the query, again
You must set the TableRation-property in the TableExtension-Object.
report 50100 EmployeeAllReport
{
Caption = 'Employee-All';
UsageCategory = ReportsAndAnalysis;
ApplicationArea = All;
DefaultLayout = RDLC;
RDLCLayout = 'EmployeeAllReport.rdl';
dataset
{
dataitem("Employee"; Employee)
{
RequestFilterHeading = 'Employee-All';
RequestFilterFields = "Office Location", "status";
column(No_; "No.")
{
}
column(Title; Title)
{
}
column(First_Name; "First Name")
{
}
column(Last_Name; "Last Name")
{
}
column(Birth_Date; "Birth Date")
{
}
column(Job_Title; "Job Title")
{
}
column(Civil_Status; "Civil Status")
{
}
column(Gender; Gender)
{
}
column(Blood_Group; "Blood Group")
{
}
column(Identification_Type; "Identification Type")
{
}
column(Identification_number; "Identification number")
{
}
column(Nationality; Nationality)
{
}
column(Employment_Date; "Employment Date")
{
}
column(Department; Department)
{
}
column(BGV_completed; "BGV completed")
{
}
column(Office_Location; "Office Location")
{
}
column(Number_of_Dependants; "Number of Dependants")
{
}
dataitem(EmploymentDetailsHeader; EmploymentDetailsHeader)
{
RequestFilterFields = "EmploymentType";
//DataItemTableView = sorting();
}
}
}
// requestpage
// {
// layout
// {
// area(Content)
// {
// group(GroupName)
// {
// field(Name; SourceExpression)
// {
// ApplicationArea = All;
// // }
// }
// }
// }
// actions
// {
// area(processing)
// {
// action(ActionName)
// {
// ApplicationArea = All;
// }
// }
// }
// }
var
myInt: Integer;
}
This is the code for my report. Where to put TableRelation.
I tried, but it is not accepting.
Hi,
You have to set the TableRelation-property of that field in your Extension.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (