Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005

    Unanswered: report help plz Gurus!

    Printed Purchase Order Report(Portrait)

    Need to modify this report the user wants to put a amount range ie between 100-500 or between any amount.
    say if he puts todays date and then all the PO which are less then Amount $400
    so he will put $0-$400 any idea how to modify the code plus need to create value sets please let me know

  2. #2
    Join Date
    Jan 2004
    Well since its a standard report, you would want to make a copy and put it in your custom top so you don't screw up the real one.

    Since i haven't looked at the report, I can't tell you specifically, but it sounds like you need to add 2 parameters, called something like :P_LOW and :P_HIGH. In your where clause, you would then do something like:
    where.... and amount between :P_LOW and :P_HIGH
    As for value sets, you can just use one of the standard number ones and make it a mandatory field. Unless you have specific intervals or values, in which case you can just create your own and put in values.

    Hope that helps - that is a really really specific question for this forum so I tried answering the best I could.
    Oracle OCPI (Certified Practicing Idiot)

  3. #3
    Join Date
    Nov 2005


    hope this work thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts