locked
report field in report header gives error RRS feed

  • Question

  • User-1474096950 posted
    =ReportItems!CNAME.Value i have a expression as above which i display in header i get it in one report ie rdlc but when i copy the same in another report header & execute it i get as #error . i even tried adding new text box & writing down the same expression but still i get it as #error
    Friday, June 8, 2012 2:14 AM

Answers

  • User-1501801757 posted

    For the one that isn't working.  Put this in and tell me the results

    =iif(ReportItems!CNAME.Value is nothing, "CNAME is NULL", ReportItems!CNAME.Value)

    #Error can occur if the value is null.  This will tell you if the result set for this report is not returning a value for that field.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 8, 2012 7:33 AM

All replies

  • User-1501801757 posted

    Have you confirmed CNAME is a valid field in the dataset bound to the report you copied it to and have you confirmed it's all caps in the copied to report?

    Friday, June 8, 2012 2:54 AM
  • User-1474096950 posted
    ya as i have dragged that field from show datasources list
    Friday, June 8, 2012 3:29 AM
  • User-1501801757 posted

    instead of value... pull back HasValue what does it show?

    Friday, June 8, 2012 3:48 AM
  • User-1474096950 posted
    one more thing its working in one of the reports so i tried to copy paster the entire thing still the same error no idea y its working in one of the report any other way i can copy paster the entire header content so that it will owrk
    Friday, June 8, 2012 6:35 AM
  • User-1501801757 posted

    For the one that isn't working.  Put this in and tell me the results

    =iif(ReportItems!CNAME.Value is nothing, "CNAME is NULL", ReportItems!CNAME.Value)

    #Error can occur if the value is null.  This will tell you if the result set for this report is not returning a value for that field.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, June 8, 2012 7:33 AM