locked
Combining group in crystal report RRS feed

  • Question

  • User-1155576298 posted

    Hi friends

    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

    Tuesday, January 13, 2015 6:48 AM

All replies

  • User1711366110 posted

    Hi advensql,
       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.
        Example :
           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 :
        Example:
             Dept_Group
                    -->department_name
                                 -->Department

    Hopefully this will be helpful for you.
    --
    with regards,
    Edwin

    Friday, January 16, 2015 4:23 AM