Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rajusus111

    filter based on prompt value

    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...
  2. rajusus111

    report status

    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
  3. rajusus111

    Run report in new window

    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
  4. rajusus111

    Filters based on prompt values ???

    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...
  5. rajusus111

    question on prompts

    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...
  6. rajusus111

    question on prompts

    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...
  7. rajusus111

    question on prompts

    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...
  8. rajusus111

    question on prompts

    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...

Part and Inventory Search

Back
Top