InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 11:51:34 GMT20http://www.sqlservercentral.com/Forums/Topic1422408-1633-1.aspxIt's actually not that hard...Step 1. You need your dataset to include a few extra columns[code="sql"];with data as (select GroupName,ArticleNumber,Subject,row_number() over(PARTITION BY GroupName order by ArticleNumber) as rnFROM Articles where Subject <>'')select TOP 200 GroupName, ArticleNumber, Subject, rn, -- used for sorting the output ((rn-1) / 10) %2 as col_no, -- works out which column to put the data into : 0 or 1 (based on page size of 10 - this could /should be a parameter ) ((rn-1) / 10) /2 as page_break -- works out which "page" within the group to put the data on (based on page size of 10 - this could /should be a parameter )from data[/code]Step 2. Create a Tablix report with "GroupName" on the Page section and ArticleNumber and subject on the details section (you can include the other columns for now so you can see it is working, but remove them later for production)Step 3. You now need to tell the report how to paginate, so go into the outermost group properties (you would have an outer grouping called list1_GroupName if you were doing this with my data) and add the dataset column "page_break" to the group expressions so you are grouping by GroupName and page_break.[img]http://www.sqlservercentral.com/Forums/Attachment13236.aspx[/img]Step 4. put a filter on the "detail" tablix so that it only displays where "col_no" = 0[img]http://www.sqlservercentral.com/Forums/Attachment13237.aspx[/img]Step 5. Select any textbox that could expand due to overflow of data and uncheck the "Allow height to increase ?" setting. (otherwise your report will not line up nicely)Step 6. Select the outer Tablix (called List1 if you used the wizard) and make it twice as wide.Step 7. Copy the inner/details Tablix and paste it into List1, then position it right next to existing one (side by side)Step 8. Edit the filter on the new (2nd) details tablix so that it only displays where "col_no" = 1[img]http://www.sqlservercentral.com/Forums/Attachment13238.aspx[/img]Thu, 21 Feb 2013 03:15:03 GMTmister.magoohttp://www.sqlservercentral.com/Forums/Topic1422408-1633-1.aspxi am not a .net guy, you should search in .net forums like codeproject for this .Thu, 21 Feb 2013 00:23:17 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1422408-1633-1.aspxThis what they designed in crystal report. If the column reaches the end on one side the next values is goes to the right side. After ending the page it goes to the new page.Thu, 21 Feb 2013 00:19:13 GMTbaseehkhanhttp://www.sqlservercentral.com/Forums/Topic1422408-1633-1.aspxI think you are talking about [b]pagination[/b] here. this can be done at application and sql server both.search google for "row_number()" Thu, 21 Feb 2013 00:11:58 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1422408-1633-1.aspxHi All, My source is like Id Name 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I 10 J . . . . . .I have display like: ID Name ID Name 1 A 6 F 2 B 7 G 3 C 8 H 4 D 9 I 5 E 10 JAfter end with this page, Values go to the next page.Thanks,BaseeWed, 20 Feb 2013 23:22:32 GMTbaseehkhan