Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design
Message Icon Topic: How to override Invoice Total Post Reply Post New Topic
Author Message
$$Dr
Newbie
Newbie


Joined: 18 Feb 2016
Online Status: Offline
Posts: 8
Quote $$Dr Replybullet Topic: How to override Invoice Total
    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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3629
Quote hilfy Replybullet 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
9-Time SAP BusinessObjects Partner of the Year.
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
$$Dr
Newbie
Newbie


Joined: 18 Feb 2016
Online Status: Offline
Posts: 8
Quote $$Dr Replybullet Posted: 14 Feb 2018 at 8:26am
Your solution worked perfectly. Thanks!
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.