none
Limiting results in Report Viewer 08? RRS feed

  • 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
    Thursday, November 5, 2009 10:50 PM

All replies

  • 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
    • Proposed as answer by Codernater Tuesday, November 10, 2009 2:06 AM
    Friday, November 6, 2009 3:37 PM