Request page

Horse06

Hi expert,
I have two questions below and need your professional advice.

1. Need to add .. before the date, but it has an error after adding '..' before calcdate. How to fix it?
IF datefilter = 0D THEN
datefilter :='..' & calcdate ('-1D', Today);

2. The sales order field on the request page of report will automatically display the sales order number after the user hits the print button from the sales order page. How to accomplish this? Do I need to add the code to the report or add to the print button on the sales order page?
Thank you!

Kishorm

Horse06 wrote:

Hi expert,
I have two questions below and need your professional advice.

1. Need to add .. before the date, but it has an error after adding '..' before calcdate. How to fix it?
IF datefilter = 0D THEN
datefilter :='..' & calcdate ('-1D', Today);

2. The sales order field on the request page of report will automatically display the sales order number after the user hits the print button from the sales order page. How to accomplish this? Do I need to add the code to the report or add to the print button on the sales order page?
Thank you!

1. You are trying to add a text to a date - won't work. You need to do the following...

datefilter :='..' + SUBSTSTRNO('%1',calcdate ('-1D', Today));

2. You need to set a filter on a sales order no field on the dataitem record in your report and then pass that to the report. Assuming your report has a "sales header" dataitem then this would be something like...

SalesHeader := Rec;
SalesHeader.SETRECFILTER;
MyReport.SETTABLEVIEW(SalesHeader)
MyReport.RUN;