>I'm creating a report. I use an SQL to populate it. I've generated the cursor, put it in the DE of the repoprt, so I can drag the fields thence to the report bands. Of course, after this, I delete the cursor name from the field names in their properties and remove the cursor from the DE.
>
>The designer was happy to let me drag all the fields I want, But when I click on the print preview button it objects to 2 of the fields (both similar) stating that variable does not exist, then brings up the properties form for the first of them (thus SHOWING that it bloody-well does!)
>
>OK, I ensured that they weren't > 10 chars wide. First they were called csrWatever.NumPass1 and csrWatever.NumPass2 (both identical numeric fields). So I changed them to Num1Pass and NumPass, but still I can't get past the problem.
>
>In between, I deleted the fields froom the report and all the remainder of the fields were allowed, and the report previewed OK.
>
>FWIW the fields are numeric 16.0 (that's what they ended up as from the following SQL:
>
>

>SELECT ET.Operator, ET.Route, ET.Class, ET.Date, op.Desc as OpDesc, ;
>	SUM(IIF(BETWEEN( ET.date, ldStart1, ldEnd1), Number, 0000000)) AS Num1Pass, ;
>	SUM(IIF(BETWEEN( ET.date, ldStart2, ldEnd2), Number, 0000000)) AS Num2Pass ;
>...
>

>
>ANy ideas?
>
>'ppreciate it
>
>Terry

Are you sure you are in correct alias?
Maybe your current alias is some other Table/Cursor that have almost identical structure. try this just to be sure:

SELECT ET.Operator, ET.Route, ET.Class, ET.Date, op.Desc as OpDesc, ;
      SUM(IIF(BETWEEN( ET.date, ldStart1, ldEnd1), Number, 0000000)) AS Num1Pass, ;
      SUM(IIF(BETWEEN( ET.date, ldStart2, ldEnd2), Number, 0000000)) AS Num2Pass ;
...
INTO CURSOS crsWhatever
SELECT crsWhatever
REPORT FORM ....
BROWSE NORMAL TITLE ALIAS()