How to run multiple reports from one form

Questions related to customising nuBuilder Forte with Javascript or PHP.

Re: How to run multiple reports from one form

Postby kknm » Tue Jun 30, 2020 6:21 pm

admin wrote:kknm,

If you create a criteria (Launch) Form with 2 Objects.

1. themonth
2. theyear

cs.PNG



you can use these values as Hash Cookies both in your PHP and on a Report.

PHP
Code: Select all
WHERE DATE_FORMAT(tabel.tab_data,'%Y %m')= '#theyear# #themonth#'


Steven
This is not optimal.
I have on the form one field with a calendar ('# adat #') and using DATE_FORMAT (tabel.tab_data,% Y% m) = # adat #
I get the year and month in the title in the report.
kknm
 
Posts: 139
Joined: Sat Apr 11, 2020 7:33 am

Previous

Return to Custom Code