Post reply

PageSize

  • March 1, 2009 at 1:54 am

    #126741

    I am making a very simple DetailView of my data and need it to show 2 records per page instead of 10. I select the DetailView but can't seem to locate the PageSize property. Any ideas on where it might be. BTW, paging is enabled. I fear that I might have something else wrong within my configurations. Does anybody know what could cause this? Thanks in advance!

  • March 1, 2009 at 5:35 am

    #951585

    Are you talking about reporting services? Something else?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 2, 2009 at 9:50 am

    #951944

    you actually cannot do this with SQL Server.

    Only mySQL supports the limit keyword, like LIMIT 1,2 would show you two records LIMIT 3,4 would show you records 3 and 4.

    one of these days, MS will realize that the LIMIT keyword is probably one of the most popular statements in mySQL, and they really should learn to adopt it directly.

  • March 2, 2009 at 10:05 am

    #951954

    Are you talking about paging? There are articles on this site dealing with that.

    http://www.sqlservercentral.com/articles/Advanced+Querying/3181/

  • March 2, 2009 at 10:16 am

    #951961

    Thanks all who replied. And thanks for the site!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply