Hey all,

I have a report -- it has subtotals and totals.  On the subtotal line, I need it to calculate LE1 + LE2 - LE3.  However, any time I put a subtraction calculation, I get the following programming error:

Error while parsing module: "SUBTOTAL (0)":
Type mismatch error (operation is not defined for the types of operands)
 

Is there a workaround to this?

Thanks!

Are you trying to do Math on the Sum elements themselves in the same report section that they are in?

-Ray

After a couple of hours, I fixed my sum problem by creating invisible values on each item line, and totalling them up.  Not perfect for calculating taxes, but close enough. 

Now I only have a name problem .. 

Each line in my report has a client number and a spot for client name.  I'm having a problem carrying the client number and name down to the subtotal line.  I managed to get the client number by using a summary field (high) of the listed client numbers, but nothing I put in for name will work.  I've tried:

SubtotalName = LineName (doesn't work -- every subtotal name is the same for all clients)
SubtotalName = @xlookupref(@FN, subtotalclientnumber, sales screen!cltno, cltname) (doesn't work, returns 0)

Any idea what I can do here?

I'd love to switch to version 2 ... probably in 90 days, but until them ...

Okay, I tried what you explained, and it didn't work.  Here's what I did.

GLOBAL CODE: stat sCltName as string

Group Header 1 (My report titles) I created an invisible unbound value box called HoldingName.

HOLDING NAME ON PRINT: HoldingName = CLTNAME

Group Header 2 (A report title underline series of Line Boxes)

Body: This is where all my invisible data that will add up (evenutally) goes.  I have an unbound value box callled CLTNAME.

CLTNAME ON PRINT:
   var vCltName as string
   vCltName = (@Xlookupsourcelist(@FN, LE0, "Sales Screen!CltNo", "CltName"))
   CLTNAME = @accessstringarray(vCltName,1)

Group Footer 3 (My displayed total per client line).  Sums of body fields, only visible.  To get the client name to appear in the Footer, I have a High Value Box of the invisible client number above.  I created an unbound valuebox called Pullname on this line to be where the client name shows.

PULLNAME ON PRINT: PullName = sCltName

Group Footer 2 (another line of line boxes before the grand total)

Group Footer 1 (My Grand Total) which needs no client name, just sums of all of Group Footer 3 subtotals.

What did I do wrong?

I made the change, but still no go ... group footer 3 is still blank ...

OK, that worked ... I got the client number in the footer.  Now how do I get the name to appear?

Here's my sample report ... the top line is the body (which I want to make invisible once I get the subtotal line below showing the client name...

Thanks!

Clt No            Clt Name            Pd Here            Pd Dir            Comm Here            Comm Dir            HST            Gross            Net            Invoice            Trust Fund                                                                                                                               3010            ABC Company            $525.00                        $157.50                        $20.48                                                       3010            3010            $525.00            $0.00            $157.50            $0.00            $20.48            $0.00            ($347.03)            $0.00            $347.03                                                                                                                                                            $525.00            $0.00            $157.50            ($347.03)            $20.48            $0.00            ($347.03)            $0.00            $347.03

Hallefrickinleujia!  It works!  Thanks Ray!

One report down, 37 to go ...