InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 16:48:52 GMT20http://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxThanks H4K, Exactly what i neededTue, 16 Apr 2013 09:36:13 GMTConfickerhttp://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxThank You very Mucj it is working fineSun, 03 Feb 2013 00:45:12 GMTskgudi2009http://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxWhen you create a group, select 'Add group header' to add a header to the group. Now a header is added as well as a column. Delete the column by selecting the column, right click, select 'delete columns'.Create another group header by right clicking on the row group header created and selecting insert row -> above.In the first row group header, add the field with 'agents' in your case.In 2nd row group header, add column titles.Mon, 28 Jan 2013 06:39:37 GMTH4Khttp://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxThis is the report i required with Fieldnames as No,Name and Balance with group as agentAgent 1No Name balance1 Ramesh 10002 Suresh 20003 Rajesh 1000 Total 4000Agent 2No Name balance4 Veeresh 20005 Maltesh 30006 Amit 4000 Total 9000 Grand total 13000But when i add agent as group Report is displaying like thismeans Agent,No.Name and BalanceAgent No Name balance1 1 Ramesh 1000 2 Suresh 2000 3 Rajesh 1000 Total 4000Agent No Name balance2 4 Veeresh 2000 5 Maltesh 3000 6 Amit 4000 Total 9000 Grand total 13000is it posible Fri, 25 Jan 2013 20:39:35 GMTskgudi2009http://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxThank u but my problemi is i want to display the report like thisAgent 1No Name balance1 Ramesh 10002 Suresh 20003 Rajesh 1000 Total 4000Agent 2No Name balance4 Veeresh 20005 Maltesh 30006 Amit 4000 Total 9000 Grand total 13000But after adding group it is displaying like this i.e 1 extra column is addingAgent1 No Name balance 1 Ramesh 1000 2 Suresh 2000 3 Rajesh 1000 Total 4000Agent2 No Name balance 4 Veeresh 2000 5 Maltesh 3000 6 Amit 4000 Total 9000 Grand total 13000How to solve this problemFri, 25 Jan 2013 04:50:42 GMTskgudi2009http://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxWhen creating a group you have a option of selecting, whether you need a header and footer for that group.If the groups are already created then select any textbox in the row you don't want and right click and select 'Delete Rows' option.Fri, 25 Jan 2013 00:23:13 GMTH4Khttp://www.sqlservercentral.com/Forums/Topic1411446-150-1.aspxI have add multiple goups in ssrs 2008 r2.My problem is when i try to add a group 1 extra column is adding for that group but i dont want the column in the top of the table it should add.Ex.There are 5 agents and I have to display individual agentwise total so i want group it by agentid when i adding group 1 extra column is adding.Can u please help me.Thu, 24 Jan 2013 20:43:13 GMTskgudi2009