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.
