Joining RefNbr in one line

i need to show something like
=[ARInvoice.RefNbr]+'=P'+ [ARInvoice.CuryOrigDocAmt] +')'

Reference No(s): INV0001=P100.00, INV0002=P250.00, INV0003=P500.00

my file 

You could potentially do it within the details section of a report.

You could put a field in the header section which would state ‘Reference No(s):’ this is so that the field only prints once, then a field for [ARInvoice.RefNbr]+'=P'+ [ARInvoice.CuryOrigDocAmt] +')' within the details section of the report which will print for every record in the specific join.

Hope this helps.

​@aiwan 
I’ve already created a subreport to generate the reference numbers, but they always appear on separate lines like this:

INV0001=P100.00

INV0002=P250.00

INV0003=P500.00

What I need in my report is for them to appear on a single line, separated by commas, like this:

INV0001=P100.00, INV0002=P250.00, INV0003=P500.00


 

​@saintsin 

You could potentially create a variable in the header section, then assign the variable within the details section, ensuring it is invisible, then printing that variable in place of the field you have now.

I think something like this would work Assign($ReferenceNos, $ReferenceNos + ‘+’ + [ARInvoice.RefNbr])

it gives a value of 0 its not working ​@aiwan 

I need help 😞

​@nhatnghetinh 

my updated file

Hi ​@saintsin 

+ When you use the formula: =[ARInvoice.RefNbr]+'=P' [ARInvoice.CuryOrigDocAmt] +')' => only display the first Invoice => this is correct according to the current logic.
+ When you use Subreport, display multiple lines => this is correct according to the current logic.

If you want to display all Invoices data on only 1 row, you need to create a new DAC by writing SQL View to convert data from columns into 1 line.

Best Regards,

NNT

so i cant put a 1 line? without adding an new DAC ​@nhatnghetinh 

Hi ​@saintsin 

Yes. Currently if there is no Customization to create a new DA, your 1 line will only display the first invoice.

Best Regards,

NNT

​@saintsin something you could try if you haven’t already:

Create a variable in your details section or even in your subreport, and as you loop through the lines, concatenate the ref nbrs so that your final variable has a list of the ref nbrs. Hope this helps.