March 1, 2009 at 1:54 am
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
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
March 2, 2009 at 9:50 am
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
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
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