|
Hi I have a query on a file. 1. I selected two fields for sort order (say fld1, fld2). 2. Selected to get a Total (in Report Summary Function) for a amount field (say fld3). 3. Selected Report break for the two fields that chosen for sorting. Break level 1 for fld1 and break level2 for fld2. 4. In the break text I typed &fld1 Total and &fld2 Total. Every thing is working fine, but an extra 'TOTAL' word at the breaks is coming on the report. Why is that coming? Is there any way to sop that? This is how the report looks now : fld2 fld1 fld3 425 1991/04/01 167.48 425 1991/04/01 167.48- 425 1991/04/01 167.48- 425 Total TOTAL 167.48- 426 1991/04/01 100.00 426 1991/04/01 50.00 426 Total TOTAL 150.00 19910401 Total TOTAL 17.48- I don't want this (extra) 'TOTAL' word. It shoudl look like 425 Total 167.48- and then 426 Total 150.00 19910401 Total 17.48- How can I do that? TIA Amitava
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.