http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=2982 Summary: SQL for count or sum produces multiple blank output pages, odd screen display Product: Koha Version: rel_3_0 Platform: PC OS/Version: Linux - Debian Status: NEW Severity: normal Priority: P3 Component: Reports AssignedTo: galen.charlton@liblime.com ReportedBy: jwagner@ptfs.com QAContact: koha-bugs@lists.koha.org When creating and running reports from SQL in the Guided Reports area, I'm noticing some odd screen output. For example, if I use the SQL query SELECT COUNT(*) as "New Patrons" FROM borrowers WHERE borrowers.dateenrolled >= '2009-02-01' AND borrowers.dateenrolled <= '2009-02-28' the screen output looks like this: << < 1 2 3 ... 7 > >> New Patrons 138 Download the report: [pulldown for output option] = '2009-02-01' AND borrowers.dateenrolled <= '2009-02-28'" /> [download button] There are arrows and numbers for multiple pages, but the only page with output is the first, which has the new patron count. In addition, part of my SQL query is displaying on the bottom line, where the pulldown and button for downloading report results are. If I build the report from SQL and run without the "As New Patrons" qualifier: SELECT COUNT(*) FROM borrowers WHERE borrowers.dateenrolled >= '2009-02-01' AND borrowers.dateenrolled <= '2009-02-28' << < 1 2 3 ... 7 > >> COUNT(*) 138 the annoying multiple blank pages still shows, but it's not reproducing part of the SQL query on the download line. I've seen similar results with any query that does a sum or count. I searched the bugzilla site but didn't find anything that seemed relevant. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.