Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    London
    Posts
    76

    Unanswered: Queries in Developer 2000

    Hi there, I have an application designed and implemented in Developer 2000. In which I have been given the task to modify a query so the results of the report are different. Basically this application provides a report (invoices) from a query that include cancelled orders and all I need to do is add a clause not to include cancelled orders. However, I have very little experience in Developer and am short on time, therefore could someone help in where to go to in Reports Builder to allocate the query in question and modify it. I understand I have to compile this report to create runtime version. If this is not as simple as this then please let me know so I can read up further and by myself some more time!...Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    NY
    Posts
    208
    You can access the sql statement of an oracle report a few different ways.

    1) Expand the Report tree, Expand Data Model, Expand Queries, Double click the query you need to work with, and in the Property Palette double click the SQL Query Statement. This will open a query window.

    2) Right click on the report at the top of the tree, choose Report Editor, and double click the top Node (blue box) which is the graphical representation of the SQL query.

    HIH

    Attached is a picture of what it will look like.
    Attached Thumbnails Attached Thumbnails oracle_report.jpg  

Posting Permissions

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