how to set number of rows per page in Report Viewer

Question

0.00/5 (No votes)

See more:

VS2008

Hi All,

Im using Visual studio 2008 .How can i set number of rows to 50 or 100 to be displayed per page in rdlc reportviewer.

Thanks in advance

Posted 25-Oct-12 14:03pm

DepiyaReddy

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh Kariyavula · Answer 1 · 2012-10-25T18:10:00

Solution 1

To do this, create a group in a data region, add a page break to the group, and then add a group expression to group by a specified number of rows.

The below expression, when set as the group expression, assigns a number to each set of 50 rows. When a page break is defined for the group, this expression results in a page break every 50 rows.

VB

=Int((RowNumber(Nothing)-1)/50)

For more details refer the link below :

Report Expressions[^]

Hope this helps.

Posted 25-Oct-12 18:10pm

Rajesh Kariyavula

Updated 25-Oct-12 18:17pm

v2

Comments

DepiyaReddy 28-Oct-12 20:56pm

Hi ,I tried the expression suggested by you,its working for 5,10 or 20 rows but not above than that(not working for 30 or 50 rows).I have 78 records but.what would be the reason?

Rajesh Kariyavula 29-Oct-12 0:03am

Please check the Page Size that you are using and the number of records it fits in each page

DepiyaReddy 29-Oct-12 23:02pm

Group expression works by changing the InteractiveHeight but when exporting to excel,i can only see 1st page rows .But without giving the group expression and by only changing the InteractiveHeight to 165 cm ,i can see 200 rows per page and which also displays all rows when exported with excel which is good.