Hi All , I have a set of book names select BookName from LibraryList where Active =1 and LibId = 22 and I get a list of some books Now I want the Matrix [Rows] to show these names in separate lines for example I write a expression = vbCrLf & "Book Name 1" & vbCrLf & "Book 2 Name 2" & vbCrLf & "Book 3 Name 3" & vbCrLf Could anyone please help me write this in dynamic sql, I could have hard coded the expression but the book names could be added any time and dont think its a good idea to have a book name hard coded. Thanks .

Hi, I don't understand your purpose completely. But on my understanding, you can try to use Subreport to show the "a set of book names select BookName from LibraryList where Active=1 and LibId = 22", then on the main report matrix, insert the subreport into a cell so that the book names can be displayed in seperate lines instead of using "vbCrLf". If you have more question about this, please provide more details here. thanks, Jerry