help in using rnd function

[reacha]

In my report i have group on Username,auditstamp,pkgid

when i group by username under that i may get 5 or 6 dates and after that there is a group by pkgid.

I need to get two random pkgid's for each user with the respective dates


Please help me out its very urgent

Thanks,
reacha

 

[briangriffin]

Hide the details section, then insert formula {@Random} in the pkg_id group header:

Rnd(1)

Then place a max of that formula in the group footer. Since there will only be one record per group the max would be the same as the min, avg, etc.

Under Report: Group Sort Expert, create a Top N for the group PkgID using the field max of {@Random}. Set N = 2 and uncheck Include Others.

This will give you two random pkg ID's for each of the date groups - not sure if that's exactly what you want, but it should be easy to tweak it from there.