none
report builder 3 rowcount as parameter question RRS feed

  • Question

  • Hello

    I wrote a query using set rowcount to limit the return rows to 10 which worked fine.

    I used the query to create a report in report builder and changed the value of rowcount from the hardcoded 10 to a parameter with report builder accepted, but when I enter a number for the parameter, for example 10, I get back 8 rows instead of 10 rows.

    Any suggestions would be appreciated.

    Thank you 

    Wednesday, January 16, 2019 3:59 PM

All replies

  • Hi Chucky99

    According to your description , I test it and seems it works fine. I could not reproduce your issue.

    Check if you have page break for your Tablix , and the left 2 rows are in the next page or not .

    If possible , could you please offer the detailed query or the whole rdl file  to us for more further research.

    Hoping for your reply.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread.

    • Proposed as answer by Eric Liu001 Tuesday, January 22, 2019 6:06 AM
    Thursday, January 17, 2019 5:42 AM