Emmitt: Back in 6.5 days, I made much use of CALL to a stored procedure. As an example, one client had a report that printed a commission report. Each sale would have a different commission rate depending on many variables -- whether a downpayment was received, if the downpayment exceeded a certain percent, whether the customer had other open receivables, etc... So I wrote a stored procedure to make the calculations. Created one report variable passing in the SalesID: vRate = (CALL(storedprocedurename,.vSaleID)). Still works in 7.6!
Karen > The code to figure out each of the above is quite simple by comparison. > Why wouldn’t I simply locate that code in the page header band > on-before-generate eep rather than creating probably 30+ report expressions > to do the > same job? > > > >
