ssrs column representation in expression with &VBCRLF&
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 .
October 22nd, 2010 6:27am
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
October 25th, 2010 9:16am