Run report with selected record in RTC

rhardoyal

Hi,

I have added a report on the customer card in navision classic. On the onPush() trigger I have added the following codes to run the report with the customer number selected in the customer card. How do i do same in the Customer card page to make it run in RTC. Note that I have added a new action and control and corresponding code in the page and it does not work.

Customer.SETRANGE(Customer."No.", "No.");
REPORT.RUNMODAL(50035, TRUE,TRUE,Customer);

Any help please on the above.

Thanks,
Rizwana

mohana_cse06

Try

Customer.SETRANGE(Customer."No.", "No.");
IF Customer.FINDFIRST THEN; 
REPORT.RUNMODAL(50035, TRUE,TRUE,Customer);

rhardoyal

Hi,

I have tried the suggested solution but it didn't work. Please see attached want I want to achieve.

When I select the customer record to view, On the customer page, I select the statement of account report that I have added. I want the No field on the report to show the same customer no as in the page but am not able to get this. Any help on this please.

Attached is the screen shot.



Thanks,
Rizwana

mohana_cse06

Use

Customer.SETRANGE(Customer."No.", "No.");
IF Customer.FINDFIRST THEN; 
Customer.SETRECFILTER;
REPORT.RUNMODAL(50035, TRUE,TRUE,Customer);

rhardoyal

Hi,

This time am getting the No in the filter as blank. It is still not picking it up.

DevendraSharma

On request page set SaveValues property NO and use following code.

Customer.SETRANGE(Customer."No.", "No.");
REPORT.RUNMODAL(50035, TRUE,TRUE,Customer);

rhardoyal

this does not work neither