Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

  • RE: add report header/footer to report

    In 2008 R2, you can add page header & footer.

    Select Report -> From Menu Bar Select Report - > There you can find Add Header / Add Footer.

    Please go...

  • RE: colour expression based on parameter selection in ssrs 2005

    Just try below code. if necessary you can modify accordingly

    =SWITCH

    (

    Parameters!region_id.Value=0 AND Fields!comp.Value*0.05>Fields!allcomp.Value,"Green"

    Parameters!region_id.Value=1 AND Fields!comp.Value*0.05>Fields!mum_comp.Value,"Green"

    Parameters!region_id.Value=2 AND Fields!comp.Value*0.05>Fields!rowcomp.Value,"Green"

    Parameters!region_id.Value=3 AND Fields!comp.Value*0.05>Fields!southcomp.Value,"Green","Red"

    )

    Hope this will work with you

  • RE: Matrix Total

    can you explain it more..

  • RE: Hide Duplicate rows

    Hi,

    The expression which is used to hide duplicate values, used that exp in Row visibility property.

    = IIF([........Expression.....],True,False)

  • RE: ?? on =count adding a "When"

    It's correct !!!!!!

  • RE: Combining Security Roles

    Yes, the user will get the both role.

  • RE: 5 parameters in a report

    In your query u'll have these parameters

    @ApplicationName = 'Informatica' or 'Velocity' or 'MSCloud' --manually added to parameter

    @EnvironmentName = 'PROD' or 'UAT(ITSM = PROD)' --manually added to parameter

    and for...

  • RE: Add dynamic sql to report...

    Check the attachment

  • RE: Unable to create a working indicator

    you can chck the attachment

  • RE: Unable to create a working indicator

    I think u r following some wrong process..

    Below is an example

    FIRSTNAME BIRTHPLACE VALUE

    ERIK LONDON 0

    ERIK LONDON 3

    HARRY EDINBURGH 2

    HARRY EDINBURGH 5

    1. Add a indicator in the table and go to indicator properties.

    2. Simply Add the column name like Sum(Fields!Calls.Value).

    3....

  • RE: add image in report

    If you have 3 different report you can insert three different image.

    Go to Toolbox--> Image --> import the image you want to use in the report.

    Repeat this process...

  • RE: Unable to create a working indicator

    Change the Measurement unit to "Numeric" in value and state and see the result.

  • RE: Basic Expression

    You can use below expression in the background color property of BIRTHPLACE textbox.

    =IIF(Fields!BIRTHPLACE.Value = "LONDON","Red","Blue")

    I think it will help you.

  • RE: Display Month and day of week in Expression?

    You can use below expression:

    ="Today is: "& today &" Output: "& day(today)&" - "& WeekDayName(DatePart(DateInterval.Weekday,today),True,FirstDayOfWeek.System)

    And output will look like this

    Today is: 3/29/2013 Output: 29 - Fri

  • RE: In SSRS, how to insert hyperlink in a cell.

    In Action properties which section will i choose and what is the expression i can use to achieve the above scenario?

Viewing 15 posts - 1 through 15 (of 16 total)