Request Form Global Variable

It is simply straight forward

1) Declare a global var
2) Make it source expression of the textBox in request form.
3) Use this var to filter anywhere in the report.

RecVar.setrange(RecVarField,yourGlobalVariable); OR
...........setfilter....................................................OR
anyway you want the value in the global variable. It is available to report's all dataItems and corresponding triggers


I hope it helps. O:)

You call from the "Print" Button on your form (is this a form based on a table or with oout a SourceTable ?) the "PRINTRecord" function. Is this a self made function or the standardfunction for example in table 112). If it is your own, you can add a parameter. If it is the standardfunction, you can create a new one in the table with a parameter and set there your global Parameter.

But first: is this a form based on a table (f.ex. 112) or without a SourceTable ?

Regards

which table? Sales Invoice Header?

So, i think your source behind the Button looks like this (example use SalesInvHeader):

CurrForm.SETSELECTIONFILTER(SalesInvHeader);
SalesInvHeader.PrintRecords(TRUE); //or false

The Code in PrintRecords() looks like this (it's standard)

WITH SalesInvHeader DO BEGIN
  COPY(Rec);
  FIND('-');
  ......
  ......
  ReportSelection.SETFILTER("Report ID",'<>0');
  ReportSelection.FIND('-');
  REPEAT
    REPORT.RUNMODAL(ReportSelection."Report ID",ShowRequestForm,FALSE,SalesInvHeader);
  UNTIL ReportSelection.NEXT = 0;
END;

So you see, there is a copy function on a new Instance of the (here) SalesInvHeader. These Copy() function copies also all filters of the current REC (where yout form is based). So if you set a filter before your PrintRecord() command like

SalesInvHeader.setrange("Posting Date",060108D); //or  datevariable
SalesInvHeader.PrintRecords(true); //or false
SalesInvHeader.setrange("Posting Date");

The report will print the Recs with this "Posting Date". But if no rec exist with your posting Date, a error pops up in function PrintRecords() (find('-'))

Also you can create a new function in your table like SetPrintParameters(Parameters) and these parameters you use as a global Variable in the PrintRecords() function. But also here: If no recs exist, the find('-') brings an error:

//new function SetPrintParameters in table

SetPrintParameters(Para1,Para2,Parax)
GlobVar1 := Para1;
GlobVar2 := Para2;
GlobVarX := ParaX;

..........
..........

//the modified PrintRecords function look now like this

WITH SalesInvHeader DO BEGIN
  COPY(Rec);
  
  //new code +++++
  setfilter(SomeField1,GlobalVar1);
  setfilter(SomeField2,GlobalVar2);
  //new code --------

  FIND('-');
  ......
  ......
  ReportSelection.SETFILTER("Report ID",'<>0');
  ReportSelection.FIND('-');
  REPEAT
    REPORT.RUNMODAL(ReportSelection."Report ID",ShowRequestForm,FALSE,SalesInvHeader);
  UNTIL ReportSelection.NEXT = 0;
END;

//The Code behind your Print Button
.......
.......
SalesInvHeader.SetPrintParameters(Para1,Para2,Parax);
SalesInvHeader.PrintRecords(TRUE);

For more help, it's helpfully to see a codesnippes or the for self (picture)

Regards

Please and happy new year (frohes neues jahr)