G'day Herb, At 09:42 PM 27/11/2001 -0500, you wrote: >First of all I have Rbase 2000ver6.5++ (1.842xTT03) >I have to mention I do all my Reports Forms etc. from the Object Manager >In one of my Reports I would like to have a total, but I don t seem to >come up with the proper syntax, however I have no Problem on the R> prompt. > >Example; > >COMPUTE Sum Rent from Tenants WHERE Unit CONTAINS Car AND Vacant = Yes
Try: vRentSum = (SUM(Rent)) FROM Tenants WHERE Unit CONTAINS 'Car' AND Vacant = 'Yes' >The second problem is in printing from the Object Manager, > >I have about a 3 blank space on some reports on the bottom of the page >(Not all), have been changing the header and data line but it misses some >data but continues on the next page properly till it hits the bottom again >and starts all over again. If there is a field on the report that straddles the page then the balance of the data that does not print on the first page is lost. >My settings are as follows In Utilities>>Preferences>>Reports >Lines per Page 70; Page Footer Line 0; Check marked clear Variables after >Printing; Print Orientation = Portrait; Report margin left = 0.5; Right 8 >I m using the default Font with 8 points on the Data, Headings are a bit >larger. Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
