Need assistance with forms
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Need assistance with forms

  1. #1
    Join Date
    Apr 2001
    Location
    Germantown, MD
    Posts
    14
    I'm trying to insert prompts into a report to allow the user to customize the report to view the data
    that they want to see. What exactly do I have to do to the report to make this possible?

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    You need to create a user parameter. You can do this in multiple ways:

    when designing the query which will select the data for the report, include a bind variable, such as:

    select * from instructor where id_no = :ID_PARAM

    when you click next, you will be informed that the parameter :ID_PARAM was created for you. When you run the report, the user will be prompted for that value.

    Another way to do it is to create the user parameter under the Data Model/User Parameters node, and then edit the query similar to what I described above.

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