Skip to Content
avatar image
Former Member

Problem related to Data showing in Crystal reports

Hello, I'm working on CR9 designer and new to this, I'm working on problem that is related to formating of data on CRs.

My report is assiciated with a database with table customer info.

It has following fields: Customer first name, Customer Second name and State.

Inside my report, data is Grouped by State field and sorted on customer first name.

Now my problem is: I want to show data in mentioned format: (Customer First Name space Customer last name), (Customer First Name space Customer last name).

e.g., in front of Group Header only, I want to show this concatenated details for all customers those would fall under that Group.

e.g., I do have 2 states state1 and state2. And four customers in total. Data is something like this: (CF1, CL1, state1), (CF2, CL2, state1), (CF3, CL3, state3), (CF4, CL4, state4)

Now i want my output in report as:

State1 (CF1 CL1), (CF2 CL2)

State2 (CF3 CL3), CF4 CL4)

Thats is group header(state level) data should be able to retrive all its customer's first and last name and should format in desired format mentioned abve. Can you please help how can I do it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 06:11 AM


    I'd love to give you the answer but I'd only be plagiarizing. Raghavendra gives an outstanding explanation of how to do exactly what you are trying to do.

    Check this out:

    Hope this helps,


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      OK, My these two problmes are also solved by changing DisplayFormula, that will elimilate all spaces and braces from End.

      Thanks a lot for helping out in resolving this issue...It works perfectly for me 😊