|first report totals, then select parameter and filter [message #1059789]
||Tue, 21 May 2013 15:33
| José Litux
Registered: March 2013
I need a hint about how to create a report using 2 parameters (country , city), surely cascading, but I'm not sure if I'm approaching the right way to get the desired behaviour:
1.a- On first load you select country from a combo box, an a pie chart and some grids are populated with summarized totals for the selected country.
2.a- I need a button (or any other way) to ask for the second parameter (city) and after selection, same totals and charts are populated, but filtering the data based on the city selected.
1.b.- On first load you got two combo-box. Select country from first, and then...
2.b.- Select city from the second, or an option for "ALL CITIES".
If you select "all cities", result is the same as 1.a option.
If you select any city, result is the same as 2.a option.
On option A, I don't know how to ask for second parameter, or even if it's possible.
On option B, I've reached the point when the second combobox is showing the cities from the selected country (on the same window) but I don't know how to insert "ALL CITIES" option.
If I leave it blank a message says:"the parameter city cannot be blank", but if I force a value always end on an error:
+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: avg_city
Cannot convert the parameter value * (or ?, or any value I've tried) to type class java.lang.Integer.
Can not convert the value of * to Integer type.
(city is selected using the integer id value)
Any hint would be much appreciated, I'm really lost
[Updated on: Tue, 21 May 2013 15:59]
Report message to a moderator
Powered by FUDForum
. Page generated in 0.05353 seconds