Post reply

SSRS report

  • February 13, 2014 at 2:51 am

    #282417

    Hi,

    I have a requirement in SSRS report where I have to show a checkbox in the report checked based on the value of a table column. Is it feasible in an SSRS report?

  • February 13, 2014 at 6:20 am

    #1688696

    You could add two images to the report (one a ticked box the other unticked) and use IIF in an expression to decide which image to show.

    Are you using 2008 or 2008R2?

    Far away is close at hand in the images of elsewhere.
    Anon.

  • February 13, 2014 at 11:51 pm

    #1688982

    I am using 2008 R2 version.

    Please add some more information on solution so that I can proceed further.

  • February 14, 2014 at 2:15 am

    #1688996

    In 2008R2 the Indicator was added to the toolbox

    Add this to your report

    Select symbols with the tick for the Indicator type

    Set the value to NULL for no display, 0 for X, 1 for ! and 2 for tick

    The value can be either a field in the dataset or an expression

    You will need to navigate around to find all the properties but you can set size, color etc.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • February 14, 2014 at 4:53 am

    #1689028

    Thanks for your reply.

    Any web articles where I can get more detailed help having snapshots?

  • February 14, 2014 at 5:07 am

    #1689030

    try this one

    http://blog.hoegaerden.be/2012/08/04/displaying-checkboxes-in-an-ssrs-report/

  • February 17, 2014 at 7:00 am

    #1689492

    You could also use the Wingdings font

    =iif(somefield = somevalue,þ,¨)

    [font="Wingdings"]þ[/font]

    [font="Wingdings"]¨[/font]

  • March 11, 2014 at 5:27 am

    #1695902

    I used the Windings font for the two text boxes in the report and used the following expressions for my requirement:

    =iif(count(Fields!Results.Value)=0 OR Fields!FindingsDeleted.Value = 1,chr(0120),"o")

    AND

    =iif(count(Fields!Results.Value)>=1 AND Fields!FindingsDeleted.Value = 0,chr(0120),"o")

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply