Print Page | Close Window

How to override Invoice Total Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22547 Printed Date: 27 Apr 2024 at 7:11am Topic: How to override Invoice Total Posted By: $$Dr Subject: How to override Invoice Total Date Posted: 13 Feb 2018 at 7:48am I have a requirement where the ability to override a standard invoice output from the user system calculated based on an invoice template instructions is overridden by a manually entered parameter. This is a situation where the user is providing a quote in Lump Sum but is pulling materials that are included in the sale which have standard sales prices which need to be suppressed. Replies: Posted By: hilfy Date Posted: 14 Feb 2018 at 3:42am You need to use a parameter for this. I might call this {?Override Amount}. Set the default value to $0.00 Then there are a couple of ways you can go about swapping the two totals. Here is probably the easiest: 1. Insert a new section below the one where the current total is located. 2. If there are any objects in the total section that are not the total, copy them to the new section. 3. Place your parameter in the same location as where the total is in the previous section. 4. In the Section Expert, select the original total section and click on the formula button to the right of the Suppress checkbox (DO NOT check the checkbox!). Enter the following formula and then save: {?Override Amount} > 0.00 5. Set the suppress formula for the new section following the steps in item 4 above, except the formula needs to be this: {?Override Amount} = 0.00 -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics Posted By: $$Dr Date Posted: 14 Feb 2018 at 8:26am Your solution worked perfectly. Thanks!

Print Page | Close Window