DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to use dynamic queries for generating reports?

  1. #1
    Join Date
    Feb 2001
    Posts
    6

    Exclamation

    For e.g. allowing a user to select the table(s) / column(s) he wants before generating the report based on those field(s) selected.
    or is there any way to invoke Query Builder directly while running a form?

  2. #2
    Join Date
    Mar 2001
    Location
    Cologne, Germany
    Posts
    24
    You can get the tables and columns from the sys-views user_tables and user_tab_columns. Use them to populate your LOV's, construct a sql-statement and execute it using dynamic sql. ("execute immediate" or the dbms_sql-package)

    Commit;
    6502

  3. #3
    Join Date
    Oct 2000
    Posts
    123
    But i want to know how you set up the field properties like Name, color...... if the content is trully dynamic? You still have had some pre-define reports ("templates") to be used, right?

    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
  •  


Click Here to Expand Forum to Full Width