Ann Posted August 5, 2020 Posted August 5, 2020 Morning All I have created a report to show all the tasks for a Project. I am trying to add a filter where by I am prompted to enter the Project name, however unless the project name is entered exactly 0 results are bought back. Is there a way of setting up the filter to prompt a list of all project names so that the correct one can be selected, or part of the project name to be entered and results to return? Thank you. Kind Regards Ann Green
Bob Dickinson Posted August 13, 2020 Posted August 13, 2020 Hi @Ann You can have a dropdown list - set up in the same way as I've described in this post: You would give the list a separate name, and instead of adding users names, you would instead add the Project Titles (to both the Value and the Display sections of the list). The downside is that you would have to remember to manually add a new item to the list every time a new project was created for it to appear in this list. We don't have a way of dynamically populating this directly from Project Manager at the moment. In terms of searching for a key word or string instead of the EXACT string - this is possible too. You would need to change your criteria to match the below screenshot - you will notice that I have added a prompt and used the "value is Like" instead of equals When prompted, you will need to use include the % sign as a wildcard operator too For example, if you were search for all projects with the word Office somewhere in the title: %office% - This would return project names with the word "office" ANYWHERE in the project title office% - This would return project names with the word "office" as the FIRST WORD in the project title %office - This would return project names where the word "office" has something PRECEDING IT in the project title This will also work for multiple word strings e.g. %Office 365% I have attached an example definition based on your report to show this in action Kind Regards Bob ag---project-tasks.report.txt 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now