Hello,
I'm developing a report with Userid's and Usernames and their activities.

I need to create a flag status static prompt such that when a user selects "TRUE" then the report should display All the users + excluded user list

When user selects "FALSE", the report should display All the users - excluded user list.

How can we create such prompt ?

Basically as answered in your other post you add a parameter Field.

You can add it as a BOOLEAN data type and name it whatever but we will call it "My Parameter" for now.

In the Select Expert write a formula that uses the parameter to filter the records.

I think you want it to include all records from your DB if they pick TRUE and only pick a subset of users if they pick FALSE.

so this will be something like:

 

 

DBlank...Excluded Users are certain users where their userid's are filtered out in selection criteria in general:

 

example : NOT({USERID}  in ('yui002347',yui9089387',.....) )

 

my question is

 

 

when we select "TRUE" from the drop down list of values (LOV), then the report should display all the Users data + Excluded Users data in the report.

 

 

When we Pick "FALSE" from the drop down List of Values (LOV) then the report should display  Userdata - ExcludedUsersdata...so basically here I'm separating out the Excluded users list data when FALSE is selected.

 

 

 

I am at a loss on this although someone else may be able to answer for you. You first need a data source that has a TRUE FALSE option per row that is equivalent to your include or exclude criteria.

However, the problem as I see it is you are looking for a selection of TRUE to include all records and FALSE to limit the selection. Cascading parameters are going to limit it either way and I do not know how you would avoid that.

The only thing I can think of would be to make your firsy parameter allow Multiple values. users would have to select both instead of TRUE to get all users. Otherwise if the select TRUE or FALSE it would limit based on the selection.

 

 

Yes I'm looking for a prameter, but Its not really a cascading prompt. Its just one single prompt with (TRUE & FALSE as List of Values (LOV's) ).so when TRUE is selected, it should  include all the userid's & its activites.

 

 

when False is selected, it should include only  users - excludeduserslist

Create a Parameter as a Boolean Type (this will automatically make it have TRUE FALSE select values.

You can name it whatever you want but for this example I am naming it "My Parameter".

Now in your select statement you use an OR statment to flip your selection criteria based on the choice of the TRUE or FALSE.

 

 

 

 

so should I write my formula in selection criteria as:

 

If {?My parameter} or NOT({USERID}  in ('yui002347',yui9089387',.....) )

 

With the OR stement it will stop as soon as it finds a condition that is TRUE.

Since you are using a Boolean type and you want all records if the paramter is True the first part of your seelct statement is

 

 

If TRUE was selected in the parameter value then this condition = TRUE and the select formula stops there without doing any filtering (if you have other conditions like date ranges then you need to alter to account for those with an AND statement). This isa lso more efficient because it does not need to read the DB at all.

From there the only oher option for the parameter to be is FALSE.  Therefore if it is npot TRUE then your OR is what you want the select statement to be as if they picked FALSE.

Create one statement with parenthesis around the entire logic if there is more to it than the user id not being  in a list.

 

 

 

Thanks Dblank...Its working..Appreciate your help