BI Publisher (MOSC)

MOSC Banner

DM_Report.rtf

souravtantubay
souravtantubay Posts: 16 Blue Ribbon
edited Jun 3, 2014 1:42AM in BI Publisher (MOSC) 11 comments

Comments

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    @sfr.farhan.fani

    Can you rephrase your question?

    Thx,

    Kevin

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader
  • souravtantubay
    souravtantubay Posts: 16 Blue Ribbon

    Can anyone plzzz help me to solve this issue....

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    Can anyone plzzz help me to solve this issue....

    I answered your question. Did you try it? If so, what was the result?

    Kevin

  • souravtantubay
    souravtantubay Posts: 16 Blue Ribbon
    edited Jun 9, 2014 7:03AM

    I answered your question. Did you try it? If so, what was the result?

    Kevin

    It does not works with general if condition

    1) if (DE>p_d1) it prints the respective LL,DM,DE values for a respective month/quarter but my requirement is if the condition satisfies for one month/quarter in a row (where the row consists few months/quarters), all the values should print (beacuase one value is satisfied) even other values in that row fails the condition.

    2) if all the months/quarters in a row fails, no value should print - this 2nd requirement is easy to handle but I am not getting the 1st one...

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    It does not works with general if condition

    1) if (DE>p_d1) it prints the respective LL,DM,DE values for a respective month/quarter but my requirement is if the condition satisfies for one month/quarter in a row (where the row consists few months/quarters), all the values should print (beacuase one value is satisfied) even other values in that row fails the condition.

    2) if all the months/quarters in a row fails, no value should print - this 2nd requirement is easy to handle but I am not getting the 1st one...

    So you need a concatenated if:  <? If:condition1 OR condition2 OR condition3 ?> <?end if?>

  • souravtantubay
    souravtantubay Posts: 16 Blue Ribbon

    So you need a concatenated if:  <? If:condition1 OR condition2 OR condition3 ?> <?end if?>

    I dnt think Concatenated ll work here

    below is the procedure i am ryng to implement.

    Can u see the rtf once..

    After the heading row, in next row 1st column I used <?if@row:flag=1?> (flag is a set variable where if flag is 1 it will print the data).

    In LL,DM,DE columns I am using this condition ( if:DE>p_d1 then flag=1) so here flag value set to 1

    but here comes the conflict

    v set the flag value as 1 in 2,3,4 columns(LL,DM,DE) but v r checkng the condition in the 1st column.

  • souravtantubay
    souravtantubay Posts: 16 Blue Ribbon

    I dnt think Concatenated ll work here

    below is the procedure i am ryng to implement.

    Can u see the rtf once..

    After the heading row, in next row 1st column I used <?if@row:flag=1?> (flag is a set variable where if flag is 1 it will print the data).

    In LL,DM,DE columns I am using this condition ( if:DE>p_d1 then flag=1) so here flag value set to 1

    but here comes the conflict

    v set the flag value as 1 in 2,3,4 columns(LL,DM,DE) but v r checkng the condition in the 1st column.

    Hello kevin any suggestions to solve it...

  • Kevin M-Oracle
    Kevin M-Oracle Posts: 12,388 Diamond - Community Leader

    Hello kevin any suggestions to solve it...

    Exactly what is the syntax you used for the two if statements?

    Exactly what result are you seeing, and what result do you expect to get?

    Kevin

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center