Jump to content

Help with report - activities as columns and last timeline update


Recommended Posts

Hi There,

I have a need to create a report that a project manager will use to feedback to management. I've created a nice concise progressive capture and business process using custom fields and activities to answer questions at certain stages. That works well. The problem is that I am now struggling to report on it.

Attached is my report output (and an edited version of what I would ideally like to see) as of right now and screenshots of my tables and filters. More info can be provided if needed.

What I am trying to achieve is to have one row per request, and include the last update in the timeline made by a human, the time of that update and to have each activity as a column with the outcome in the row. At the moment I am getting a row for each update and for each activity.

I hope that makes sense.

Is this possible? Is there a better way to achieve what I am trying to do? Or indeed, is there a better way entirely?

Thanks in advance


IT Projects issue log report_937_CN.xlsx



IT Projects issue log report_937_CN-edit.xlsx

Link to comment
Share on other sites

On 8/2/2018 at 1:48 PM, chrisnutt said:

the last human update

The problem getting the last update when is that it requires subqueries as you are retrieving data from two or more tables... and that's simply not possible. You can get a list of all updates, filtered as you wish but it will be all updates of that type...  

Link to comment
Share on other sites

@chrisnutt so, if you need a list of requests and for each of these request you need to only retrieve the latest update, the way you can do this in an SQL query is to parse the requests table and for each parsed request parsed, you need to query the activities table to retrieve only the last update for that request (querying the activities table for the last update would be the subquery). There is no such functionality (i.e. subqueries) in the current reporting engine.

Link to comment
Share on other sites

Thanks, @Victor

I see what you mean now.

You say the current reporting engine. Does this mean there will be a different reporting engine? I am aware that this one is still relatively new. But the ability to get something that I could do with a query would be beneficial.



Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...