[Progresso] Behaviour entry comments in SSRS Reports

[NotSoFast]

I've got a report we use to pull a list of behaviour entries which have detentions as the consequence. It's always had duplicate rows, and I've finally got round to fixing it, but I have one remaining issue. The field which causes the duplicate rows is "Comment", and duplicates are created even when there is only a single comment associated with the Behaviour Entry ID. I wanted to try using a lookup expression to pull the comment, rather than getting it in the same dataset as the other Behaviour Entries info, but within Behaviour Comment there is no Behaviour Entry ID to use as a key.

 

Has anyone got any suggestions for how I can sort this? Thanks in advance!

[carwardinet]

So have you created a new dataset for Behaviour Comment? To then use LOOKUP as an expression?

 

If so, can you add the 'Behaviour Entry ID' field from the 'Behaviour Entry' entity and then the 'Comment' field from the 'Behaviour Comment' entity? And then LOOKUP the two 'Behaviour Entry ID' fields?

[NotSoFast]

That's how I was going to approach it, but the the comment "table" (for want of a better word) doesn't have Behaviour entry ID within it, so there's no common field.

[carwardinet]

You should be able to add Behaviour Entry ID from the Behaviour Entry entity then the comment from the comment entry below it?

[NotSoFast]

Doh! This is what happens when you don't use something for a few months! Thank you!