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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.