Login   Register 
Receive news via our XML/RSS feed
Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About

Home

Book

Contents

Preview

Articles

Tools

Newsletters

Premium

Ask

About

Most Popular Articles
  • Using Secure Sockets Layer (SSL) for SQL Server 2000 Reporting Services
    Creating an SSL Certificate to ensure your confidential reports remain confidential


  •  
    Boost Data Ltd.
     
     
    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

     

     
     
     
     
     
    Home | Book | Contents | Preview | Articles | Tools | Newsletters | Premium | Ask | About