Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: oracle report 6i

    My requirement is using Oracle Reports 6i, I would like to create a report, which will accept a parameter and based on that parameter’s value ( say ‘Y’ or ‘N’) the no of fields will display in report.
    Say, if parameter values is ‘Y’ then 6(six) fields will display
    and if parameter values is ‘N’ then 4(four) fields will display.

    Any one could help me out.

    Thanks

    JD

  2. #2
    Join Date
    May 2004
    Posts
    42

    Report 6i

    You have to write a Dynamic SQL which is not permitted in REPORTs 6i.


    Thanks & Regards
    Rasmi

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Have your query return all 6 fields, but put a format trigger on the two additional fields on the report. If the parameter is 'N' then supress the two additional fields by returning false on the trigger. The format trigger is in the property for the specific field in the layout that you want to effect.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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