Page 2 of 2
Re: Using COUNT() in report
Posted: Fri Feb 26, 2021 8:28 pm
by apmuthu
Acquire the date fields input as you want but send it (save it) in MySQL ANSI format - yyyy-mm-dd. All JS in the form gets lost when used to run a report.
Re: Using COUNT() in report
Posted: Fri Feb 26, 2021 8:51 pm
by icoso
apmuthu wrote:Acquire the date fields input as you want but send it (save it) in MySQL ANSI format - yyyy-mm-dd. All JS in the form gets lost when used to run a report.
I did that. I moved this convo to this post:
https://forums.nubuilder.cloud/viewtopic. ... 2&start=10
Can you help me there? The long last post covers a lot of questions...
Re: Using COUNT() in report
Posted: Fri Feb 26, 2021 10:36 pm
by steven
icoso,
Code: Select all
SELECT TaxCustomers.* FROM TaxCustomers WHERE TaxCustomers.tax_billdate BETWEEN '#RPT_date1#' AND '#RPT_date2';
should be
Code: Select all
SELECT TaxCustomers.* FROM TaxCustomers WHERE TaxCustomers.tax_billdate BETWEEN '#RPT_date1#' AND '#RPT_date2#';
Steven
Re: Using COUNT() in report
Posted: Sat Feb 27, 2021 2:09 am
by icoso
Yes, I have that. That was just a Typo in this forum post. As I mentioned in the other post in the Reports thread. I got it working - not the way the manuals, wikis, videos, examples show you how, but I got it working. The SQL is working now, but I had to call it and the report from a launch form.
HOWEVER, I still can't get the date variables passed into the report itself. They don't print on the report. I posted pictures.