BobbyB Posted March 16, 2021 Share Posted March 16, 2021 Hello, I need to pull off Timesheet entries but need to view details of any linked requests. When I tried to Join Requests with Timesheet Categories I didn't see any related fields to join. My current Timesheet report has Timesheet Categories joined with Timesheet Values but I also need info from the Requests table. Is there anyway to do this? Many thanks, Bobby @Alisha Link to comment Share on other sites More sharing options...
Alberto M Posted March 16, 2021 Share Posted March 16, 2021 @BobbyB, I got the requests joined to categories through the timesheet values table. Joining the requests table with the timesheet values table and then joining the timesheet values with the categories. Will this be useful for you? 1 Link to comment Share on other sites More sharing options...
BobbyB Posted March 16, 2021 Author Share Posted March 16, 2021 Thanks @Alberto M, but every time I try to add in the requests table it puts in a project table....very annoying...... or If I put in Requests as the first table it won't show any 'Join' actions.... Unsure why it's doing this... Thanks, Bobby @Alisha Link to comment Share on other sites More sharing options...
Alberto M Posted March 16, 2021 Share Posted March 16, 2021 @BobbyB, I'm not sure if this have any impact, but I've designed the reports in the Timesheet app. Are you doing the same? Link to comment Share on other sites More sharing options...
BobbyB Posted March 16, 2021 Author Share Posted March 16, 2021 Thanks @Alberto M, I've managed now to get it working with Requests at the beginning by using your joins, thanks again for your help Bobby @Alisha 1 Link to comment Share on other sites More sharing options...
Alberto M Posted March 16, 2021 Share Posted March 16, 2021 @BobbyB, glad to help Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now