SSRS 2008R2 GROUPING

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » SSRS 2008R2 GROUPING

SSRS 2008R2 GROUPING

Rate Topic

Display Mode

Topic Options

Author

Message

skgudi2009

Posted Thursday, January 24, 2013 8:43 PM

Grasshopper

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

H4K

Posted Friday, January 25, 2013 12:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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

skgudi2009

Posted Friday, January 25, 2013 4:50 AM

Grasshopper

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

skgudi2009

Posted Friday, January 25, 2013 8:39 PM

Grasshopper

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

H4K

Posted Monday, January 28, 2013 6:39 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 4:11 AM
Points: 127, Visits: 507

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

skgudi2009

Posted Sunday, February 03, 2013 12:45 AM

Grasshopper

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

Conficker

Posted Tuesday, April 16, 2013 9:36 AM

Valued Member

Group: General Forum Members
Last Login: Friday, April 19, 2013 5:36 AM
Points: 58, Visits: 243

Thanks H4K, Exactly what i needed

Post #1442813

« Prev Topic | Next Topic »

Permissions