Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report Designer keeps rejecting 2 of my fields
Message
De
11/07/2006 13:31:36
 
 
À
10/07/2006 13:08:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01135024
Message ID:
01135431
Vues:
11
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform