September 23, 2008, 02:53 PM
PrarieDo you have a SUM or PRINT. As requested please post code.
September 23, 2008, 02:53 PM
NelsontTABLE FILE INVENTORY_WHS_FACT
BY COMPANY_ID
BY PRODUCT_NUMBER
BY PRODUCT_DESCRIPTION
BY PRODUCT_LINE
BY HOUSE
HEADING
""
FOOTING
""
WHERE COMPANY_ID EQ &COMPANY_ID;
WHERE PRODUCT_CLASS LIKE '2%' OR 'F%';
WHERE INV GT 0;
WHERE PRODUCT_NUMBER NOT LIKE 'UT%' OR 'UE%';
WHERE PRODUCT_NUMBER EQ 'HRMC1098';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
September 23, 2008, 03:02 PM
NelsontI figured it out you have to have one sum or detail in order to have an across
September 23, 2008, 03:33 PM
Darin LeeYup, You got it! While the code you posted will work (and is actually probably code that DevStudio produced automatically) it is not good practice to omit a verb (SUM, PRINT, COUNT, etc.). (The BY actually becomes the substitue verb - so it works.) You should also include at least one field whether or not it is NOPRINTed. Several issue like the one you ran into would not occur if you follow that guideline. Good job.