Timesheet Report

[Legacy User]

I am looking for report that I can select a time period and see the missing timesheets.

The missing time sheet report will only let me select one time period - how can I select multiple time periods - Basically the Timesheets link let's me select multiple OBS units, multiple timesheet status and what date range I want. So I can see who in IT hasn't submitted timesheets for a certain month.

Has anyone done this with the existing reports/portlets in Clarity or has any guidance for how they run this in their organization

[Anon Anon]

Hi,

As you have not mentioned which reporting tool,so i assume that is actuate which we are also using.From actuate 9 version you can also choose
multiple selection parameters,so when you create an parameter for choosing the Time period (Look up - Type) where an nsql query is written to show all the time periods.when user choose an multiple parameters the internal id of the time periods chosen will be passed in to the sql procedure.i have enclosed the snapshots for your reference.

cheers,
sundar

Attachment(s)

Actuate Choosing Multiple Parameters.zip   53 KB 1 version

[Ruthann Spencer]

We solved this issue with a custom report in Actuate.

We can run it at any level of the OBS and for a specific date range because it goes off of the timeslices rather than the time reporting periods. It tells us the following data:

Sr. Manager of the Resource
Manager of the Resource
Resource's Name
Resource's ID
Date range of timesheet - then a status' of Unsubmitted or Not Approved
The Resource's email address

[Legacy User]

It is looking like I have to write a custom report but I am not on Actuate - I am on Business Objects.

[Slovak]

We use Webi BO reports with Crystal Reports. This allows us to search the entire universe for just about any object we need to report on, including time sheets.