Advertisement.

TransHimalaya.in

Everest Helicopter Tour for a day

Book exciting packages at www.transhimalaya.in

Crystal report; Combining rows of data into a single value

Crystal report; Combining rows of data into a single value or

Concatenate Column Values from Multiple Rows into a Single Column

I have two field like this

field1  field2
1         a@xyz.com
2        b@xyz.com
3         c@xyz.com
4         d@xyz.com


I wanted output like:
a@xyz.com , b@xyz.com, c@xyz.com, d@xyz.com


Solution

In Report header put a formula @initializeVar which will work as global variable:


WhilePrintingRecords;
StringVar Conc_emailID := "";

In Group Header or Detail Section (Wherever u want) put a formula @updateVar to concatenate the cell value of each row:


WhilePrintingRecords;
StringVar Conc_emailID := Conc_emailID + {tablename.field2}+ ',' ;

In Report Footer finally access the concatenated value from variable by putting a formula field @showVar :


WhilePrintingRecords;
StringVar Conc_emailID;


It will give you the desired output.
- Vinod Kotiya





Comments

Praful Parmar said…
hello please give me correct solution
- this is work with group but i have not group in report

Most Viewed Post

solution for facebook static.ak.fbcdn.net waiting

Connect Sony XPLOD MEX-BT2500 Bluetooth CD Receiver with ur mobile

Crystal Report : Show data horizontally (Left to right) i.e. columns as rows

Google+ Followers