SSRS Tools and Methods and its Property and Function

This article explain you about some of the features that are available in SSRS and its functionality and how to use those property that are available in SSRS and how to implement the functions that are available and this will be helpful to make use of some of the few functions that are available in reporting services.

SSRS Tools and Methods.

The below steps are the property option and functions that can be used in reporting services (SSRS).

1. Visibility Property

This Property is used for visibling a particular row or column based on the condition. The below query should be used
in the expression dialogue box.

2. Switch Function

Switch is used for using multiple cases in our report for a particular column or for a particular textbox.The below query should be used
in the expression dialogue box.
=Switch(Fields!GroupColumn.Value="Total", "Bold", Fields!GroupColumn.Value <>"Total", "Normal")

3. Null Value Property

In our database many tables may have null value, but in our result we should avoid that null value using this function "Nothing".The below query should be used
in the expression dialogue box.
= Isnothing ( Fields! MisMonth.Value,"0", Fields! MisMonth.Value)
= (Fields!Pincode.Value= Nothing, 0, Fields!Pincode.Value)
=( Fields!Pincode.Value="",0, Fields!Pincode.Value)

4. Drill Down Option

Set the Visibility Property = 'Hidden' and
select Visibility can be toggled by another report item checkbox and there in report item select the field name by which field we want to get toggled by.

5. Sub Report

  • Create the main report and sub report having a parameter that can be passed by the main report field.

  • In the Main Report create a new data field and drag and drop the subreport tool there and set the parameter field that was given there in sub report.

  • It should be kept inside the list or else the repeated branch are type will not be displayed.

  • 6. Navigation Property

    Select the field property and go to navigation option and In HyperLink Option select the another report name by Jump to Report Option.

    7. Blank Space While Exporting to PDF:

    • Body + Right margin + Left margin should be less than page width
    Body + Top margin + Bottom margin should be less than page height
    Select menu Report --> Report Properties --> Layout
    Set "Page Width" to be more than the table width in the content section.
    Say if you have a table with 150 columns and if you have given the table width as "140 in", you may have to set the "Page width" to be more than "140 in".

    8. ISARRAY

    IIF(TypeOf Parameters!TestSingleOrMulti.Value IS ARRAY,
    JOIN(Parameters!TestSingleOrMulti.Value, ", "),

    9. Row Number

    = RowNumber(Nothing)
    The Nothing keyword indicates that the function will start counting at the first row in the outermost data region. To start counting within nested data regions, use the name of the data region. To start counting within a group, use the name of the group.

    10. Page Headers and Footers

    To include page Header and Footers in our report use the below query

    =Globals.ReportName & ", dated " & Format(Globals.ExecutionTime, "d")
    =Globals.PageNumber & " of " & Globals.TotalPages

    11. Page Breaks

    In some reports, you may want to place a page break at the end of a specified number of rows instead of, or in addition to, on groups or report items. To do this, create a group that contains the groups or detail records you want, add a page break to the group,
    and then add a group expression to group by a specified number of rows.
    The following expression, when placed in the group expression, assigns a number to each set of 25 rows. When a page break is defined for the group, this expression results in a page break every 25 rows.

    To allow the user to set a value for the number of rows per page, create a parameter named RowsPerPage and base the group expression on the parameter, as shown in the following expression:

    12. URLs

    You can customize URLs by using report data and also conditionally control whether URLs are added as an action for a text box.
    The following expression, when used as an action on a text box, generates a customized URL that specifies the dataset field EmployeeID as a URL parameter.
    ="" & Fields!EmployeeID.Value

    For more information, see How to: Add a Hyperlink to a URL (Reporting Services).
    The following expression conditionally controls whether to add a URL in a text box. This expression depends on a parameter named IncludeURLs that allows a user to decide whether to include active URLs in a report. This expression is set as an action on a text box.
    By setting the parameter to False and then viewing the report, you can export the report Microsoft Excel without hyperlinks.



    No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: