display data in special format

[rb2005]

I have a report which is displaying data like this.
12345myreport 3/23/06

abcd12340o87
njioer1245678
njkio190734
wert09876456
oilsir1234890
asnjoih12456789
bbcd12340o87
jjioer1245678
jjioer1245678
iert09876456
lilsir1234890
psnjoih12456789

Can I display data like

12345myreport3/23/06abcd12340o87njioer1245678njkio190734wert09876456oilsir1234890asnjoih12456789bbcd12340o87jjioer1245678jjioer1245678iert09876456lilsir1234890psnjoih12456789

If any one has any clue plz help. I am using CR10 & Oracle9i.
Thanks,

 

[synapsevampire]

If you mean concatenate all of the data, try a formula in the details of:

whileprintingrecords;
stringvar AllData:=AllData+{table.field}

This will concatenate it, then you can display all of the data in the report footer using:

whileprintingrecords;
stringvar AllData

-k

 

[rb2005]

everything is not table field. to get this value I have few formulas. do u think it will work?
first I have a static number which will concatenate the report header then the data. most of the cases column will concatenate each other with few ++++
so it will look like
1234myreport /23/2005 abcd++768++++9870ghfd++987++++0987

hey any clue?

 

[synapsevampire]

How would anyone know without seeing what these formulas are?

Please add some technical information:

Crystal version
Database/connectivity
Example data
Expected output

And don't say I have a few formulas, show them, where they are in the report, what you want concatenated together, and where the results are to be displayed.

-k

 

[rb2005]

I have solved it.. I have put database version and CR version first time.

 

[lbass]

It might help other readers if you posted your solution.

-LB

 

[rb2005]

can I concatenate detail data with summary data.

let say the data look like
group 1
col1 col2 col3
A 5 7
B 8 15
C 8 9

Group1 total 21 31

group 2
col1 col2 col3
A 5 7
B 8 15
C 8 9

Group2 total 21 31

Can I display like A+5+7+b+8+15+c+8+9+group1total+21+31
+A+5+7+b+8+15+c+8+9+group2total+21+31

 

[rb2005]

I am getting the data but group total is printing after each line, but I need that only after end of a group