Let’s say you have a report that executes a dataset which produces fields for your report. You define that dataset like this:

select firstname, lastname, middlename 
from name_table

You then pull the columns from that table and load the data …

Here is how you can determine in parameter one’s expression if a certain value was selected in parameter two’s multiple select parameter, and depending on the condition, set the value of parameter one.

Let’s say one of the values in …

 =StrConv("JOHN DOE", vbProperCase)

This now becomes John Doe…

In order to do alternate row coloring for an SSRS report that has grouping, you need an expression for your BackgroundColor property different than the typical:

=iif(rownumber (nothing) mod 2 = 0, "LightGrey", "White")

You can use the following expression …

=Replace(Round(Fields!Rate.Value,2),”.00″,””)…

Since SSRS does not have a report footer, it can be challening to figure out how to display information one time within the page footer on the last page. Here is one workaround that works well.

At the top of …

1) Create an external Assembly DLL (Class Library). You can use Framework 3.5.

a) Name it ‘DataForSSRSReport’.
b) Rename the default class to ‘clsDataForSSRS’. Make sure the class is Public.
c) Use ‘Private Shared’, ‘Public Shared Property’, and ‘Public Shared …

This example applies to SSRS 2008

SELECT a.datafield1 As Col1, a.datafield2 As Col2, b.datafield6 As Col3
LEFT OUTER JOIN databaseB.dbo.Table4 b on b.datafield6 = a.datafield1
FROM databaseA.dbo.Table5 a 

UNION 

SELECT a.datafield7 As Col1, a.datafield8 As Col2, b.datafield12 As Col3
LEFT