Issue with returned data on report pulling from CAB board

[Adrian Simpkins]

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!

 

[Adrian Simpkins]

Bump

 

[Bob Dickinson]

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

[Adrian Simpkins]

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

[Bob Dickinson]

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

[Adrian Simpkins]

Thanks Bob, I will give this a go and let you know if its resolved

Many thanks as always !

[Adrian Simpkins]

Hi Bob

Just to confirm this worked perfectly, thank you for the pointer

Many thanks !