Dick: Just define a break for your report by SKU and create 2 sets of total variables that sum the quantities that you need (prices, units, etc.), one set of the variables will be a reset at the break and will give you the totals by SKU (print the value at the break footer) the other set of variables will total the amount for the entire report (print at the report footer). If you need additional breaks/sub totals in you report, just create additional corresponding breaks in the report. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dick Sent: Friday, March 28, 2003 3:13 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Report... Duh! OK... That I figured out...That gets the info on the screen in a tabular form, BUT.. how do I turn that data into a report? Wouldn't it have to based on a table or view? ----- Original Message ----- From: "William Cook" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 11:30 AM Subject: [RBASE-L] - Re: Report... Duh! > SELECT SKU, COUNT(units),SUM(sales) FROM table GROUP BY SKU > ----- Original Message ----- > From: "Dick" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Friday, March 28, 2003 9:22 AM > Subject: [RBASE-L] - Report... Duh! > > > > Ever feel like you're just having a mental time-out? > > Trying to define a report that with pull distinct SKU's from todays > sales, along with total of no of units and total of days sales amt by > SKU. > > Have tried various ways & I can't make it work. > Know this ain't hard. > HELP > >
