Hi all,

I have a report that is written this way

ITEM ID    QTY       Item Description
001           1          Laptop
002           3          Keyboards

Serial nos. ahk0001 for Laptop, ahk002,ahk003,ahk004 for mouse.

serial nos. is a subreport which has a formula:

for the header:
WhilePrintingRecords;
If Not InRepeatedGroupHeader then stringvar serials:=""

for the footer:
WhilePrintingRecords;
stringvar serials;

for the serials:
WhilePrintingRecords;
If OnFirstRecord then stringvar serials:={JrnlSNum.SerialNumber} else
If {JrnlSNum.SerialNumber}=Previous ({JrnlSNum.SerialNumber}) then stringvar serials:=serials else
stringvar serials:=serials+","+{JrnlSNum.SerialNumber}

Now i want the report to bi itemized like this

ITEM ID    QTY       Item Description
001           1          Laptop
serial no.              ahk001
002           3          Keyboards
serial no.              ahk002,ahk003,ahk004

Whats the formula for this?
Any help would be great Thanks..