ARIBD.TEXTDESC - List all lines of invoice description in 1 excel cell

[gabe17]

thread631-1438436

Hello,

I would like to make the batch listing report in ACCPAC only 1 line per invoice to make it easier to to vlookups, etc in excel.

I have one column that is aribd.textdesc , this will show the first line of the invoice description, but exclude the other lines. Ideally I would like the one cell to have all line descriptions in it split by a space. But it would also be okay to have column after column have each line description as long as it's in the same row.

Is this possible?

Thanks,

Gabe

 

[DjangMan]

You'll have to do multiple sub-reports or use an array variable to store the detail lines which you can place horizontally on the same row.

What do you need to do this for?