Optional Query Parameters

[2004 IR Help]

By: schmoboy - schmoboy

Optional Query Parameters

2005-05-26 10:44

I am struggling to handle the following scenario...

 

I have a query string like the following:

 

SELECT * from tablex

where tablex.fieldone in ($P!{valuelist})

 

But... if they select nothing or "All" for the parameter list I want to just do the following:

 

SELECT * from tablex

 

Is this possible?

 

 

 

 

 

 

By: Dmitry Beransky - dberansky

RE: Optional Query Parameters

2005-05-26 16:51

Build the entire query outside the report, not just the value list.

 

 

 

 

By: schmoboy - schmoboy

RE: Optional Query Parameters

2005-05-26 18:04

That would be great, but I'm running the report from OpenReports and that isn't an option.

 

 

 

 

By: jorge - sirion_oef

RE: Optional Query Parameters

2005-05-31 08:44

change to iReport, is better.

 

put "where tablex.fieldone in ($P!{valuelist}) " in a var, use other var that indicate if they select nothing or "All", then do:

 

"SELECT * from tablex " + ($P{All}.equals("1") ? $V{Criteria} : "")

 

 

 

 

By: Vinod Kumar Singh - vinodsingh

RE: Optional Query Parameters

2005-05-31 20:43

try to pass entire where clause as parameter, and in case of 'ALL' pass an empty String