Report Created - now Search by Date Range

[icoso]

I created a report using the FastReport Function on the Builders Tab. Here it is:

Report-TaxReturn1.png

Report-TaxReturn2.png

IT WORKS GREAT! It prints out a report on ALL the records in my table and sorts them and Sums the sub-totals, etc... Just like I set it up.

NOW I need to run the report on the TaxCustomers table for a date range against a field in the TaxCustomers table named tax_billdate.

How do I do this?
Please don't point me to the manual or the Wiki, or any other post here. I have read them all. I created a form on the Tax Customers Table, I created SQL, I've created Javascript, I linked them all together according to the manual, I've read and tested and tried. I've wasted hours doing this. I cannot get it to work. I don't know why? I tested my Javascript - no errors. I tested my SQL in myPHPAdmin site again the table directly - no errors. I have a terrible headache.

Just tell me Step by exact Step what I need to do to run this EXACT REPORT for a date range against a field name tax_billdate in the TaxCustomers table. ANYONE????

[apmuthu]

Abstract out all user tables - schema and sample data set along with all user changes to system tables (as UPDATE statements) and provide it here removing all confidential elements and restrict it to just getting the essence of what you want done. Preferably do this on a fresh install.

This info should suffice to help you out from where you are in your design cycle. A list of operations in text form (not screenshots) as illustrated here would go a long way in providing best practices in design evolution for your particular instance and serve other newbies as well.

[icoso]

I honestly dont see where providing the extract of my table is going to help at all. Most people wouldn't understand the SQL anyways so that provides no help to anyone. The structure is very simple. The pictures provided show very well what I've got and done. I've been doing this too long to know that reinstalling something is NEVER an answer and telling someone to do so is not helping at all.

I've made NO changes to any system tables except adding the encrypt_data table that kev1n suggested in a prior post.

I have 1 table: TaxCustomers It contains:

--
-- Table structure for table `TaxCustomers` with basically these fields.
--

CREATE TABLE `TaxCustomers` (
`TaxCustomers_id` varchar(25) NOT NULL,
`cust_prissn` varchar(11) DEFAULT NULL,
`cust_lastname` varchar(1000) DEFAULT NULL,
`cust_firstname` varchar(1000) DEFAULT NULL,
`cust_secssn` varchar(11) DEFAULT NULL,
`cust_address` varchar(1000) DEFAULT NULL,
`cust_city` varchar(1000) DEFAULT NULL,
`cust_state` varchar(2) DEFAULT NULL,
`cust_zip` varchar(11) DEFAULT NULL,
`cust_homephone` varchar(12) DEFAULT NULL,
`cust_priemail` varchar(80) DEFAULT NULL,
`cust_pribdate` date DEFAULT NULL,
`tax_taxyear` int(11) DEFAULT NULL,
`tax_preparer` varchar(25) DEFAULT NULL,
`tax_billingamt` decimal(12,4) DEFAULT NULL,
`tax_billdate` date DEFAULT NULL,
`tax_office` varchar(25) DEFAULT NULL,
`tax_comments` mediumtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

I created 1 form BrowseEdit form that I use to View, Edit, and/or Duplicate the data in this table. I have 3 records in this table because I am just now beginning development and testing.
I created 1 report it RUNS perfectly but it runs against the entire table, I want to run it on a date range.
I laid out exactly what I did to create the SQL and a "search" form that has 2 date fields on it. I provided snapshots of everything. I provided my SQL, my code, everything I can think of.

I don't understand what else you need. I'm not going to reinstall the portal system, redesign my tables, redesign my forms, redesign the report. That is ridiculous to even suggest doing that.

Like my question states: Just tell me step by step what I need to do exactly to make it run the report via a date range? Why is that so hard to ask for. The manuals, the wikis, the GitHub, the Youtube videos, dont even come close to showing exactly how to it. I folled the v3 manul on how to run a report on based on criteria (why in the world would you choose to run a report on a name, rather than a date range as your example is beyond me). I believe I followed the steps in the v3 manual as suggested, I wrote the SQL, it works when I use it in myPHPadmin, the dates I have on the form NEVER get passed to the SQL or he report.

There has to be something Im missing and its like pulling teeth to try to get some suggestions from or directions from anyone. Why? I have not found much in any of the documentation of the functions, the wikis, or the forums, that has been overly helpful to me as a newbie with this system. Most EVERYTHING I've learned so far has been by a VERY long trial and error and trying to figure out what works where. A lot of Alert(); and ECHO coding to try to see what's doing what. IT takes hours to do anything.

The Steps I've done:
1. created a table using the FastForm - it worked.
2. modified the form for all the functions I've needed. - It works. I spent days working on just Field Masking because there is NOTHING simple built-in to the system to do it. Even posted my terrible code for others to use for this.
3 created a report to run against my table - it works!
4. tried to create the SQL and form to run that the report runs to search for records based on a date range - It DOESNT work as shown in the manuals, wikis, youtubes, forums, or anything else I've found.. Apparantly I have to run the report from my one and only browse/edit form from a button, which makes no sense! If I run the report from the Home -> Run Report page agians the TaxCustomers table it works but it pulls all the records. If I run the report that I duplicated originally from the one report that works and modified it to run the SQL and use the form with the date range fields (date1 & date2) - It DOES NOT work. The form runs but when I click the RUN button at the top (as pictured) I get a blank report.
5. I tried to create a way to use the built-in Search screen on my browse/edit form to encryt the search field to search the taxCustomers table using the cust_SSN field. This doesn't work. I've spent nearly I work working on this one thing and cant get answers to my questions that I believe would help me understand the flow of this system. Instead I get do a fresh install and post a complete EXTRACT of your entire install including all your data forms, etc....

I don't need that. Direct me to something that shows exactly what I need to do to run a report, that I ALREADY have made, that works as-is, to run using a date range. What exact steps do I need to do to accomplish this task? I dont have some magic form that already has some buttons and date fields on it, like the youtube video from Janusz posted. Im using the basic menu buttons that are built-in to nuBuilder. I have no clue how he created that form. https://www.youtube.com/watch?v=hrhSQsGuExc