Reports bugs
- Blocker
- Critical
- Major
- Normal
- Minor
- Trivial
- Enhancement
- New Feature
New 138
Unable to report on patrons with borrowers.auth_method password
Report group code should only contain ASCII chars
Can delete reports with only execute_report permission
Reports keyword searching as phrase
Catalog statistics report shows incorrect total when library has both blank and null values in an item column
Restrict reports so they can only be run by permitted users
Update and Run SQL button should save changes even if report fails to run
"Items with no checkouts" report (catalogue_out.pl) broken with SQL strict mode enabled
Misleading choices from reports error when runtime parameter is named incorrectly
Date filter not used in circulation report
CSV export of cash register misses newlines
16703
TCA(
Home > Reports > Circulation statistics showing no circulation
There should be a way to dismiss the suggestions in SQL report editor
Cannot go back when creating a new report
Koha should not strip limits from SQL queries
SQL auto-complete should not be triggered by closing a quotation or parentheses
13446
GC
Scheduled Reports lacks format options
17354
GC
Group By/Order By SQL mismatch in issues_stats.pl
Default Framework Report Yields Empty Download
8127
GC
Most-circulated items report doesn't work when limited by library
"Patrons with the most checkouts" report (bor_issues_top.pl) broken with SQL strict mode enabled
"Patrons who haven't checked out" report broken with SQL strict mode enabled
Calendar picker in reports sometimes chooses wrong month when back button used
Overdue report download not respecting custom patron attribute filter
Orders By Fund report (orders_by_fund.pl) should include actual cost (unitprice)
12757
GC
Integers in saved SQL report ODT export prepended with single quote
10635
GC
Can't query for CREATE/DELETE in action_logs with SQL reports
WHERE clause doesn't like % in CONCAT
17786
GC
Date filter on circulation statistics not working correctly
Report editor in guided_reports.pl truncates reports longer than 64 KiB
14943
GC
Multiple datepickers incorrectly linked in guided reports wizard
12082
GC
hold statistics wizard can produce misleading results
q_errors in Reports export phase is wrong data type
16654
GC
The output from reports/cat_issues_top.pl is not proper CSV
Wrong encoding of reports exported in tab format
Patrons with no checkouts report should only display patrons you are allowed to see
Empty entry in table configuration for saved SQL reports
Denote delimiter in exported report results
Show report name on page title when viewing SQL
Add "Run with template" to report actions
Add a PDF download option to print a report based on a notice
Report pagination is inefficient
Add privacy elements to reports
Default report output to template
Allow for URL param to set report subgroup by default
Batch Modify button in report with itemnumber only includes titles in first page of results
Add datetime as runtime parameter option in reports
Batch item operations should be available to report which return barcodes
6961
GC
runtime parameter for fund codes
Acquisitions vendors should be available as a runtime parameter in reports
18239
GC
Add Open Document export option to items search
Add filters to report results
Make library groups accessible as runtime parameter category in reports
Add method to define limited access to run reports
9474
GC
Merge "Overdues" and "Overdues with fines" reports
Show fine amount on 'Overdues with fines' report
Circulation statistics is not intuitive with callnumbers that feel numeric
Add payment type on Cash register report (cash_register_stats.pl)
Add timestamp option to flatpickr calendar
Template ids need to be editable
Report ids need to be editable
Build printing into reports
7335
GC
Allow custom parameters for sorting in SQL reports
Add way for reports to default to logged in library when branches in runtime parameters
2906
GC
Holds ratios report should have more filters
Remove Summary and Matrix options in the guided reports wizard
Simplify report landing page
17120
GC
Specify number of rows per page in report and initial run
Catalog statistics should use items.deleted_on instead of items.timestamp
Patron statistics report should treat sort 1 and sort 2 the same
16440
GC
Update runtime parameters after running a report
Create runtime parameters on the fly
Allow final user to choose ordering column
Merge (deleted)biblio* and (deleted)items tables - Update reports
Keyword search on "Reports" is persistant
Reports with too many params can exceed length limit of URI
reserve_stats.pl: Further improvements to refine hold status
Show groups/categories of reports to authorized staff
Links in reports don't work when item/record/patron have been deleted
Add option to delete saved reports results from staff interface
16121
GC
Reports need a counter of uses
Lost item statistics are not copied to pseudonymized transactions
Guided reports in the catalog module duplicates itype
"Edit report" option when selecting parameters
Add a way to copy a report result to clipboard
Limit reports execution time with SQL variables
Run reports against a replicated database
report on item types
15528
GC
Updating the authorised value for a report subgroup removes the previous value assigned from all report
SQL comments are not fully ignoring runtime parameters
7655
GC
Runtime parameters: Allow for making free text and date fields optional without the need for users to enter %
3417
GC
Items with no checkouts report won't output to a file
10460
GC
way to stop a run away report
Allow one to set an override value for CSVDelimiter per report
Store saved_reports values as hash
ODS report download inserts apostrophe in front of numerical results
Catalog by item type report should allow specifying home or holding branch
Make patron clubs accessible as runtime parameter category in reports
Circulation guided report missing biblio table
Add biblionumber and itemnumber in Item lost reports
Allow padding of call numbers in runtime parameters to compare to cn_sort values
Add subtitle to "Most-Circulated Items" report
Incorrect timestamps on Orders By Fund report (orders_by_fund.pl)
Sort dropdowns on "Most-Circulated Items" report
On public reports, the behavior of cache-expiry 0 is confusing to users
Allow arbitrary database field as runtime parameter
Create list of parameters to choose from via a query
Send borrowernumbers from report to batch modify
26610
LG(
Add 'NULL' option to report value dropdowns
Allow reports to count open/closed days based on the calendar
Add stocknumber/inventory number to the "Items lost" results table
Report editing doesn't show report author
Hide batch actions from reports results if no permissions
Allow batch actions from reports when formatting numbers as links
One off report
Add borrower attribute types as run time parameters in reports
Add Sort1 and Sort2 to Patrons with the most checkouts report
REPORT_GROUP and REPORT_SUBGROUP branch limits don't hide reports on 'Saved reports' page.
12215
GC
Add 'sql dump' as report output option
Allow public reports to add parameters
Cash register wizard printing
Fees details in cash registry statistics
Add sort1 and sort2 to overdues report
9710
GC
Alllow multi-select on search criteria in statistic wizards
Add biblio information to credits on cash register
Download Reports Directly
Refactor C4::Reports::Guided
When downloading reports, long running reoprts will time out
Allow saving scheduled report output as a list/virtualshelf
17751
GC
Patrons wizard: Allow to define activity timeframe
17369
GC
Enhance the Reports button on mainpage.pl
15557
GC
Reports dictionary: Remove superfluous radio buttons for date entry
9567
GC
Favorite reports per user
7003
GC
Canned report to show patrons and permissions
12067
GC
Canned circulation statistics report by call number range
10627
GC
History of reports run and their results
Batch modification for Reports
12714
GC
Export report in PDF
Assigned 1
33862
MDR
reserve_stats.pl: Cancelled holds are counted incorrectly under processing status
In discussion 3
6719
GC
Reports dictionary doesn't properly recognize text columns
27432
FS
Add report run to action logs
27691
LG(
Allow HTML in notes for saved SQL reports
Failed QA 14
20150
JD
Acquisitions wizard falsely uses list price for calculating amounts spent
23978
MR(
Notes field in saved reports should allow for HTML
35509
LG(
Make SQL autocomplete an optional feature
10188
TCA(
Top Most-circulated items doesn't count current loans
35905
BL
Missing permission check for "record batch delete" from reports
34829
KF
Cash register report reverts to "All libraries" after every search
runreport.pl html email striping
27510
ID
Download the report in HTML format
33013
PV
Add age, interface and operator as additional report stats
9965
KMH
Improve integration of report plugins with existing reports
22145
JA
Add a syspref to hide the 'rows per page' dropdown when running a report
21215
P
Saved SQL reports code improvements [Omnibus]
21200
P
Allow default values for saved SQL report "date" parameters
13392
JM
New statistics wizard for suggestions
Patch doesn't apply 4
33452
KF
Update patron statistics report
35193
KMH(
Rename "Message subject" to "File name" when module "Reports" was chosen
35807
KF
Update catalog statistics report
28061
LG(
Cash Register Stats table (cash_register_stats.pl) should include a timestamp
Needs signoff 1
36027
AN
search_for_data_inconsistencies.pl - make each section optional
Signed off 2
37050
BL
Add select2 to SQL report multi select
36585
MH
Patrons with the most checkouts Report when outputting to CSV doesn't have the total
Pushed to main 1
32413
JR
JSON reports shows inaccurate results with repeated parameters
Needs documenting 8
37270
OL
Deleting a report from the actions menu on a list of saved reports does not work
37382
CL
Report download is empty except for headers if .tab format is selected
37763
CL
'Update and run SQL' appends the editor screen after the report results
35856
BL
Runtime parameter modal should provide option of ":all"
37188
NC(
Batch patron modification from report results should be an option when borrowernumber is selected
5920
MR(
Remove HTML from downloaded reports in CSV format
36555
AF
Add report_id to file name when exporting report results
35746
BL
Multiple selections for parameters used in the IN function