Report Has Incorrect Values - Don't Match Memory Vrbl Values

[drosenkranz]

Hello There,

I have a report with three columns and 19 rows. Each of these values are calc'd in the code prior to calling the VFP report. The mvars are referenced by the VFP Report and displayed. When the report displays, the first column is filled with all 3's.

The problem is there should a "2" in one row and a "1" in another row- all of the rest of the rows in this column should contain zeroes. The total for this column on my report = 42 when it should equal 3.

I've checked the memvars prior to the report launching and they are correct- I have a "2", a "1" and the rest are 0's. I;ve checked and rechecked these values and they are correct before the report runs.

What's up with the VFP Report Generator?

Thanks


The 2nd mouse gets the cheese.

 

[ramani]

1. Just check in the report, the variables are having the right format to display. For example, numeric shall display as "999999" or "ZZZZZZZZ" OR "@Z" such functions and are not made as character or other type variables.

2. Make sure that the variables used are plain variables and not given the attributes of SUM or such functions in the report. ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[jimstarr]

I'm suspicious that the table controlling this report has some field names identical to the memory variables you are using.

Jim

 

[drosenkranz]

No Matching field names. No formatting was specified.
The 2nd mouse gets the cheese.

 

[jimstarr]

Have you checked the memvars after the report has run?

Jim

 

[DEDMOD]

Try changing the '2' value to '4' and see if you get a column of 5's. You may simply have used the variable you use for the total of the column in the report where you meant to use the variable for each record. It'd be easy enough to pick tColValue instead of ColValue, for instance.

Dave