Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Crystal Report formatting

I need help to format a result in CR to be presented in an easier way to read with one output line.
The query returns data formatted like this :

Springsteen      Bruce       1486      880249      Descript1
Springsteen      Bruce       1486      880249      Descript2
Springsteen      Bruce       1486      880249      Descript3
Springsteen      Bruce       1486      880249      Descript4
Springsteen      Bruce       1486      880249      Descript5
Springsteen      Bruce       1486      880249      Descript6
Stuart            Dave      2225      934468      Descript1
Stuart            Dave      2225      934468      Descript10
Stuart            Dave      2225      934468      Descript15
Stuart            Dave      2225      934468      Descript16


But in CR i would like the output to be presented like ;
Springsteen      Bruce       1486      880249      Descript1,Descript2,Descript3,Descript4,Descript5,Descript6
Stuart            Dave      2225      934468      Descript1,Descript10,Descript15,Descript16


Any suggestions how to solve this ?
0
XMine
Asked:
XMine
1 Solution
 
peter57rCommented:
You have to use a set of formula fields to build the string, and use a structure which groups on all the common value fields.

See the example attached.
lists.rpt
0
 
XMineAuthor Commented:
Thanks alot. That solved my problem 100%..
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now