Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: summary has been specified in non-recurring field Post Reply Post New Topic
Author Message
zathras
Newbie
Newbie


Joined: 15 Sep 2008
Online Status: Offline
Posts: 1
Quote zathras Replybullet Topic: summary has been specified in non-recurring field
    Posted: 15 Sep 2008 at 12:21pm
Can someone please tell me why this formula will not allow a summary:

local NumberVar TotalPaid := 0;
local numbervar theAmount := 0;
local numbervar theRate := 0;

theAmount := {@CommissionableSalesPaid};
if {AR_Customer.UDF_INSIDE_REP}="DP" then theRate := .0085;

If {AR_Customer.UDF_INSIDE_REP}="KE" then
    TotalPaid := {@PaidFromKERate} + {#RTotal0};
If {AR_Customer.UDF_INSIDE_REP}="KE" and TotalPaid < 2000001 then
    theRate := .00125
Else if {AR_Customer.UDF_INSIDE_REP}="KE" and TotalPaid >= 2000001 and TotalPaid < 2300001 then
    theRate := .005
Else if {AR_Customer.UDF_INSIDE_REP}="KE" and TotalPaid >= 2300001 then
    theRate := .001;
theAmount * theRate


It does produce a numerical value for every line in the report.
{@PaidFromKERate} gets its value from a shared variable that is populated from a subreport in the report header of the main report, but even if I remove that, I still can't summarize on this field.

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.047 seconds.