report field in report header gives error

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

Answer 1

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?

Answer 2

User-1474096950 posted
ya as i have dragged that field from show datasources list

Answer 3

User-1501801757 posted

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

Answer 4

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

Answer 5

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.