AnsweredAssumed Answered

parameters element '::group-0' references invalid field in report designer

Question asked by Eric Rosales on Sep 25, 2018

Hi...I'm following the excercises in PENTAHO 5.0 REPORTING BY EXAMPLE BEGINNERS GUIDE book...I´m in chapter7 adding parameters...after defining the main report, this runs well, but after adding the parameters there are the following errors:

 

ERROR: The query 'RatingFilms' did not execute successfully. The reason given was: 'org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT film.rating, film.title, SUM(payment.amount) AS sum_amount, COUNT(1) AS count_rental FROM payment INNER JOIN rental ON rental.rental_id=payment.rental_id INNER JOIN inventory ON inventory.inventory_id=rental.inventory_id INNER JOIN film ON film.film_id=inventory.film_id WHERE film.rating IN (${SelectRating}) AND YEAR(payment.payment_date) = 2005 AND MONTH(payment_date) = 6 GROUP BY film.film_id ORDER BY film.rating, film.title'
WARNING: Element '::group-0' references invalid field 'rating' in attribute 'group'.
WARNING: Element '' references invalid field 'rating' in attribute 'field'.
WARNING: Element '' references invalid field 'title' in attribute 'field'.
WARNING: Element '' references invalid field 'sum_amount' in attribute 'field'.
WARNING: Element '' references invalid field 'count_rental' in attribute 'field'.

 

Any clue to solve this problem will be welcome...

 

Thanks

Eric Rosales

Outcomes