total field not avail in filter

[apettinotti_(Guest)]

help! can someone help me figure out WHY this pre-processed total is not available for me to use as a selection criteria in the filter of this report??? it simply doesn^t show up in the drop down list when i try to select it in the filter...____CntDNOCL (AUTH_DET.CntDNOCL) Numeric Total__ Sum(AUTH_DET.HasDNOCL(), AuMaster.AUTHNO, AUTH_DET.SEQUENCE, Pre-processed)__the field that it^s counting is:__HasDNOCL (AUTH_DET.HasDNOCL) Numeric Calculated__ rr(iif(substr(tproccode,1,5)=^DNOCL^,1,0))____this is sooo strange because i have another report with fields set up JUST LIKE this which works fine (ie - the pre-processed field is available when i go into the filter to make my query):__DMECount (AUTH_DET.DMECount) Numeric Total__ Sum(AUTH_DET.DMEcheck(), AUTH_MAS.AUTHNO, AUTH_DET.SEQUENCE, Pre-processed)__DMEcheck (AUTH_DET.DMEcheck) Numeric Calculated__ rr(iif(substr(tproccode,1,3)=^DME^,1,0))____the ONLY signifigant difference between these two reports is that the one that^s not letting me see the total field in the filter has LOT^S of calculated/total fields (44 calc, 24 tot) and an attached text file with 95 fields in it while the other report has very few (14 calc, 3 tot) and no attached text file... is there some limit to the number of calc/total/attached text file fields that arpeggio can deal with???

[kfleming]

Do you have other pre-processed totals that reset at a higher level in the report that does not make this total available for a filter?__Maybe a pre-processed grand total?____That would explain the difference. There is not a limitation based on the sheer number or complexity of other calcs/totals.______Kathleen__R&R Support

[apettinotti_(Guest)]

ah, kathleen, that^s exactly it. i had forgotten because this report is such a complex organism (it has grown more and more convoluted over a long period of time), but it *does* have a grand pre-processed count of the records...____can you help me think of any way around the issue? my goal is this:____1) be able to know when i^ve reached the last page of the entire report so i can put a marker in the page footer ONLY on the very last page, which is necessary for our faxing software to be able recognize the end of the page.__(right now i^m doing that by having a calc field that compares a running grand count to that pre-processed grand count and only prints the characters when they are equal... it just occured to me that maybe a summary line would work - it won^t be in the page footer, but it still might work ok - i^ll test that.)____AND____2) be able to exclude the MASTER record from the report if a field in any of the detail records (of a 1:many join) contains a certain value ____(i was attempting to do that with a pre-processed count of that value but was thwarted by the existance of the pre-processed grand total above... i^d hate to attempt to do it with logical lines within the report - a trick that i often use - because the report is so complex and already has dozens of logical lines)____thanks for your input...