Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report Designer keeps rejecting 2 of my fields
Message
From
11/07/2006 13:31:36
 
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01135024
Message ID:
01135431
Views:
10
>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?

I saw that the problem has gone away, but fwiw, you have Num1Pass and Num2Pass in the query and you talk about NumPass1 and NumPass2.

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform