conditional suppression and incorrect manual totals

[sgm1]

Hi! Am working on a multi-column report in which I am using manual running total formulas. In one of the columns, I have a conditionally suppressed rows so as to avoid duplicate listings. I have consulted various resources & technical papers in Crystal support but I cannot get correct totals in this column of data. The totals in this column are not correct even if the suppressed data were being picked up. Totals in columns where I have not suppressed data are correct. Am using Crystal version 7. Any suggestions? Thanks.

 

[kenhamady]

Suppressed values still count in totals, unless you write the manual total to only include one value per group.

Is the total too high or low (if you include the suppressed values)? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sgm1]

The total is too high. FYI, I have used an initialize, evaluate, display sequence. Do I need a reset formula as well? The initialize formula is in the group header as I want the totals for a specified group. Thanks.

 

[kenhamady]

Yes need a reset (which can replace the initialize).

If that doesn't help, post your formulas.

Also, is there a reason you are using the 3 formula technique? There are easier ways, like conditioinal totals. Use the opposite condition to the suppression condition.

See faq149-243 Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sgm1]

Ken: Crystal support said I needed to use the 3 formula approach. At this point, I am totally confused and do not know up from down. Am trying to prevent duplicate charges for the same patient and date from appearing in the column.
I have an initialize fromula suppressed in group header
Evaluate: WhilePrintingRecords;
CurrencyVar RunningTotal;
If (OnFirstRecord or ({charge.servicedate}) <>
Previous ({charge.servicedate}) then
RunningTotal := RunningTotal + tonumber ({charge.fee)} this is suppressed. Then, in a column adjacent in details, I have @ suppressed charge formula:
If (OnFirstRecord...<>, then tonumber ({charge.fee})
Display = WhilePrintingRecords; CurrencyVar RunningTotal.

 

[kenhamady]

How do you define a duplicate charge?
Any record with the same patient and day?

What are your report group fields?
What is your initialize formula?
What/where is your reset formula? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[sgm1]

Ken: Am writing a payroll report based on collections. Major group is the provider. Then I search for all charges within a date range and payments associated with the charge. What I want to do is list all payments but eliminate listing and total of the charge for same date (patient portion and insurance portion will be applied to same charge date but may come in at different times).

Initialize formula = WhilePrintingRceords;
CurrencyVar RunningTotal;
RunningTotal := 0;

in group header

When I replaced the initialize formula with a reset formula and placed it in the group header, I got running totals which did not reset when the provider changed. maybe, i should just start over????? Thanks for your patience.

 

[kenhamady]

Is that your only group?
What are your sort fields?

I am still not clear on what you are trying to suppress and total. From your formula it appears that whenever the date repeats you want to suppress it and not include it in the total. If so you should add a group by the date, suppres the details section, and put your display fields in the Group Footer for the date. No conditions needed.

If that works, we can use a similar idea for getting the totals to only include those records.
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/