Where have I gone wrong with my custom report template?

[emre]

Did you created SQL Script?

###@@PaymentsByTerminal

select PT.Name,
    SUM(Amount) as Amount
  from Payments
  inner join PaymentTypes as PT on PT.Id = PaymentTypeId
  where TerminalId in (select Id from Terminals where Name = '@1') 
     and Date > '{Start}' and Date < '{End}'
group by PT.Name

If you don’t know how to add SQL Scripts check this tutorial.

[NEW!] How to use Custom Reports Module 1.0

##Adding SQL Scripts You can display values of a SQL Script result in reports. If SQL Scripts returns a single value you can use it as a cell value. If it returns multiple values that will be formatted as a table row. In other words SQL result will be converted to a | delimited value. ###Creating a script In this section samples won’t be real SQL scripts. I’ll just show you how you can link SQL results with custom reports. Navigate to Management > Automation > Scripts to create a ne…

I’ll strongly suggest to review these custom reports tutorials.

http://www.sambapos.com/wiki/doku.php?id=custom_reporting