Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gofrenzy

    Supress Dynamic cascading prompt

    lbass, MOU_VAL issue stated above is solved if I added {TBL.MOU_Val} = {?MOU} inside the code like below, ( {?MOU_Val} = "MOU" and ( if {?MOU_Region} <> "- ALL -" then {TBL.MOU_REGION} = {?MOU_Region} and {TBL.MOU_Val} = {?MOU} else if {?MOU_Region} =...
  2. gofrenzy

    Supress Dynamic cascading prompt

    lbass, thanks for the help.I am very close to the requirement. I am working around to get the MOU_Val working.
  3. gofrenzy

    Supress Dynamic cascading prompt

    lbass Its working perfect except for the MOU_Val data field which is being retrieved on the report. If I select either MOU/NON MOU in the prompt, final report is retrieving all list of values for MOU_VAL (MOU & NON MOU& ALL.)instead of just a single MOU_Val But if I select MOU_VAL prompt as...
  4. gofrenzy

    Supress Dynamic cascading prompt

    lbass, I tried with the above logic. When i selected MOU_Val as 'MOU' at the top it was still asking me for Region and Center.Similarly when i entered Non MOU it prompted for MOU_Region. No matter what I select, it always prompted for all prompts with all list of values. Is it anything to do...
  5. gofrenzy

    Supress Dynamic cascading prompt

    Thanks alot lbass. I shall try that and let you know.
  6. gofrenzy

    Supress Dynamic cascading prompt

    Can someone please advice on my above issue. Thanks, Sai
  7. gofrenzy

    Default value in Dynamic Cascading Prompt?

    Ido, I almost have a similar problem with different scenario, I have 2 different dynamic cascading prompts(dcp) with two each, Say the first dcp has MOU_VAL and MOU_Region and the second dcp has Region and Center. When the parameters are prompted prompts should be defaulted the following way...
  8. gofrenzy

    Supress Dynamic cascading prompt

    Hi, I am trying to build a report which has 2 dynamic cascading parameters and 2 normal parameters. Two of the Normal parameters 'Business' and 'Division' prompts should be prompted as usual.But it is not the same with my cascading prompts. I have say a dynamic cascading prompt MOU_Val and...

Part and Inventory Search

Back
Top