Cognos Report Keyword Search -

-

i need provide keyword search option in cognos report. have 4 text box prompts keywords. need solution filter details field based on 4 keywords entered. filter expression tried is:

if (?p_details1? not null) ( if (?p_details2? not null) ( if (?p_details3? not null) ( if (?p_details4? not null) (upper([details]) contains (upper(?p_details1?)) or upper([details]) contains (upper(?p_details2?)) or upper([details]) contains (upper(?p_details3?)) or upper([details]) contains (upper(?p_details4?))) else (upper([details]) contains (upper(?p_details1?)) or upper([details]) contains (upper(?p_details2?)) or upper([details]) contains (upper(?p_details3?))) ) else (upper([details]) contains (upper(?p_details1?)) or upper([details]) contains (upper(?p_details2?))) ) else (upper([details]) contains (upper(?p_details1?))) ) else (1=1)

if 1 of text box prompts null report returns records. appears ignoring if statements. works if text box prompts have data.

cheers.

this filter should work you: 

(?p_details1? not null , upper([details]) contains (upper(?p_details1?))) or  (?p_details2? not null , upper([details]) contains (upper(?p_details2?))) or  (?p_details3? not null , upper([details]) contains (upper(?p_details3?))) or  (?p_details4? not null , upper([details]) contains (upper(?p_details4?))) or  (?p_details1? null , ?p_details2? null , ?p_details3? null , ?p_details4? null)

it might helpful think of filter test cognos apply every row. either keep row (true) or discard (false). relational database sources, doesn't work way internally in effect.

the filter first checks see if first prompt has value , [details] data item contains prompt value. if does, includes row , moves on next row. if doesn't, moves next part of or statement tests second prompt. if second prompt has value , [details] data item contains prompt value row kept , moves on next row. repeated 4 of parameters.

if none of expressions return true , last part evaluated. expression checks see if prompts null. if so, rows returned.


Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more