One lamppost from each street

[djieon]

Hi all,

I have a report that has the following:-

Group header 1 - @random (based on the random formula)

Group header 2 - Street name

Details - Lamppost

what I want to achieve is 40 random lamp posts but only 1 lamppost from each street, however currently I am getting 40 random lampposts but I am getting more than 1 in a street.

Am I doing this wrong?

Thanks in advance.

David.

 

[Charliy]

I think you may have your groups in the wrong order. Group by street, then select a random lamppost on that street. You may neet a second formula to select random streets.

 

[IdoMillet]

See my FAQ on this at: faq767-3260

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com