@@ -, +, @@ not contain integers SELECT CONCAT('', itemnumber, '' ) AS itemnumber FROM items LIMIT 10; SELECT itemnumber FROM items LIMIT 10; SELECT itemnumber, CONCAT('', itemnumber, '' ) AS itemnumber FROM items LIMIT 10; --- .../prog/en/modules/reports/guided_reports_start.tt | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-) --- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt @@ -755,8 +755,10 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] + [% NEXT UNLESS cells.cell.match('^(\d+)$') %] [% IF header_row.$place.cell == 'itemnumber' || header_types.item(header_row.$place.cell) == 'itemnumber' %] [% SET batch_itemnumbers = 1 %] + [% SET header_row.$place.has_itemnumbers = 1 %] [% END %] [% END %] @@ -769,8 +771,10 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] + [% NEXT UNLESS cells.cell.match('^(\d+)$') %] [% IF header_row.$place.cell == 'itemnumber' || header_types.item(header_row.$place.cell) == 'itemnumber' %] [% SET batch_itemnumbers = 1 %] + [% SET header_row.$place.has_itemnumbers = 1 %] [% END %] [% END %] @@ -781,8 +785,10 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] + [% NEXT UNLESS cells.cell.match('^(\d+)$') %] [% IF header_row.$place.cell == 'biblionumber' || header_types.item(header_row.$place.cell) == 'biblionumber' %] [% SET batch_biblionumbers = 1 %] + [% SET header_row.$place.has_biblionumbers = 1 %] [% END %] [% END %] @@ -805,7 +811,7 @@ canned reports and writing custom SQL reports.