Solved

Grand total doesn't render to pdf when using Code for the total

Posted on 2014-04-07
9
378 Views
Last Modified: 2014-05-14
We have a report that requires grand totals.  Because some of the values in the grouping lines are just the first value of that field we can't use the normal sum to get a grand total.  We've used Code to get the total.  When the report runs, the total shows on the screen properly.  But when you save it as a pdf or print it the totals created using Code do not display.  What is the work around for this?
0
Comment
Question by:cindyfiller
  • 5
  • 4
9 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 40000323
Please post your code expression.
and what you are placing in the textbox area.
0
 

Author Comment

by:cindyfiller
ID: 40001824
here is the code that is used and then below that is how the code is used in the detail line and in the total line (where it isn't working).  BTW I have since taken this report into excel and the totals that display on the report  (from the code) are way off from the totals when done in excel.  


Public Dim FVTotal as Double = 0
Public Dim ABTotal as Double = 0

Public Function AddFVTotal (Amt as Double) as Double
      FVTotal = FVTotal + Amt
      AddFVTotal = 0
End Function

Public Function GetFVTotal as Double
      GetFVTotal = FVTotal
End Function

Public Function AddABTotal (Amt as Double) as Double
      ABTotal = ABTotal + Amt
      AddABTotal = 0
End Function

Public Function GetABTotal as Double
      GetABTotal = ABTotal
End Function

--------
detail line:   =First(Fields!NPV.Value)+Code.AddFVTotal(First(Fields!NPV.Value))

final total:   =Code.GetFVTotal()
0
 

Author Comment

by:cindyfiller
ID: 40001858
Ignore the comment about excel totals not equaling -  I know why that is and I can't just take a summary of the total.  Mostly I have to figure out how to get the totals to render to pdf's and excel and/or find an alternative way of creating totals.
0
 

Author Comment

by:cindyfiller
ID: 40001934
BTW I tried creating a page footer and put the totals in there... it is doing something similar.  On the report on screen, the totals are fine but if you save it as a pdf (which we do often) the totals are completely different from what shows on the screen.  Its maddening - our CFO uses this report for so many things but she always wants it in a pdf.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 27

Expert Comment

by:planocz
ID: 40001960
How are you grouping  the items? By a line number? A group type?
0
 

Author Comment

by:cindyfiller
ID: 40001967
A group - we have gifts that come in and each gift goes toward a certain fund.  I'm grouping on that fund.
0
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 40002004
Here is a sample that I use in some reports
Change the ItemCode to your Funds field....

SUMMING A GROUP INSIDE A GROUP
Public Dim ToT as Double
Public Function TotalItems(Byval value as Double, ByVal Reset as Boolean) as Double
       ToT += value
       If Reset = TRUE Then
          ToT = value
       End If
      Return TOT
End Function
=Code.TotalItems(Fields!PlanDetailQuantity.Value, IIF(Fields!ItemCode.Value <> Previous(Fields!ItemCode.Value),True,False))

IF this does not work for you , let me know  I do have other codes.
0
 

Author Comment

by:cindyfiller
ID: 40002240
Do you know if this renders ok?  The code does do the correct totals - the problem only shows up when I render it as a pdf or excel file.  Then the totals are either 0 or wrong.
0
 
LVL 27

Expert Comment

by:planocz
ID: 40002875
All the SSRS reports that I work with are exported to PDF files.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now