sql server reporting services: Hello,

Is there a way in SQL RS 2000 to restrict the # of rows in a table per
page basis.

for Eg: i have a query which returns abt 2000 rows, i want to display
only 10 rows per page.

Appreciate if some one can lookinto this and let me know .


Thanks & Have a gr8 weekend!!...
--Venkat

One way to do it is to force a group using a group expression that evaluates
the current row number such that it's a multiple of the number of rows per
page.

Another is to do it server side by using a stored procedure and either
passing the number of rows per page in as a parameter or hard-coding it in
the proc then having the proc provide a "value" that evaluates as a group
break on the report.

-Tim
[quoted text, click to view]

Tim,

Thank you for the solution, it worked for me..

Also is there a way to print in the following format
(my query results :)

ORDER_ID, ITEM_ID, NAME, ADDRESS, ZIP
I001, 1,John, 1 E farmrd, 00282
I001,2,John, 1 E farmrd, 00282
I001,3,John, 1 E farmrd, 00282
I002, 1,KING, 839 E STREET, 83483
I002, 2,KING, 839 E STREET, 83483
I002, 3,KING, 839 E STREET, 83483
I003, 1,Don, 666 N Ave, 8484
I003, 2,Don, 666 N Ave, 8484

the format i need is:

I need to print only 2 orders per page
eg: for page 1 & 2 for the above results would be
************PAGE 1***********
Name: John
Address:1 E farmrd
ZIP: 00282
Order ID, ItemID
I001, 1
I001, 2
I001, 3
------------------------------
Name:KING
Address:839 E STREET
ZIP:83483
Order ID, ItemID
I002, 1
I002, 2
I002, 3
***********END PAGE 1********

************PAGE 2***********
Name: Don
Address:666 N Ave
ZIP: 8484
Order ID, ItemID
I001, 1
I001, 2
I001, 3
------------------------------

***********END PAGE 2********
Hope i am clear with my requirement..

Imagine my page would be of labels (8.5 * 11)/2 each.

Is this possible!!....

Thanks for any help extended to me .

-Venkat

[quoted text, click to view]