Table relation in request page of report

(1) 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

}

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Bilal Haider 412 on at

Like (1)

Report

Hi,

The conditional table relation does not work on report request page. But you can try to use trigger OnAssistEdit and then can open the page based on Account Type.

You can also get the value that user has selected in list.

Was this reply helpful? Yes No