>>>>I tried it, Fred...didn't work. Still get the same error when i want to run the report.
>>>
>>>Is your report using a private datasession? Change it so it doesn't.
>>
>>I didn;t use a private datasession when I created it
>
>Hi I missed the beginning of the thread... but, you are using SQL select to table ? Then you want to index the table?
>
>Try this...
>
>select * from blah into table mytable
>
>index on myfield tag myfield of mytable
>
>
>The above should leave the last index you create as the active one, but you should be able to do...
>
>set order to tag myfield
>
>if that doesn't work, try..
>
>set order to tag myfield of mytable
>
>BOb
Bob,

Here's my code...maybe it cxan shed some light

SELECT TRIM(temp.ass_l_ata), temp.ass_sclass, CNT(*) FROM temp ;
WHERE (temp.mnemonic = gcProject) AND (NOT EMPTY(temp.ass_sclass)) ;
AND (temp.ass_l_grp = gcGroup) AND (temp.ass_l_dept = gcDeptNo) ;
AND BETWEEN(temp.ass_l_date,gdStartDate,gdEndDate) ;
ORDER BY 1,2 ASC;
GROUP BY 1,2 INTO TABLE category

SELECT category
INDEX ON exp_1 TAG exp_1 of category
SET ORDER TO TAG exp_1

REPORT FORM category PREVIEW


Thanx