Small and medium business | Business Central, N...

Table relation in request page of report

(4) Share

Report

Posted on by Pragya752

234

I have a report where user has to fill in the type of account say bank,vendor,employee,G/L account etc on the request pge and according to that the table realtion for the next field account no. should be there but I am unable to set it.For setting conditional table relation ,it is not letting me use ACCtype variable,How can i do it or any other approcah for the same that anyone can think of.

requestpage

{

SaveValues = true;

layout

{

area(content)

{

group(GroupName)

{

field(AccType; AccType)

{

}

field(AccNo;AccNo)

{

TableRelation = if (acctype = filter(Vendor)) Vendor

}

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi

I hope this can help you. and give you some hints.

Lookup on field in request page (dynamics.com)

BR

GR

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (1)

Report

What report is this?
Generally, AccType and AccNo variables need to be redeclared unless they are marked as Protected Variable in the standard

More details: Dynamics 365 Business Central: Can we access global variables from page extensions or table extensions? Yes, But……

https://yzhums.com/21738/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

David Pezzoli 14 on at

Like (1)

Report
Table relation is available using these request properties:

SourceTable = "Gen. Journal Line"; SourceTableTemporary = true;

for example:

Report 51000 "ReportTest" { Caption = 'Report Test'; ProcessingOnly = true; dataset { } requestpage { SourceTable = "Gen. Journal Line"; SourceTableTemporary = true; layout { area(Content) { group("Account Setup") { field(AccountType; Rec."Account Type") { ApplicationArea = All; ShowMandatory = true; NotBlank = true; Caption = 'Account Type'; ToolTip = 'Specifies the Account Type.'; } field("Bank Account No."; Rec."Account No.") { ApplicationArea = All; ShowMandatory = true; NotBlank = true; Caption = 'Account No.'; ToolTip = 'Specifies the Account No.'; TableRelation = if ("Account Type" = const("G/L Account")) "G/L Account" where("Account Type" = const(Posting), Blocked = const(false)) else if ("Account Type" = const(Customer)) Customer else if ("Account Type" = const(Vendor)) Vendor else if ("Account Type" = const("Bank Account")) "Bank Account" else if ("Account Type" = const("Fixed Asset")) "Fixed Asset" else if ("Account Type" = const("IC Partner")) "IC Partner" else if ("Account Type" = const("Allocation Account")) "Allocation Account" else if ("Account Type" = const(Employee)) Employee; } } } } actions { area(Processing) { } } trigger OnOpenPage() begin end; trigger OnQueryClosePage(CloseAction: Action): Boolean var begin end; } }

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,962 Super User 2025 Season 2 on at

Like (2)

Report

Hope this helps as well: https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-request-pages-for-reports

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tablerelation-property

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-set-relationships-between-tables

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Solved: How to pass filter values to a Report Request

SourceTable property - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No