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
 
 
 

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

Debug a dump of an ASP.NET Web Site - Visual Studio 2010

I have seen video from Scott Hanselmanon Channel 9, about debugging feature in Visual Studio 2010,


Presented technique can be very helpful for solving problems with ASP.NET on the productive web server


http://channel9.msdn.com/posts/Glucose/Hanselminutes-on-9-Debugging-Crash-Dumps-with-Tess-Ferrandez-and-VS2010/

I just bought Resharper 4.5

I used trial of Resharper 4.5 for Visual Studio 2008.
Now it is my must have tool for .NET development. I just bought a profesional licence for this product including update to the Resharper 5.0 :)

Why do I like this tool so much?

Because it helps keep my code clean and support code refactoring much better the Visual Studio.

I hope new version for Visual Studio 2010 will be even better.

Generate PDF from Reporting Services - cache problem

I develop reports with Reporting Services server and WCF as data sources
Reports are generated in PDF format.

I could not see changes in my reports after updating data.
I found the solution on Peter's Gekko blog.

I added  following  to my report url:

&rs:ClearSession=true

Here is my code:

var reportUrl = ConfigurationManager.AppSettings["ReportURL"];


var reportParameters = @"&rs:Command=Render&rc:toolbar=false&rs:Format=PDf&rc:OmitFormulas=true&rs:ClearSession=true&id=";


System.Windows.Browser.HtmlPage.Window.Navigate(new Uri(string.Concat(reportUrl, reportParameters, myId)), "_blank");

I started to use features from C# .NET 3.5

I started to use 3 new features i c#.NET 3.5

1) extension method,

I call this  "static  noon-static" :)

such extension method help get user names in one string for the collection

public static string Namen(this List<Benutzer> instance)
{

var namen = new StringBuilder();
foreach (var benutzer in instance)
{

if (namen.Length > 0)
{

namen.Append(", ");

}
namen.Append(benutzer.Vorname);

}
return namen.ToString();

}

2) Auto-Implemented Properties, code snippet in VisualStudio 2008  "prop"

[DataMember]
public stirng Wert { get; set; }

[DataMember]
public string WertTyp { get; set; }


3) implicit type declaration

var masse = new Masse();