Loop through fields in rdlc report -
i have rdlc report in report have field takes values expression
(round(((first(fields!occurs.value) / first(fields!totaldistance.value))* 10000),2)
but in cases (totaldistance.value) = 0 previous expression returns infinity, need next record in case of field equals 0 , if next field equals 0 , want next one
i looked way of getting next record didn't find found (first , last) methods, how can ?
instead of using first or last if don't care record long isn't 0 couldn't use aggregate function. ex:
(round(((first(fields!occurs.value) / max(fields!totaldistance.value))* 10000),2)
you use max, min or avg value. unaware of way within rdlc loop through records asking.
another different way load data datatable add column contain calculated value , use code calculate values before being passed report.
Comments
Post a Comment