Hello, I have a report that lists inventory items. The database breaks down like this. ID | InventoryName | Quantity | Site | RefersTo RefersTo is a GUID that is used in another table here RefersTo | InventoryID It's used to reference similar or alternate parts in the selected part is out of stock. I'm trying to create a report that shows the inventory information from the table above. I am having problems with the "RefersTo" part. I can get report services to show the first "RefersTo" entry, but if there is more then one, it will only show the first one. I need it to show each item that is attached by the "RefersTo" GUID. What am I doing wrong?Owner, Quilnet Solutions

Hi, Do you have any gouping in the table? If yes, then see if all the data columns ae in the Details group ( row with thee horizantal lines)... Also, if you want comma sapeated list you can have a look at this post http://beyondrelational.com/blogs/chintak/archive/2011/01/08/string-concatenation-aggregation-in-ssrs-column-or-row-group.aspx- Chintak (My Blog)

This might be what I need. I'll check it out and see if that works for me. Thanks!Owner, Quilnet Solutions

I wasn't able to get this to work. Any other ideas? I should also note that I'm on a local report, not a server-side report, if that makes a difference. I may also not be explaining everything right. Each inventory item from above has all of it's objects (InventoryName | Quantity | Site) listed in a single column. I'm using an expression do to this. Each column has a seperate item, columns are not being used to seperate an items objects. Instead of this... InventoryName | Quantity | Site InventoryName | Quantity | Site It looks like this... InventoryName - Quantity - Site | InventoryName - Quantity - Site Each item's RefersTo reference is being listed in a row underneath it's corresponding item that it is referring to. Each RefersTo has it's own row. Like this... InventoryName - Quantity - Site RefersTo1 RefersTo2 I hope that helps clear it up a bit. Any ideas on making this work? Thanks. Owner, Quilnet