| first report totals, then select parameter and filter [message #1059789] |
Tue, 21 May 2013 11:33  |
Eclipse User |
|
|
|
Hello everybody
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:
option A:
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.
option B:
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 11:59] by Moderator |
|
|
|
|
| Re: first report totals, then select parameter and filter [message #1060082 is a reply to message #1059904] |
Wed, 22 May 2013 22:40  |
| Eclipse User |
|
|
|
|
There are several ways you could do it. You could have a grid and several lists (one in each column) and filter them to have several columns of cities. You could populate a HTML drop down list in the report if only using HTML outputs. Also with HTML outputs only, you could do the first option with a choose city button that would show/hide the lists. I think I said this above, but you could simply have a link that says "Narrow by City" and that links to another report where the cities would be listed in the parameter page. There are probably a couple other options as well.
|
|
|
Powered by
FUDForum. Page generated in 0.03282 seconds
Home