Computed column

I have a query that retrieves different numbers for each record where i want to view all values of one column for all rows as follows:
 
PONUM DESCRIPTION PRNUM
1w **** 1111
2e hhhh 1234
12w kjdhf 878p
 
I wanna display them like this 
 
PONUM DESCRIPTION PRNUM
1w **** 1111, 1234, 878p
2e hhhh 1111, 1234, 878p
12w kjdhf 1111, 1234, 878p
 
Please help!
 
thank you!

Find more posts tagged with

Comments

Clement Wong

The technique to use here is to first create/initialize a string variable in the beforeOpen event of the Data Set.
<pre class="_prettyXprint">
savedStr = "";</pre>
Then, create a computed column to add to the variable, and use it for its value.
<pre class="_prettyXprint _lang-">
if (savedStr == "") savedStr = row["JOBTITLE"];
else savedStr = savedStr + ', ' + row["JOBTITLE"];

savedStr;
</pre>
See attached for an example.

sufanf

Thank you for taking the time to reply to my question. I appreciate it!
 
However, I am using a scripted dataSet and the field should be built in the query that I have built. Moreover, I am using the field in the master page!

sufanf

I found the solution for it without the need to do any coding. You can add an aggregation and use CONCATENATE built-in function. Then create a column binding and put the aggregation you created under the expression field.
 
Even though I solved it, but It would be nice knowing another way of doing it for future reference.
 
Thank you so Much!!