Forum Discussion
Solved
I only want to show the active projects in this report
- Your screenshot doesn't show that. It shows the word "active" under the field NameProject, which one would assume is the name of the project, not its status. The clipped view of the Query Design Grid also doesn't show a field called "Status".
In addition, your screenshot shows two criteria for "NameFunction". If that is the criteria, you'll also have to repeat "active" on both lines to accomplish the filtering required.
Hello,
The status of a project is active or closed. So I put "active" in the criteria for the status but the report still gives all project, also the closed ones
The status of a project is active or closed. So I put "active" in the criteria for the status but the report still gives all project, also the closed ones
Your screenshot doesn't show that. It shows the word "active" under the field NameProject, which one would assume is the name of the project, not its status. The clipped view of the Query Design Grid also doesn't show a field called "Status".
In addition, your screenshot shows two criteria for "NameFunction". If that is the criteria, you'll also have to repeat "active" on both lines to accomplish the filtering required.
In addition, your screenshot shows two criteria for "NameFunction". If that is the criteria, you'll also have to repeat "active" on both lines to accomplish the filtering required.
- Thank you, the problem has been solved and I learned a lot