Displaying results in Ad-hoc reports using report builder

Question

I have created a model in order to generate the adhoc reports using SQL server report builder.using the report builder I have designed my own report with the model and ran the report.
Following is my issue:
At present my requirement is to display all the part types that exists in the database for an activity.At the back end the query is working properly(I'm getting all the parttypes for each activity.It is returning 187 rows).But while generating the report at the front end I'm getting only the first parttype for that perticular activity though there are many.So at the back end my result set is around 187 rows where as at front end my result set is only 31 rows.Please help me if you have any idea why backend is giving correct results where as at front end the results are like that.

John Penn · Answer

Did you try setting AsyncRendering=false?

Archana Nandyala · Answer

In front it is displaying only 31 rows and all these rows are in one page. And there are no other pages at all.

John Penn · Answer

If you need AsyncRendering=true an alternative is to set InteractiveSize property to have a height of 0. That will force the report to be rendered as one page. Keep in mind that this can cause the browser to use up a lot of memory if the report is large...

John Penn · Answer

ReportViewer by default will split the report into pages. You can either (a) display the report toolbar which will include previous/next page buttons or (b) set the AsyncRendering property of the ReportViewer to false.