At 06:43 PM 5/23/2010, TOM HART wrote:
I want to tally Style# by Vendor# for sales and inventory. Help says you can use tally in a view but I can't seem to get it to work.
Tom, Without knowing more details, take a look at the "CROSSTAB" command of R:BASE. HELP CROSSTAB You may also use the CROSSTAB Wizard while Editing/Browsing the appropriate table. Data Browser/Editor | Main Menu | Calculate | Crosstab ... Select Column for the "side" that defines the row Select Column for the "top" that defines the column Define the "Cell" for the Crosstab column Define Crosstab function AVG, COUNT, MAXIMUM, MINIMUM, SUM Click on [OK] button to view cross tab result Play with the concept until to get what you are looking for.
Ultimately I want to print a report of both tally's by Vendor, but I can't seem to get it in a view or temp table.
Yes, you CAN! Use "CrossTab" control (part of Advanced Controls) in report designer to achieve you goal. Hope that helps! Very Best R:egards, Razzak.
