Post reply

SSRS 2005 visibility issue

  • January 10, 2012 at 2:18 pm

    #254720

    I was using SSRS 2005, and not got the sum of the desired result? I attached sample of the Filed I was looking to sum up?

    Here is the detail SUM(daily), SUM(Weekly), SUM(Monthly)

    My hidden expression was =IIF(Sum(Fields! daily.Value) + Sum(Fields!weekly.Value)

    = 0, True, False)

    Here is I stack on? SUM(daily.Value), SUM(weekly.Value) this Filds Sum exactly the visable value, But SUM(Monthly) gives me the visible +Hidden sum?

    I tried to drag new text in the SUM(Monthly) and write the expression

    * =SUM(IIF(Fields! daily.Value+ Fields!weekly.Value=0,0, Fields!Monthly.Value))

    *or=IIF(Sum(Fields! daily.Value) + Sum(Fields!weekly.Value)

    = 0,0,SUM(Fields!Monthly.Value)) gives me visible +Hidden sum

    Also changed visibility of Monthly header? But still sum visible +Hidden?

    Any feed back?

    Regards

  • January 13, 2012 at 7:40 am

    #1433255

    I don't as a rule open word documents from the web because I don't trust antivirus software to do its job that I paid perfectly good money to them to do, but doesn't sum keep summing whether the source data is being displayed or not? Apologies if I'm completely missing the point!

Viewing 2 posts - 1 through 1 (of 1 total)

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