This discussion is archived
1 Reply Latest reply: Jul 25, 2013 5:43 AM by Soofi RSS

Oracle 6i Formula Column

hokoba Newbie
Currently Being Moderated

Hi Techies,

I have an Oracle 6i report which has a parameter form. It takes the argument Contract_Num as an input. Based on the value of the Contract_Num, a formula column displays a string.


Now I dont want to use the parameter form. I have simply modifed my report group query. I get all the contract_num in the output but the respective string is not displayed as I dont input any Contract_Num in the parameter form. The Formula Column always returns NULL in the all the pages.


Please advise on how to pass the contract_num to the Formula Column to display the respective string in each page.



  • 1. Re: Oracle 6i Formula Column
    Soofi Explorer
    Currently Being Moderated

    Hi Sri,


    As you said you have modified your query, you can directly bind the variable in the formula column as


    : (your variable).


    If your formula is outside your report group. Please place your formula column within that record group and try.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points