Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

How do I create a report that gets me "all projects that have hours entered in the current year" ?

Avatar

Level 3

To be clear I need a report that lists projects - it's for export elsewhere; I *could* use an hours report but that means exporting a whole lot of data only to delete it (I don't need the hours entries, just the list of projects)

I see the filter field "All Hours" >> Entry Date = This year and at a quick glance that seems to work - but would love confirmation.

Hit me up!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10

Hi @sven Niemetz‚

You are right, just use Hour report.

Tried to create similar instance. Please refer the attachment.

0694X00000C1e7BQAR.jpg0694X00000C1e71QAB.jpg0694X00000C1e7GQAR.jpgHope this will help.

Regards,

Kundan

Avatar

Level 3

Hi Kundan - thanks for replying!

I set up report as you did - and field Project:Name is always blank (No value)

But the main issue is that even using a matrix report I get 20000 rows of hour records.

I'm trying to get a report similar to

"select project.name where in in ( select project.id from hours where entrydate is last year )"