|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
printed version of report messes up data |
|
royk
|
printed version of report messes up data
Posted:
Wednesday, March 10, 2010 2:05 PM (GST)
|
|
using ssrs 2008 winserver 2008 wrote a report that does commulative summing for each line :
Public Dim SumTotal As Double = 0 Public Dim SumVend As Double = 0 Public Function GetSumTotal(s As Double, v As Double) As Double If v <> SumVend SumVend = v SumTotal = 0 End If If s<>0 Then SumTotal += s Return SumTotal Else : Return s End If End Function
the report runs fine and returns correct data.
however when sent to print (physical printer, pdf, xps) or viewed in the print preview,
the sum total doesnt get initliazed (me thinks) - instead of starting with the value of zero the sumtotal initial value is the result of the sumtotal as calculated when running the report on screen.
hence the open balance is wrong and the report data is completly messed up. going back to screen it is perfectly fine.
completly lost on this,
roy
|
|
|
|
|
|
|
|
|