Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report shows value when it should not
Message
De
02/12/2015 06:35:32
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01628178
Message ID:
01628254
Vues:
46
>>>>>According to the description of the case I got, the stored procedure generated just a single row with 0 in quantity and in the sum_cost columns.
>>>>
>>>>OK, that's a bit clearer now. So the data into the report is a one row cursor with zero in both columns but the report is showing a value greater than 0 for one of the columns. Is that right?
>>>
>>>Yes.
>>
>>Any calculations on the report field? If you add in another field and set its value to the same as the field showing the incorrect value, what happens?
>>
>>If the value is from a variable, check if the variable depends on some other variable. Make sure there is no funny calculation on the variable.
>>
>>That's all I can think of at the moment
>
>The problem is that it is an application and I can not create a separate version to debug this problem (I think). The variable is not dependent on anything else, it's a simple variable. See attached.

Is sum_cost the field in the cursor?

How are you expected to fix the report if you can't make changes to it? All I suggested was to drop a new field on the report with the value set to the name of the column.
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform