crystal question

[EyeTalion]

In my report I have a group with data that is in my header table and in the detail portion of the report I have data from my detail table. Header data is a receipt total and Detail data is all the items bought...the problem I'm having is when I sum up my items. The items are in the detail portain (and detail table) and the total is fine, but the sales tax is the header table...so for every detail item the sales tax gets added...is there a way I can calculate this so the sales tax is only input once...maybe a sub-report?...any suggestions?

thanks

[brucevde]

so for every detail item the sales tax gets added...

Added to what. I am not sure I follow your question.

Are you trying to show the Sales Tax per item or just display the total tax of all items. The group footer would be a place to show the totals per group.

[EyeTalion]

I need to add the sales tax amount to the amount of all the items bought.

[brucevde]

Create a formula that calculates the Sales Tax for each item. Place this formula in the details section. You can then Sum the formula.

The formula would be something like

{DetailTable.ItemAmount} * .075

[EyeTalion]

that's what I'm doing now, but when theres more than one detail record, the sales tax with get added multiple times.

[brucevde]

???? Crystal processes each Detail record one at a time.

If the formula is in the detail section it would show the Sales Tax for each item.

[brucevde]

Never mind. Its Monday and I am a moron.

Does your report use the Group Footer section? You could place a Sum of all detail items in this section, suppress/hide it and then create a formula that contains


@SumofDetailItems + {HeaderTable.SalesTax}