Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008R2 GROUPING Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 8:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
I 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.
Post #1411446
Posted Friday, January 25, 2013 12:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
When 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.


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1411498
Posted Friday, January 25, 2013 4:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
Thank u but my problemi is i want to display the report like this

Agent 1

No Name balance
1 Ramesh 1000
2 Suresh 2000
3 Rajesh 1000
Total 4000

Agent 2

No Name balance
4 Veeresh 2000
5 Maltesh 3000
6 Amit 4000
Total 9000
Grand total 13000

But after adding group it is displaying like this i.e 1 extra column is adding


Agent1 No Name balance
1 Ramesh 1000
2 Suresh 2000
3 Rajesh 1000
Total 4000

Agent2 No Name balance
4 Veeresh 2000
5 Maltesh 3000
6 Amit 4000
Total 9000
Grand total 13000
How to solve this problem


Post #1411609
Posted Friday, January 25, 2013 8:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112



This is the report i required with Fieldnames as No,Name and Balance
with group as agent

Agent 1
No Name balance
1 Ramesh 1000
2 Suresh 2000
3 Rajesh 1000
Total 4000
Agent 2
No Name balance
4 Veeresh 2000
5 Maltesh 3000
6 Amit 4000
Total 9000
Grand total 13000

But when i add agent as group Report is displaying like this
means Agent,No.Name and Balance

Agent No Name balance
1
1 Ramesh 1000
2 Suresh 2000
3 Rajesh 1000
Total 4000
Agent No Name balance
2
4 Veeresh 2000
5 Maltesh 3000
6 Amit 4000
Total 9000
Grand total 13000

is it posible


Post #1411972
Posted Monday, January 28, 2013 6:39 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 7, 2014 2:21 PM
Points: 132, Visits: 557
When 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.


BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI
Post #1412402
Posted Sunday, February 3, 2013 12:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 9:49 AM
Points: 16, Visits: 112
Thank You very Mucj it is working fine
Post #1414985
Posted Tuesday, April 16, 2013 9:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 4:20 AM
Points: 69, Visits: 363
Thanks H4K, Exactly what i needed
Post #1442813
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse