Print Page - one query item has two filter

Title: one query item has two filter
Post by: silywiwi on 17 Oct 2007 10:02:31 PM

hi all! me too:)
i want to give a query item two filter
the query item accept the parameter by prompt page
the name of query item is 'studentName',
when the length of parameter greater than 9, i will use "studentName = ?para?"
else i will use "studentName contains ?para?"
how can i make the requirement come true?
thanks in advance!!

Title: Re: one query item has two filter
Post by: raj_tumati on 05 Nov 2007 05:32:35 AM

hi,
i think its not possible.

Title: Re: one query item has two filter
Post by: raaj on 05 Nov 2007 05:44:36 AM

hi,
i think its not possible.

thanks
Raj

Title: Re: one query item has two filter
Post by: trevorp on 05 Nov 2007 09:22:05 AM

Hi

Why not use the standard "Select and Search" prompt

Title: Re: one query item has two filter
Post by: raj4cognos on 05 Nov 2007 10:04:35 PM

hi,
using static filter and dynamic filter we can apply it.

Title: Re: one query item has two filter
Post by: Venu_Gollapudi on 05 Nov 2007 10:53:17 PM

Hi,

Trevor is correct, thats the best thing which we can do for this kind of Scenario.

Regards,
G.V.

Title: Re: one query item has two filter
Post by: wrightr on 13 Nov 2007 02:10:33 PM

Try this filter:

(character_length([StudentName] > 9
and [StudentName] = ?para?)

or

(character_length([StudentName] <= 9
and [StudentName] contains ?para?)

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: silywiwi on 17 Oct 2007 10:02:31 PM