Adrian Simpkins Posted October 30, 2020 Share Posted October 30, 2020 Hi All, We are trying to setup a report which shows the current card items in 2 lanes on our CAB board (Emergency Changes, and With CAB lanes). However, when we run the report it is returning data showing any request that has been in either of these 2 lanes, rather than what is currently in the lane. I presume we can output what is currently in the lane rather than anything that was in the lane? Many thanks as always! Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 4, 2020 Author Share Posted November 4, 2020 Bump Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 5, 2020 Share Posted November 5, 2020 Hi@Adrian Simpkins Are you creating your report through the Hornbill Reporting functionality? If so you could you export your report and provide it to us so we can take a quick look at the set up? Kind Regards Bob 1 Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 5, 2020 Author Share Posted November 5, 2020 Hi Bob, yes we are creating the report on the backend functionality. I have attached the downloaded file to check - many thanks !change-management---cab-agenda.report.txt Link to comment Share on other sites More sharing options...
Bob Dickinson Posted November 5, 2020 Share Posted November 5, 2020 HI @Adrian Simpkins It looks like this was just a small issue with your Join criteria. The Board Cards and Board Lanes tables were being joined on the Board ID when in fact they needed to be joined on the Lane ID. I've just made a small tweak and it seems to work on my instance - do you want to upload this updated version on to yours, and let me know if this now works for you? change-management---cab-agenda-updated.report.txt Thanks Bob 1 Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 6, 2020 Author Share Posted November 6, 2020 Thanks Bob, I will give this a go and let you know if its resolved Many thanks as always ! Link to comment Share on other sites More sharing options...
Adrian Simpkins Posted November 6, 2020 Author Share Posted November 6, 2020 Hi Bob Just to confirm this worked perfectly, thank you for the pointer Many thanks ! 1 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