OnOpenPage

(0) Share

Report

Posted on by jsshivalik

3,099

I have DataItem Item Ledger Entry . I want on request page in a report it appears as Text Value . I want that it should appear as Dropdown and values should come from Dimension Table like below code

"Dimension Value".Code WHERE (Dimension Code=CONST(Sub-Center)) .

In this i want that ShortCut Dimension 1 Code in Dimension Value Table should be equal to User Location. Where i should write the code.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

You need to write code on OnLookup Trigger

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

Can u guide me how to go to OnLookUp Trigger . It is Item Ledger Entry Filter . I have not defined it in Request Page. When i click on Properties of this field In DataItem there is no OnLookUp Trigger.

Thanks

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

U mean to say here

Report Type - OnLookup(VAR Text : Text) : Boolean

But how to pass that value to that Particular Filter

Thanks

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

You have write the below code on the Report Type - OnLookup(VAR Text:Text):Boolean trigger.

lvRecDimValue.SETRANGE("Dimension Code",'SUB-CENTER');

lvDimValues.LOOKUPMODE := TRUE;

lvDimValues.SETTABLEVIEW(lvDimValues);

IF lvDimValues.RUNMODAL = ACTION::LookupOK THEN BEGIN

lvDimValues.GETRECORD(lvRecDimValue);

lvSelectedValue := lvRecDimValue.Code;

END;

in the above code,

lvRecUserSetup is a table variable of "User Setup"

lvRecDimValue is a table variable of "Dimension Value"

lvDimValues is a page variable of "Dimension Values"

and lvSelectedValue is a variable of Code 20.

Now, the lvSelectedValue can be used in the "Item Ledger Entry" - OnPreDataItem() trigger like below:-

"Item Ledger Entry".SETFILTER("Shortcut Dimension 1 Code",lvSelectedValue);

hope this helps you.

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

Can u pls guide what is a page variable,table variable. Where to define.

Thanks.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

what I meant is the Type of variable. When you declare a variable, you need to define the type : Page, Record, Code, Text etc...

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Hi

I have written below code . It is giving wrong value in message.

Customer.Setfilter("No.",CustNo);

Message('%1', Customer."Customer Type");

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
Copy link

Link copied!

Ok

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report
Copy link

Link copied!

Where you have written the above code? Is it on the OnPreDataItem? or simply testing?

If it's simply testing, you need to write the FIND statement before you write the MESSAGE statement.

Was this reply helpful? Yes No
Tina Menezes 2,582 on at

Like (0)

Report
Copy link

Link copied!

I hope you have written it in On After Get record trigger of the report. You have to add a Findfirst or find statement before you display a message.

Customer.Setfilter("No.",CustNo);

IF Customer.FINDFIRST then

Message('%1', Customer."Customer Type");

Was this reply helpful? Yes No