Ceiling not working properly in SSRS Report

Question

Used below expression to show only 50 Rows per page.

=Ceiling(RowNumber(Nothing)/50)

But still it shows only 42 rows per page. Crystal report shows perfectly fine but SSRS report doesn't.

Please help me to solve my problem!

score 0 · Answer 1 · answered May 03 '16 at 11:05

0

Presumably this is within Visual Studio at the moment?

Delete the report_name.data file so that the report is not cached.

answered May 03 '16 at 11:05

BIDeveloper

Yes, m using VS. But where can I find this file. As I am directly calling this report from my report server. – Pedram May 03 '16 at 11:17
1. How? 2. While answering that can you also delete the .data file from the same location as your .rdl file on (probably) your local PC. – BIDeveloper May 03 '16 at 11:49
1. By making report server url I am accessing it from report viewer to show. 2. I don't think it will saved to my pc. – Pedram May 03 '16 at 12:01
Nope. accessing local report. – Pedram May 03 '16 at 13:10
Tell me the path that you are opening the rdl from. – BIDeveloper May 03 '16 at 13:14
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/110958/discussion-between-pedram-and-bideveloper). – Pedram May 04 '16 at 07:11

score 0 · Answer 2 · edited May 04 '16 at 04:51

0

Set the “BreakLocation” to “End” and set the “Disable” property to the expression below:

=IIf(RowNumber(Nothing) Mod 50 = 0, False, True)

edited May 04 '16 at 04:51

Pedram

answered May 03 '16 at 16:10

StevenWhite

now it shows 45 rows instead of 42. also let me tell you one more thing, when I use 40 instead of 50 it works perfectly fine so I checked my design part but it seems to correct. I have used SizeToReportContent = true. – Pedram May 04 '16 at 04:21
also when go to next page is show other 5 records, so 45 + 5 and then 3rd page with 46 rows and 4th page with 4 rows. :( – Pedram May 04 '16 at 04:29
@pedram You're getting actual page breaks confused with pages in the report viewer. If you export this to Word or Excel, the page breaks will occur every 50 lines. If they don't fit on the page, that's a separate issue. – StevenWhite May 04 '16 at 16:09

score 0 · Accepted Answer · answered May 04 '16 at 05:21

0

I found the solution from here,

Need to set the Interactive Height property of the report to zero as shown below.

answered May 04 '16 at 05:21

Pedram

I was not able to find out the issue after using `Ceiling` - if it is not correct then let me know if I need to change my subject... I will change – Pedram May 04 '16 at 07:24
@pedram Glad this helped you. Just to clarify; this removes the paging in the report viewer, but would have no effect on an exported version of the report. – StevenWhite May 04 '16 at 16:14
I have checked now, it shows paging perfectly. but while exporting to pdf it breaks the page. – Pedram May 05 '16 at 04:56

3 Answers3