Pre-processed Totals Problem

[Mel_Smith_(Guest)]

Dear Friends,____ Enviro: R&R V6.0a and Win98se____ I have used successfuly pre-processed sums for many years.____My problem: My user wants to show a pre-proccessed total in *Pounds* rather than *Kilograms* at top of report in the Title Band.____ So, I said that^s easy, and will only take a few minutes of my time (since I already have a UDF that returns Pounds from a Kilogram input (i.e., pounds(nKilosum) ) and which works in all the other reports correctly.____ So, I made a calc field as follows:____ IIF(itsmetric,nKilosum,pounds(nKilosum))____ (where nKilosum is the pre-processed total of kilograms for the report)____ Then I place this calculated field in the Title Band of the report.____ However, when I print the report, this pre-processed calculated sum field is blank (i.e., it is zero and shows up blank).____ Am going ^nuts^ here !____ Is there some problem with using pre-processed sums in calculated fields in the Title Band ??____TIA,____-Mel Smith__

[Mel_Smith_(Guest)]

Dear Friends,____ While I^m waiting for a solution to this problem, I added a conditional line to the title band which hold the Imperial Version (i.e., pounds) of the report problem line. This works correctly.____ However, does anyone have a *proper* solution to the problem I noted in the previous post ??____ But for now, don^t expect a calculated field to show up in the Title Band of a report if a pre-processed sum is part of the calc field !____Thanks,____-Mel Smith__

[kfleming]

Does the total by itself look ok in the header and it is just the calculation that is problematic?____Kathleen__R&R Support

[Mel_Smith_(Guest)]

Kathkeen,____ Yes, both the Imperial version (i.e., pounds) and the Metric Version (kilograms) can both be placed on the same Title Band Line, and both show properly. However, in the calculated function I noted earlier, *neither* shows (i.e., a zero value). (and again, the calculated function uses my standard ^ismetric^ report logical variable.____ I went thru many gyrations and changes before writing this post. (and as I noted, I finally replicated the line, and made both conditional. Then I used the same logical variable to print the appropriate line -- with total success).____ But I^m still *bugged* about my wasting a whole morning before giving up. Then, that little guy who sits inside my head said: ^What about a Conditional Band Line ?^ and it worked.____Thanks for any further clarification.____-Mel Smith__

[Mel_Smith_(Guest)]

Kathleen,____ The same problem I noted in the primary post above exists also in R&R Version 9.0 (I don^t have V10.0 yet so don^t know about that)____-Mel Smith__

[kfleming]

If you want to send me the report and some sample data, I will have a look.____Kathleen__R&R Support__livesupport@livewarepub.com