The requirement is a report with the totals listed before the detail line (in the Break Header) for each sales division. (There will be a variable number of divisions printed on the report depending on the selection criteria)
Using the DBCalc, Look a Head, and Pass = 2, I can print the totals ahead of the detail lines in the Break Header section very easily and it works great. HOWEVER... (always something!), they want total percentages as well. Since you cannot use the DBCalc fields in calculations, I have not found an efficient way of doing this. I have not been able to figure out how to put a "Sum of" variable on a report and have it print on the Break Header. I do not believe using computed columns will work either as the DBCalc has Sum, Ave, Min, Max and Count options. None of which suffice for Percentages. There is no "Look a head" function for regular variables that I can find. Trying to calculate the percentages before generating the report poses the problems of the large number of select criteria and more importantly, how do you place a variable in a Break Header and have it print only the values for the current Break condition? I.E. If the report selection generates 10 "divisions", how do you place 10 different global variable values in the break header, matching the divisions? I have tried to get them to accept the totals in the Break Footer, but it is being insisted upon having them in the Header. Any ideas? Thanks! Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net
