VBugDenver
Technical User
I need help with a report on two field with two separate data selections on these two field and show the results in the same report.
The two fields are {Schedule.Activity} and {Schedule.Status}
I need to select:
From the {Schedule.Activity} I need to select the activity [“1”, “2”, “3”] where {schedule.Status} <> “X” and
I need to select {Schedule.Activity} where the activity is [“4”, “5”, “6”] where {schedule.Status} = “S”
Here is the formula I have for this:
select {Schedule.Activity} in ["1", "2", "3"] and {Schedule.Status} <> "X" and
select {Schedule.Activity} in ["4", "5", "6"] and {Schedule.Status} = “S”
This formula works but when it runs I get all six of the {Schedule.Activity} where {Schedule.Status} equals “S” and does not equal “X”. I need these two selections to run independently and show in the same report.
Does anyone have an idea what I am doing wrong?
The two fields are {Schedule.Activity} and {Schedule.Status}
I need to select:
From the {Schedule.Activity} I need to select the activity [“1”, “2”, “3”] where {schedule.Status} <> “X” and
I need to select {Schedule.Activity} where the activity is [“4”, “5”, “6”] where {schedule.Status} = “S”
Here is the formula I have for this:
select {Schedule.Activity} in ["1", "2", "3"] and {Schedule.Status} <> "X" and
select {Schedule.Activity} in ["4", "5", "6"] and {Schedule.Status} = “S”
This formula works but when it runs I get all six of the {Schedule.Activity} where {Schedule.Status} equals “S” and does not equal “X”. I need these two selections to run independently and show in the same report.
Does anyone have an idea what I am doing wrong?