[Koha-bugs] [Bug 2982] New: SQL for count or sum produces multiple blank output pages, odd screen display

bugzilla-daemon at pippin.metavore.com bugzilla-daemon at pippin.metavore.com
Wed Feb 25 15:19:37 CET 2009


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 at liblime.com
        ReportedBy: jwagner at ptfs.com
         QAContact: koha-bugs at 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.



More information about the Koha-bugs mailing list