SSRS:Tips and Tricks



For last 4 months. I ve been working in SSRS .So thought of sharing few tips and tricks which i ve used .

First one is filtering,
Scenario if there is no value for a particular column.Hide that column


Code Snippet

1. Right-click the “Details” in the “Row Groups” pane which is in the left bottom, select “Group Properties”.
2. Select “Filters” on the left pane in the Group Properties dialog box.
3. Click “Add” on the top of the right side to add a filter.
4. Click “fx” to the right of the Expression text box.
5. Type in the expression: =IsNothing(Fields!Column.Value).
6. Select “=” from the Operator drop-down list.
7. Type in: =false in the value text box.

next is sorting
Scenario:If we want a field in the alphabetical order or reverse


Code Snippet

1. Right-click the “Details” in the “Row Groups” pane which is in the left bottom, select “Group Properties”. 
2. Select “Sorting” on the left pane in the Group Properties dialog box. 
3. Click “Add” on the top of the right side to add a filter.
 4. Click “ColumnName” to the right of the Expression text box. 5. Give order in the Drop down 

HappyCoding ! 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: