Logic based on input control values

[techvd]

Hi,

Is it possible to implement some logic based on input control values? Here is an example of what I'd like to do:

1. For my report, I would like to provide some flexibilily in selecting the date range. There are options such as "Last Day," "Last Week,"  "Last Month," and "Generic Date Range." I'd probably implement this as a "Single-select List of Values (Radio)" input control (where each option might simply have a numeric value). Please let me know if there are other, better options.

2. Now based on what user selected for the above, I'd like to tweak the WHERE clause for the query accordingly. How can I do this? Additionally, if user selects "Generic Date Range," I'd like to display 2 additional date fileds. I'm not sure if this kind of auto hide/show functionality is available.

Any help is appreciated.

Thanks,
Vijay

[techvd]

Hi, does anybody have any suggestions here? Thanks in advance!

[suedonne123]

I have done some kludgey things in the where clause like having a parameter that is a pull down list of option values...

 

then use these options in your where clause...

 

WHERE

($P{paramOption} = 1 AND database_column=1 ...)

OR

($P{paramOption} = 2 AND database_column=2 ...)

etc

 

not the best SQL ever...but gets the job done...

I think I have also used Case statements with stuff like that too...

 

[manshack_one]

Sounds like you're looking for cascading input controls.  I'm in a similar situation.  I read the sticky on it but can't decide if it's working or not by the time I get to the end of the thread.  What I'm trying to do is create some different input controls to select by a division or district and have it pass into the collection parameter the associated locations.  But i need all the options on the same input control dialog so the users can decide which ones to pick.

[swood]

techvd,

 

If you want the controls to appear and disappear according to the option selected, you will need to create a custom JSP for that and select it as part of the report unit.

 

manshack_one,

 

The scenario you are descibing is cascading input controls. I see from the cascading input control thread that you have got things working.

 

Sherman

Jaspersoft

[techvd]

Thanks for your responses and suggestions!

Sherman, it seems like building a custom JSP is the way to go for us. I have a couple of follow up questions.

1. Is there any documentation or examples for this?

2. Given the complexity of my JSP and what kind of input control I implement there, is it possible to then programmatically construct the query? (The where clauses in the query could change significantly depending on the values users enter).