Subreport problem with LIKE in SQL query

[2005 IR Help]

By: Hugh Blandford - global

Subreport problem with LIKE in SQL query

2005-04-06 00:53

Hi,

 

I'm trying to use a subreport with the following SQL syntax:

 

SELECT usage_type.iis_description, COUNT(*) AS number_calls, ROUND(SUM(amount_billed)*0.01,2) AS billed FROM (detail LEFT OUTER JOIN usage_type ON detail.usage_type = usage_type.id)

WHERE id_value LIKE '%$P{PHONELINE}' GROUP BY usage_type.iis_description ORDER BY usage_type.iis_description;

 

I get a message saying:

 

SQL problems:Parameter index out of range.

 

If I put in one of the numbers that appear in the master report the SQL query runs fine.

 

Any suggestions