Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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


Level 2

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 help categorize Community content and increase your ability to discover relevant content.

2 Replies


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.




Level 2

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 where in in ( select from hours where entrydate is last year )"