Search results for query: *

Friends , I have a report , which has one prompt (country). Values are USA , CANADA . first case : If user selects country prompt as USA then report should pick the filter price > 100 second case : If user selects country prompt value as CANADA then report should pick another filter...

Freinds, While running a report , how do i know that my report is running . Is there any place i can see the staus of the report which is ran or running for report studio reports in cognos 8

Friends, When i am trying to run a report studio report in cognos connection by clicking run with options button which is running in the same window. How can we run the report in a new window. I mean what changes need to do ?? where to do ?? Thanks in advance

Hi , I have a report which is having a prompt . It can have two values (ex : white,red) . If user selects prompt value as white , then report should pick filter which is place=USA , if user select red as prompt value then report should pick another filter : place = canada . Is it possible to...

As you suggested i tried breaking query By hard coding values it is working Like below select T1.STU_ID, T1.TERM from TAR_F_ENROLLMENT_2008 T1 where T1.TERM =('1083' - '7') and T1.ENRL_CAMPUS='OH' and T1.SUB_CAMPUS ='WWW' and T1.TERM_ENRL_NRS = 'Y' where as if i put prompt parameter then i...

Thanks for reply, here is the sql i am running in report but i am getting blank report sir. select T1.STU_ID, T1.TERM from TAR_F_ENROLLMENT_2008 T1 where (T1.TERM =((#prompt('TERM')#)- 7)) and T1.ENRL_CAMPUS='OH' and T1.SUB_CAMPUS ='WWW' and T1.TERM_ENRL_NRS = 'Y' and not EXISTS(select...

You mean to say we can do addition/subtraction in tabular sql on prompt parameters select a,b,c from table names where joins and column name = (#('promptname)# - 10) and not exists(select a,b from table names where joins and column name = (#('promptname)# ) As per your comments above sql...

I wrote a sql and created prompts in report studio cognos 8. I have sql and sub query . Like below select a,b,c from table names where joins and column name = prompt - 10 and not exists(select a,b from table names where joins and column name = prompt) column on prompt data type is float...