• Replies 4 replies
  • Subscribers 337 subscribers
  • Views 61 views
  • Users 0 members are here
Related

Disable clause in Report Setup

Debbie Harland (Past Member)
$organization

Here's something someone will know.

I need to disable a parameter in my report setup depending on the outcome of a previous parameter. Easy so far. BUT, I want to put two possible scenarios into the same disable clause.

So, parameter 4 becomes disabled if parameter 2 is populated OR if parameter 3 has more than one item selected.

Both of these are possible and work nicely, but I get an error if I put an OR in the clause because I'm trying to use them both.

Any ideas?

Thanks, Debbie

Parents
  • $organization

    Hi Debbie

    We always use AND in our disable clauses so we would put something like this.  i'm not sure the or option works to well.  So this is how we have one of our disable clauses setup.

    <<p1>> <> '5' and <<p1>> <>'6'

    What we tend to do is setup a mode as the first parameter.  So for example a lot of our reports have a performance selection mode.  So you choose if you want to select by Production Season,  Individual Performances or Performance Dates.  It is a lot easier to setup as you can choose which fields are available based on the ID of the mode drop Down rather than if certain values are selected.  So;

    1. if you choose Production Season the Season and Production season drop down are only available.
    2. if you choose Individual Performances the Season and the Performance Drop down are only available.
    3. If you choose Performance Date you have the season and the date fields available.

    Does that makes sense?  If not can send over an example.

    thanks

    Nick

     

  • $organization in reply to Nick Insell

    Hi Nick,

    Yes, your example makes sense, but doesn't really cover what I want.

    I have p1 which is mandatory, then p2, p3 & p4.

    If p2 is populated then 3 & 4 should be disabled.

    P3 is multi select, but p4 will only work if only one item is selected in p3. So, I want to disable p4 if p2 is populated OR p3 has more than one selection. I can determine a multi select using POS(<<p3>>, ',') > 0 which works fine by itself.

    The problem I'm having is with the OR clause. I've found another forum thread which says it should work, but I'm still getting an error.

    Have you ever tried this?

    Thanks, Debbie

  • $organization in reply to Debbie Harland (Past Member)

    I have never tried using an 'or' clause in the report parameters, but I know that I always seem to forget to use the necessary parentheses, "()" for my 'or' clauses in my queries (because I am always using them in conjunction with 'and' clauses), so I am always having to run my queries a second time when the output reveals that I have again forgotten them.  Might there be something down that road here?

  • $organization in reply to John A. Moskal II

    Hi John,

    I think you could be right, although I've tried a lot of options on parentheses. I'll try again and see if I can find the correct combination. Might drop a line to the Support guys, see if they have any hints or tips.

    Thanks for the suggestion. Debbie

Reply Children
No Data