Knowledge Base Category: Development

Pie chart Series Label Overlapping in SSRS

Issue:

SSRS Pie charts tend to overlap the names when too many small slices are next to each other.

Solution:

A good solution is to sort the pie chart slices between big and small pieces. The following script will reorder your slices. Just insert the name and value into this script and call it from your dataset.
Read more
				

How to Justify Text in SSRS

Microsoft does not support justified or letter text alignment in Reporting Services: Aspose offers a solution http://www.aspose.com/ [private role="administrator"] We had to create a solution to this issue at Ledgex. We send the text string to a DLL that converts it into an Image. First get the DLL from the following location: DLL Download Make sure you paste the DLL...
Read more

Add Ordinal Extension to a Number

This little code snippet adds extensions such as st, nd, rd, th to integer numbers. Useful also with SSRS under Report Properties > Code
 Public Function ChangeToOrdinal(ByVal digit As Integer) As String
        Dim residual As Integer = digit Mod 10
       ... 						
						
Read more

The report definition is not valid

Today while deploying reports on a client's server I came across this error on two reports: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded. (rsInvalidReportDefinition) I tried a few tricks with no results, then I found a blog with the solution. http://beatheadagainstwall.blogspot.com/2011/03/invalid-target-namespace-when-deploying.html Replace report tags


						
						
										Read more
				
Page 5 of 12« First...34567...10...Last »