Jump to content
Changes to the Jaspersoft community edition download ×

Subreport problem with LIKE in SQL query


2005 IR Help

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...