Where have I gone wrong with my custom report template?

[CarreraUK]

I have created a custom report for my tills to tally up individually however I cant seem to get my head around why and how it works. So my reports arent working.

This is my report template.

  [Payments by Terminal:1, 1]
>Server|
@@PaymentsByTerminal:Server

>GreenSide|
@@PaymentsByTerminal:GreenSide

>GreenRoom|
@@PaymentsByTerminal:GreenRoom

>GreenWood|
@@PaymentsByTerminal:Greenwood

[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