reporting services - Adding Time Stamp Values in SSRS reports -
i trying create ssrs report , facing problem in calculation.
i have few columns contains values 101.45, 25, 0.15, 3.30.
actually these values time values, adding these leads result 129.9.
now problem when decimal part exceeds .60 need add 1 number, final result need 130.30.
can 1 please me solving problem.
thanking in advance.
you cannot add values directly. need first convert values scale of 100. add , convert scale of 60.
select sum(floor(column1)+(column1%1)*100/60) timeadd
http://sqlfiddle.com/#!3/b5d55/8
for doing in ssrs
= (int(reportitems!textbox1.value) + (reportitems!textbox1.value mod 1)*100/60) + (int(reportitems!textbox2.value) + (reportitems!textbox2.value mod 1)*100/60) + (int(reportitems!textbox3.value) + (reportitems!textbox3.value mod 1)*100/60) + (int(reportitems!textbox4.value) + (reportitems!textbox4.value mod 1)*100/60)
but above give 130.5 want 130.3. need convert above sum scale of 60. either can store in variable , apply scaling or write big piece of code.
=int(reportitems!absolutesum.value) + (reportitems!absolutesum.value mod 1)*60/100
just suggestion easier solve in sql in report design.
Comments
Post a Comment