Nikolaj Posted January 9, 2020 Share Posted January 9, 2020 Hello Support @AlexTumber Is it possible to get a report for all open Project Tasks with due date yesterday? Any help appreciated. Thanks Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 9, 2020 Share Posted January 9, 2020 @Nikolaj there are a couple of options 1. in the main client and in the Activities View, you can create a view for this: 2. In the admin console reporting you can do something like the following, status is assigned. 2 Link to comment Share on other sites More sharing options...
Nikolaj Posted January 10, 2020 Author Share Posted January 10, 2020 @Steven Boardman thanks for your help. In your first example i can only see my tasks or activities not from all my other project managers right? i looking for a report for all project tasks. In your second example i think it is possible to see all open tasks but i get not the result is expect maybe i do something wrong. here my settings for the report: I would like to see the project Name, Task Name, due date and assigne... for example for all tasks over the due date yesterday... many thanks Nikolaj Link to comment Share on other sites More sharing options...
Nikolaj Posted January 15, 2020 Author Share Posted January 15, 2020 Hello @Steven Boardman can you help me with this report please? Is something possible like this? to see all open tasks with due date yesterday from all projects? with project name, task name, project manager and due date. thanks and best regards Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 16, 2020 Share Posted January 16, 2020 @Nikolaj here is a report def which will get you most the way, just missing off the project manager - seems to work against my test data set. You can get upload the report def to your instance. I'll look at the PM aspect a little later and post back here project-tasks.report.txt Link to comment Share on other sites More sharing options...
Nikolaj Posted January 16, 2020 Author Share Posted January 16, 2020 @Steven Boardman thanks for your report. I installed it but the result is empty in my instance as you can see Is that setting right here: due date is between ..... Thanks Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 16, 2020 Share Posted January 16, 2020 @Nikolaj looking at your example, it looks like your due date is the 14th Jan, so i would not expect to see it in the report, as it is only looking at due dates from yesterday the 15th? Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 16, 2020 Share Posted January 16, 2020 @Nikolaj i've added more data and my results still look valid with this report. I've added in the Project Manager for the project, where the task due date is yesterday - new report definition included. project-tasks.report (1).txt Link to comment Share on other sites More sharing options...
Nikolaj Posted January 17, 2020 Author Share Posted January 17, 2020 @Steven Boardman thanks for your help. In this last report something is wrong with the Project Name and Project Manager i get the same name for both when i tried your report. But with the result of number of tasks you are right i got the tasks now correctly my mistake. I think it has something todo with that table Thanks Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 17, 2020 Share Posted January 17, 2020 @Nikolaj if you run the report is the correct data shown? i have seen the same in the data preview, but the correct data is shown in the project name when the report runs (PDF, CSV etc)? Link to comment Share on other sites More sharing options...
Nikolaj Posted January 17, 2020 Author Share Posted January 17, 2020 @Steven Boardman you are right it is just in the data preview. I never run the report because of the data preview. Many thanks can i modify the query that i see all tasks with due date between this month? Thanks Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 17, 2020 Share Posted January 17, 2020 @Nikolaj sure just go into the report config - Select Filter and choose the Due Date between filter If it is between two date periods, leave the Value is between setting (change this to greater than or less than if you are looking for due dates before or after a variable, i.e due date before end of yesterday). But if it is for the current month - then delete the two values (start of Yesterday and end of yesterday) and add new values (always two if you are dong a Value is Between filter), and use the variable picker to choose Start of Month and End of Month for example. if you are dong a greater than or less than then you only need one value to evaluate against. Remember you also have the Save As option with the reports, so you can create various different versions of the report if needed. 1 Link to comment Share on other sites More sharing options...
Nikolaj Posted January 17, 2020 Author Share Posted January 17, 2020 @Steven Boardman great thanks. One last question the Task Owner is mot always the Task assigne and when i add the task assigne then i get a view like this but i would like to see just the name here for example: gillumc Thanks very much Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 17, 2020 Share Posted January 17, 2020 @Nikolaj i am sure there is a better way to do this (but it's late on a Friday evening) Report definition attached project-tasks---assignee-id.report.txt 1 Link to comment Share on other sites More sharing options...
Nikolaj Posted January 20, 2020 Author Share Posted January 20, 2020 @Steven Boardman this is great thank you very much for your support. Just One Question can i send you my results via email because of the data from the users? I ask because there you can see as i mention in an other topic here that there are still tasks inside who not existing any more in the ui. Maybe that helps your developer to find the problem. Best regards Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 20, 2020 Share Posted January 20, 2020 @Nikolaj probably best to keep the different discussions on separate forum posts (as not to confuse the two). If you are referring to this post: If you could follow up in the relevant post (if it is not that one above), then the developers will be able to respond too you. Thanks Steve Link to comment Share on other sites More sharing options...
Nikolaj Posted January 20, 2020 Author Share Posted January 20, 2020 @Steven Boardman I think it has something to do with the project roles in one project because what i can see is there are more then 1 project manager in this project and then i get this entry 3 times in the report. Maybe it has nothing to do then with this other topic. I will send you my report then i think you can see what i mean. Thanks Nikolaj Link to comment Share on other sites More sharing options...
Steven Boardman Posted January 20, 2020 Share Posted January 20, 2020 @Nikolaj if you have multiple PM's in a project, the way this report is created with it's joins and filters it will return a line for each PM in the report - hence why you see multiple, i created this report on the assumption that there is only one PM in each report and one of the filters is working on the project member role being PM. Having seen your direct message this confirms it to be the case. * If you only have one PM per project then the existing report will only contain one line per project task * You can tweak the report to remove the PM column and joins to the project members table which will again result in one line per project task (minus the PM column being displayed in the report of course). Whilst happy to assist on the forum posts, and with the above hopefully giving you a couple of options to try, there is also the route open to you of engaging with our customer success team and expert services, where the team can work with you on specific requirements and nuances you may have. 1 Link to comment Share on other sites More sharing options...
Nikolaj Posted January 20, 2020 Author Share Posted January 20, 2020 @Steven Boardman again thank you very much for your support and the report. * If you only have one PM per project then the existing report will only contain one line per project task This should be the normal way for us * You can tweak the report to remove the PM column and joins to the project members table which will again result in one line per project task (minus the PM column being displayed in the report of course). this is absolute fine for me thanks Steven. Best regards Nikolaj Link to comment Share on other sites More sharing options...
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