Joined: 19 Mar 2007
Online Status: Offline
Posts: 27
Topic: concatenating data Posted: 20 Mar 2007 at 1:19pm
Hi all, Lets say I have a query based on a universe and I know that bringing a particular object from that query into the report would give me 10 rows. I would like to display them in a concatenated form in a single row. Is there a possibility? I have tried using join but that requires a string array. It worked with a parameter..
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 20 Mar 2007 at 1:35pm
There was another question just like this last week or so. You might want to search the forum for it. Anyway, create a shared variable and in the detail section have a formula that concatenates them together. Then in the group footer show the concatenated string.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 21 Mar 2007 at 2:50pm
Somethings not right. Yes, if you put it in the detail section it shows up five times (once for each row). But the footer should show everything. In the formula, are you using "WhilePrintingRecords"? This makes sure the formula gets called for every detail record.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
