Stop date

[sperron]

Hi,

I'm not a expert developper so I need some help.
What can I do with my very simple report for stopping de report and do the total, if the date of the document is higher than the user put in the PO ?

Sorry with my english but I'm french people.

Thanks for your help !!

Financial RDA

 

[Christian Audet]

Bonjour Suzanne,

In your report go to your main section, in the event rules go to initialize section event and put Event Rules similar to this :

jdDateToday = date_today()

if PO date > jdDateToday
Stop Batch Processing <--- (System Function)
endif

If you only need to stop one section and need the rest of the report to run then use "Stop Section Processing".

Christian Audet

Implementing B7333 (Xe) SP14.1, SQL
(Support B732, B7331 and B7332)

 

[Sef]

Bonjour Suzanne,

I am not exactly sure what your issue is, but unless I fully misinterpreted your question, it sounds like you wish to either prevent data selection based on a PO or output based on PO.

In the first case you can include in your data selection criteria (after attaching your Processing Option template) something like

Where 'BC Date for G/L' is less than or equal to 'PO Date'

In the second case you can include an Event rule similar to:

If 'BC Date for G/L' is less than or equal to 'PO Date'
Suppress Section Write
Endif

or

If 'BC Date for G/L' is less than or equal to 'PO Date'
Hide Object (RV xxx)
else
Show Object (RV xxx)
Endif

I hope this will help somewhat. If not, could you pls post a little bit more detail on your issue.

Bon chance,


Sef van den Nieuwelaar
Australia
B732 on NT, XE on NT, B732/A73 on AS400, B733 on NT