How to show a count() sentence in a Report

[georve]

Hello everybody in that forum

I`m making a report which shown the count of element in a table. the query is

select RazonLlamada, count(*) from TbLlamadas group by RazonLlamada

in a databasemanager the result is

         RazonLlamada            (No columName)

         customerClaims                 10

         instalation                             2

 

When i put the query in Ireport it work ok, but it has two fiel, the first one is RazonLlamada and the secodn one is unnamed. i have tried to rename to use it in a report but an error apear when try to run the report, because the second field don`t apear in database table.. how can solve this problem??

 

[svenn]

select RazonLlamada,

count(*) as mycountvalue

 from TbLlamadas group by RazonLlamada