Last post Jan 16, 2015 04:23 AM by Edwin Guru Singh
Jan 13, 2015 06:48 AM|advensql|LINK
I have a crystal reports with grouping in department_name. Report is working fine but I need 2 department_name in combined with the total of their respective values.
For example: If the department_name=A and total values of Department A=800 or / and department_name=B and total values of Department B=200 then I need the output as
AB = 1000
Total Value may vary but department_name is fixed.
All other group values accept department A & B should be displayed separately.
Please help to do so
Jan 16, 2015 04:23 AM|Edwin Guru Singh|LINK
As per your case, I have been shared my suggestion below:
1. You can make it combine the columns when you retrieve the data from database/Stored Procedure or datatable to crystal report.
Select department_name, Department, (department_name+Department) as Dept_Group from tablename
2. In the crystal Report ,you can make group & subgroup very easily like below :
Hopefully this will be helpful for you.