CountDistinct

[uniformity]

On one of our reports I'm having some issues getting an element to display properly for me. The report displays our products and some products have only one size, others have up to 5 sizes. So when this displays in a group band it can be as small as 1 row or up to 5 rows.

What I'm trying to do is use CountDistinct to determine the location of an element on the report, if there's 5 rows the space will be larger so the image can be moved down, if there's only 1 row the space is smaller and the image needs to be moved higher.

if CountDistinct(objectsize) = 5
image.top = x
if CountDistinct(objectsize) = 3
image.top = y
etc...

I am able to get the correct value to display by placing a textbox in the footer and using CountDistinct for its text, but I can't seem to find a way to use that value (either the CountDistinct(objectsize) value or the textboxt.text value) to determine the images placement.

Thanks!

[Alex K.]

Hello,

Could you send us a simple report which shows your issue for analysis.

Thank you.