nuBuilder Forum

I added this to the BE of a form Im trying to use to as the date range search criteria for a report
nudebug(nuhash());

[0] :
===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[42S02]: Base table or view not found: 1146 Table mytab_custreturns.___nu16036d4d362b87____nu_summary' doesn't exist

===SQL===========

SELECT SUM(nu_sum_tax_amtpaid) AS the_sum_a FROM ___nu16036d4d362b87____nu_summary

===BACK TRACE====

/home/.../nurunpdf.php - line 772 (nuRunQuery)

/home/.../nurunpdf.php - line 622 (nuGetFieldValue)

/home/.../nurunpdf.php - line 392 (getObjectRows)

/home/.../nurunpdf.php - line 343 (setObjectLines)

/home/.../nurunpdf.php - line 279 (buildSection)

/home/.../nurunpdf.php - line 59 (nuBuildReport)

Can ANYONE tell me why Im getting this error?

There is no table/view/nuSQL linked to the form where this custom code resides. Check scope and visibility of the code and it's dependencies.

I have no idea where this is coming from.

mytab_custreturns doesn't exist. I don't know why this would even come up. there are no object that reference "Table mytab_custreturns.___nu16036d4d362b87____nu_summary"

This happens to be on the report I created and the amtpaid field is summing properly.

None of this makes any sense.

__xxx__ type table names are for temporary tables created while making the report and gets deleted thereafter.

OK, so again,

I have no idea where this is coming from.

mytab_custreturns doesn't exist. I don't know why this would even come up. there are no object that reference "Table mytab_custreturns.___nu16036d4d362b87____nu_summary"

This happens to be on the report I created and the amtpaid field is summing properly.

I have several SUM fields on the report. three of them are for the tax_amtpaid field. One in each of the group footers for tax_billdate and tax_office and one in the report footer. But I also have other Summary fields in those same sections. Why would it be failing on this one?

icoso,

Is your Report grouped by anything?

https://wiki.nubuilder.cloud/ ... #Functions


Steven

Yes, It is. I posted more about it and more questions in the Report thread. I deleted the Sum fields for that table field and re-added them. I've read the wiki multiple times. Not much there thats helpful.

icoso,

Can you create a simple report from a single table with no criteria and just 1 summed field?


Steven

Yes I posted about it in the Report thread. The way the manuals, the wiki, and the youtube videos show how to do it, DO NOT work. I had to create a separate launch form to run the report from and it still doesn't pull those dates into the report. Go to the Reports threads. I posted about it there.