Monday, March 12, 2012

Paging problems

Hi
I am consistently having problems getting paging to work in the report
viewer. I just do a simple query with multiple columns output with
more rows than that will fit in a simple page and setup the report
using the report wizard. I run the report in report manager and all
rows in the table are listed as one huge page.
I have had this problem a lot only in 2005 reporting services. I found
out about the interactive size property and it is set to the report
page size which is 8.5 x 11. So, I dont really understand why the
paging wouldnt work.
Since the result has around 15000 records, the whole thing renders in
one shot and IE literally takes over my computer.
Please help.
ThanksHi,
Check two things.
a. Is your width of the report is not bigger than the width of the report.
b. Go to "View code" and go last you can see somthing like "Interactive
Height" make it "11in" if it is "0in" or go to report layout and after the
dots, any emty space right click and properties change the interactive
height to 11in.
second thing is you said you have done it. but try changing the code and see
it should work and it was working for me on a sameple report which is about
10000 rows.
Amarnath
"Sathya" wrote:
> Hi
> I am consistently having problems getting paging to work in the report
> viewer. I just do a simple query with multiple columns output with
> more rows than that will fit in a simple page and setup the report
> using the report wizard. I run the report in report manager and all
> rows in the table are listed as one huge page.
> I have had this problem a lot only in 2005 reporting services. I found
> out about the interactive size property and it is set to the report
> page size which is 8.5 x 11. So, I dont really understand why the
> paging wouldnt work.
> Since the result has around 15000 records, the whole thing renders in
> one shot and IE literally takes over my computer.
> Please help.
> Thanks
>

No comments:

Post a Comment