Report koristi query za recordsource, nešto kao:
Code:
SELECT TOP 50 tblRacuni.SIFRA, SUM(tblRacuni.KOLICINA)
FROM tblRacuni
GROUP BY tblRacuni.SIFRA
ORDER BY SUM(tblRacuni.KOLICINA) DESC
SELECT TOP 50 tblRacuni.SIFRA, SUM(tblRacuni.KOLICINA)
FROM tblRacuni
GROUP BY tblRacuni.SIFRA
ORDER BY SUM(tblRacuni.KOLICINA) DESC
Kako izvesti da korisnik može da bira TOP vrednost (na pr 1, 30, 115...) u zavisnosti šta ga u datom trenutku interesuje?