InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:48:59 GMT20http://www.sqlservercentral.com/Forums/Topic1395261-392-1.aspxI can't see that what you need is more than this:[code="sql"]--Report 1select Rank, Name, Boardfrom MyTablesort by Rank, Name, Board--Report 2select Board, Name, Rankfrom MyTablesort by Board, Name, Rank[/code]Tue, 11 Dec 2012 13:26:24 GMTtoddasdhttp://www.sqlservercentral.com/Forums/Topic1395261-392-1.aspxWhy would anyone open a file from, someone they do not know? Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Learn to use ISO-11179 data element naming conventions and formatting rules. RANK is a reserved word! Temporal data should use ISO-8601 formats. Code should be in Standard SQL as much as possible and not local dialect. This is minimal polite behavior on SQL forums. Your posting picture is both rude and useless. Where is any effort you already made?What aggregates do you want to do on this data? We never format data for display in the database; remember what a tiered architecture means?Tue, 11 Dec 2012 13:03:55 GMTCELKOhttp://www.sqlservercentral.com/Forums/Topic1395261-392-1.aspxHi AllFollowing is my table structure with the data. I just cant work out the query to group the data by Rank & Board. I would like to generate 2 queries to do the grouping based on Rank & Board.Please find attached the table structure and the layout of report.I would really appreciate any help or pointers on creating this 2 report.regardsMiteshTue, 11 Dec 2012 11:37:22 GMTMitesh Chauhan