Limiting results in Report Viewer 08?

Question

Is there any way to limit the result set in the report viewer?     There is a function GetPageTotal() but since the report viewer is inside an Iframe it is difficult to get at.

Thanks,

Mike

Answer 1

I believe you need to write a custom code to do something like this.
Or
You can try to use Parameter, create a parameter list 10, 20,  30, 40 >>> 100 Then assign this parameter value to your SQL Statement Select Top 100 replace it with Select Top @myParameter, I think this should work .

---

John