Crosstab Report: Wrong Results

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
mpol_ch
User
Posts: 877
Location: Switzerland

Crosstab Report: Wrong Results

Post by mpol_ch »

Hi
I am using the crosstab reporting and facing wrong summary data.
When I use a second field in value then the ressults are correct.
But the result for the first field are always wrong.
When I change the sequence of field values then then then again the first field value get the wrong summary.
Please see the section below and compare 705 with 1000.
Both of them should be 1000.
The calculation bases on the same table...

 d (Anzahl)
 GNr (Anzahl)
 Prio
 VS
 Filter
 GS
 Filter
 KA
 Eilig
 Normal
 Vorzug
 Id (Anzahl)
 GNr (Anzahl)
 AM	RF	KA	
 15
 0
 1
 1
 0
 0
 16
 1
 MOS	BIE	KA	
 4
 1
 0
 0
 0
 0
 4
 1
 RN	SC	AF	
 21
 316
 347
 347
 337
 337
 705
 1000
 Gesamtsumme	
 348
 348
 337
 337
 317
 317
 1002
 1002

mpol_ch


mpol_ch
User
Posts: 877
Location: Switzerland

Post by mpol_ch »

Hi,
I have created a view with reduced fields and run the reports on the created view.
Now it is working properly.

Thanks
mpol_ch


Post Reply