Toggle visibility of textbox in footer if condition is true in body of report?

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  January 26, 2010 at 7:52 am

  #214886

  In the body of the report are statistical details about a given set of performances. For example, suppose the report has a single table with three rows, where column A displays "Minimum Required" and Column B displays "Actual".

  If any row in this table has a situation where "Actual" is less than "Minimum Required", I'd like to display a message in the footer of the report that displays "Insufficient data found".

  Is there a way to do this, even if it's in custom code? I've been toying with the idea of creating a running sum value by creating an additional column in the table that evaluates something like =iif(Actual<MinumimRequired,1,0). Then the in the footer test if the running value is above 0; if it is greater than 0, then at least one of the situations has insufficient data. I just can't seem to figure out how to develop this, however.

  Thanks in advance,

  Pete

• only4mithunc

  SSCrazy Eights

  Points: 8434

  More actions

  January 28, 2010 at 10:25 am

  #1110203

  Hi

  If my understanding is correct, you can just merge the two cells of the footer and can give the below expression.

  =IIF(Fields!ACTUAL.Value < Fields!MINIMUM.Value,"INSUFFICAINT DATA FOUND","")

  No need of adding third column. Please let me know if my understanding is not correct.

  Regards,

  MC

  Thanks & Regards,
  MC

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 29, 2010 at 7:58 am

  #1110744

  Pete,

  I think the method you mention is the way to go. One thing to keep in mind is that you don't need to add a column tot he table, you can add a calculated field to the dataset using the formula you mention, then in the hidden property of the textbox in the footer you can do:

  =IIF(Sum(Fields!calculated_field.Value) > 0, False, True)

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• peterzeke

  SSCrazy Eights

  Points: 9003

  More actions

  January 29, 2010 at 8:36 am

  #1110787

  Jack, I figured I'd find a reply from you at some point -- seen you helping others with SSRS quite a bit - very cool.

  Actually, I was able to implement my idea, successfully, but I like your idea more. I definitely prefer solutions that leverage datasets (SQL queries) rather than building out objects in the report layout. I'll give your suggestion a try; should work nicely.

  Thanks again for the help.

  --Pete