How do I create a report that gets me "all projects that have hours entered in the current year" ? | Community
Skip to main content
S
SvenNiemetz
Level 2
February 10, 2021
Question

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

  • February 10, 2021
  • 1 reply
  • 504 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Kundanism
Kundanism
Level 10
February 10, 2021

Hi @sven Niemetz‚

You are right, just use Hour report.

Tried to create similar instance. Please refer the attachment.

Hope this will help.

Regards,

Kundan

S
SvenNiemetzAuthor
Level 2
February 12, 2021

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 )"

Terms & ConditionsAccessibility statement

Loading footer...