So glad to be of any help at all. I'm usually on the receiving end these days! ~Claudine :)
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Thompson > Technology Consultants > Sent: Saturday, February 05, 2005 11:32 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Report Question > > Thank you Claudine, you might have given me some workable > ideas. There are (5) percentage calculations they want on each > Header, so I may have to use (5) views as the 'group by' requirement > will be different, but that should not be a problem. > > For some reason, I drew a blank on the lookup variable (I try not to > use them if possible) but you are correct, they can be processed only > on the break header and you can use the current break column value. > > Thank you for the late night assistance and hopefully I will have a > working report by Monday. > -Bob > > Thompson Technology Consultants > 276 Chippewa > LaPorte, IN 46350 > 219-324-2605 (Phone & Fax) > 219-363-7441 (Cell) > http://ttc.inc.home.comcast.net > > > > -----Original Message----- > From: Claudine Robbins [SMTP:[EMAIL PROTECTED] > Sent: Saturday, February 05, 2005 11:00 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Report Question > > Bob, > > I calculate year-to-date AFE totals for the header of my invoices. I > create > a temporary view where I do the year-to-date calculations, then place a > single variable on the header line which is defined as the H0 expression: > > V_YTD_TOTAL = YTDTOTAL IN V_YTDBILL WHERE AFE = ID > > It does the lookup to the view and uses the same AFE break as does the > detail of the invoice. > > SET ERROR MESSAGES 2038 OFF > DROP VIEW v_ytdbill NOCHECK > CREATE TEMPORARY VIEW `v_ytdbill` + > (afe,ytdtotal) + > AS SELECT + > billing_id, + > SUM(billing_amt) + > FROM d_b_allocation + > WHERE da_invoice_dt > 01/01/05 + > GROUP BY billing_id > SET ERROR MESSAGES 2038 ON > RETURN > > Does that help? > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Thompson > > Technology Consultants > > Sent: Saturday, February 05, 2005 10:14 PM > > To: RBG7-L Mailing List > > Subject: [RBG7-L] - RE: Report Question > > > > 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
