Hi
 is every know a good way to select/display every N row in CR9.
thanks

excuse me but I didnt get ur every N row means?!

Always:),
Hovik Melkomian.

Hi
 Sorry, didn¡¯t make myself clear.
We have a project to build a web based CR reporting tool (VB.Net and CR9). We are using the ¡°Pull method¡± which means the data will retrieved by CR9 but not VB.net code.
Our database is based on time which collects rows for every minute. However, we hope that CR can display date for every ¡°N¡± rows (such as, for every 5, 10, 30 minutes). The ¡°N¡± will be a parameter field which passed in from VB.NET.
Is there good way to do that in CR?
Thanks!

Still I didnt get but make ur SELECT (SP recomended) & then set ur parameter & get ur wished data to display & ...

HTH.


Always:),
Hovik Melkomian.

hi
friend
here is a query for ur reply
try to execute this u definitley get the solution

SELECT *
FROM emp
WHERE (ROWID,0) IN (SELECT ROWID, MOD(ROWNUM,&rownumber)
                        FROM emp)


Note : where rownum is the number of the row u want to select