Wednesday, January 20, 2010

Reporting services: show value with line breaks between words

I need to display value as a list separated with coma and line break.


I found great tip, how to realize line breaks in reporting services here:
http://www.kodyaz.com/articles/reporting-services-add-line-break-between-words-custom-code.aspx

very helpful custom code function:

Public Function AddLineBreakBetweenWords(words As String) As String
Dim rsRegEx as System.Text.RegularExpressions.Regex = new System.Text.RegularExpressions.Regex("\s+")
words = rsRegEx.Replace(words, " ")
return words.Replace(" ", vbCrLf).Trim()
End Function
 
 
 

Thursday, January 14, 2010

Cool web designer tool

http://www.artisteer.com/

This is web designer tool for people like me, who are software developer not web designers.

Whole web site you can easly export to ASP.NET as the Visual Studio solution

Manipulate multiple object in sql server management studio

I had a problem to select more the one object in management studio,
in object explorer you can select only one item.

I found a very helpful tip described by Ken Simmons http://www.mssqltips.com/tip.asp?tip=1911

Just open Object Explorer details view (by default its a window on the right) and there you can select and manage multiple objects