Doubt in Reports 6i

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vamsioracle
    New Member
    • Jun 2007
    • 151

    Doubt in Reports 6i

    Hi all


    I was working with a report which shows all the invoices for a particular supplier. There was a requirement to show only the validated invoices and remove cancelled invoices from thereport and accordingly i added one condition " cancelled_flag <>'Y'. so that it retrieves data where cancelled flag is not 'Y'.

    Now in the apps environment, there is a parmaeter to show only the cancelled invoices. When it is checked YES then no data is coming in the output. How can i handle this problem with respect to the parameter. Can i use two queries in the data model that gets selected based on parameter in apps environment.

    please help
    thank u
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    based on user input try executing different queries dynamically.

    Comment

    • vamsioracle
      New Member
      • Jun 2007
      • 151

      #3
      Originally posted by debasisdas
      based on user input try executing different queries dynamically.

      Thank you very much for your support

      but

      could you please elaborate it . how to do that

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        In your case u need to execute two statments

        execute one by default but when the user chooses some other option try to execute the other query.

        It this way the query will be framed dynamically at run time.

        Comment

        • vamsioracle
          New Member
          • Jun 2007
          • 151

          #5
          thank u

          I worked on a query to dynamically select query based on parameter, it was working fine in toad but in report builder it was throwing an error missing expression.

          the query is

          select decode(:P_CANCE LLED_FLAG,'YES' ,(Select (4+3) from dual),(Select (4+4) from dual)) from dual


          the select clause here is replaced by actual select statement in the report. this is a demo one.


          please suggest me the problem.
          ASAP

          thank u

          Comment

          • debasisdas
            Recognized Expert Expert
            • Dec 2006
            • 8119

            #6
            Can y specify what is the use of

            Select (4+3) from dual
            in the query

            Comment

            • vamsioracle
              New Member
              • Jun 2007
              • 151

              #7
              hi

              the query is juat a sample. in place of that i hav to place the query in the report builder.that was testing purpose query which i used in report builder.

              Any way the syntax i had put was the same way but ithrows missing expression error.

              thank u

              Comment

              • vamsioracle
                New Member
                • Jun 2007
                • 151

                #8
                Thank u very much for ur continued support

                I was able to solve that using lexical Parameters in before report trigger.

                thank u

                Comment

                Working...