Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Prompt based on filter!

Prompt based on filter!

Prompt based on filter!

hello all,

i've a filter created to select a attribute say city...
i also have a prompt which helps the user select customer names where the display is restricted using city filter...

so when i use that in my report for the first time first it prompts for city... once a city is selected it displays all the customers from the city only.... but when i close and again execute it is not asking for city again instead goes directly to customer name selection box with the previous selected city a condition...

any help on how to make it ask both city and then customers from that city on each execution of the report...

also how do one give grand totals to a report from MS Web like in Desktop...


RE: Prompt based on filter!

when you saved the report, did it say something like "reprompt"....if so you should choose reprompt everything.

there's a subtotals option in web 7i, i think it's under the data pull down menu.

RE: Prompt based on filter!

when i save it from the grid view it asks for two choices

1. Static
2. Prompts
   You will be re-prompted when this report is run again
   1. Only filter will be prompted.
   2. Only template will be prompted.
   3. Filter and Template will be prompted.

I've chosen option 2 within that 3 and also unchecked
Keep the prompt answers for the report....

any help..



RE: Prompt based on filter!

i would pick option 3...try that.  if it still doesn't work, call tech support.  also remember to clear your caches before you re-run your reports.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close