Reports not showing under Report/Run Report buttons

[brianjclark]

Reports look like they are saving in zzzsys_report but do not appear in the System/Reports or System/Run Reports tab?!

Any idea, as this product won't fullfil my needs if I can't do reports


Using Xampp 3.1.0 3.1.0 on Windows, PHP ver 5.4.7.

Have read about the register_globals being removed but the code looks like its had a massive rewrite since 2012 so there's no report_option.php to edit etc as the post suggests..

any ideas?

[jlcsusara]

Hello, brianjclark.

I have the same problem. I am able to design a report but when I try the [Run Report] button, no reports are listed.

After some "bull in a china shop" database searching ( ), I narrowed it down to the "sfo_sql" field in the "nurunreport" record in the "zzzsys_report" table":

Code: Select all

SELECT * FROM zzzsys_report
INNER JOIN zzzsys_form ON sre_zzzsys_form_id = zzzsys_form_id
LEFT JOIN zzzsys_access_level_report ON slr_zzzsys_report_id = zzzsys_report_id
LEFT JOIN zzzsys_access_level ON slr_zzzsys_access_level_id = zzzsys_access_level_id 
WHERE sal_code = '#nu_access_level#' OR '#nu_access_level#' = 'globeadmin'
GROUP BY zzzsys_report_id

1. When I took out the WHERE condition, still no reports listed.

2. When I also took out the JOINS, the list of reports appeared! Of course, by being so brutish, I got other errors subsequently.

BUT, the good news is that the problem is here (methinks). I hope our somebody can debug and fix it soon.

[admin]

brianjclark,

A report run from Run Report without having Criteria Form.

Capture.PNG (30.9 KiB) Viewed 5936 times

Steven

[jlcsusara]

after re-reading the documentation...

1. if you want to see your reports listed in "Run Report", you need to add a "Criteria Form" in your report.

2. if you want to run a report using a button, create a button object that has an "onclick" event which runs the nuPrintPDF('<your report name here>') JavaScript function.

hope this helps.

[admin]

.