January 24, 2013 at 8:43 pm
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.
January 25, 2013 at 12:23 am
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
January 25, 2013 at 4:50 am
Thank u but my problemi is i want to display the report like this
Agent 1
NoName balance
1Ramesh1000
2Suresh2000
3Rajesh1000
Total4000
Agent 2
NoName balance
4Veeresh 2000
5Maltesh3000
6Amit 4000
Total9000
Grand total13000
But after adding group it is displaying like this i.e 1 extra column is adding
Agent1NoName balance
1 Ramesh1000
2 Suresh2000
3 Rajesh1000
Total 4000
Agent2NoName balance
4 Veeresh 2000
5 Maltesh3000
6 Amit 4000
Total9000
Grand total13000
How to solve this problem
January 25, 2013 at 8:39 pm
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 total13000
But when i add agent as group Report is displaying like this
means Agent,No.Name and Balance
Agent NoName balance
1
1Ramesh1000
2Suresh2000
3Rajesh1000
Total4000
Agent NoNamebalance
2
4Veeresh 2000
5Maltesh3000
6Amit 4000
Total9000
Grand total13000
is it posible
January 28, 2013 at 6:39 am
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
February 3, 2013 at 12:45 am
Thank You very Mucj it is working fine
April 16, 2013 at 9:36 am
Thanks H4K, Exactly what i needed
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply