i had created a excel report. that am displaying the summary of that report in another sheet of same excel called Pivot Report. i tried to set the "feild's subtotals Property" to NONE" in that pivot report. i had runned the macro in Excel sheet and got some coding . here are they......
Comments
example
Var
Counter - integer
BoolA - boolean /property dimension=5
FOR Counter:=1 TO 5 DO BEGIN
BoolA[Counter]:=TRUE;
IF Counter=3 THEN
BoolA[Counter]:=FALSE;
END;
FOR Counter:=1 TO 5 DO BEGIN
MESSAGE(FORMAT(BoolA[Counter]));
END;
i really bad understand.. :oops:
Can you post the code you have tried so we can help?
ActiveSheet.PivotTables("PivotTable1").PivotFields("Order No").Subtotals = _
Array(False, False, False, False, False, False, False, False, False, False, False, False)
this is wat the coding i got when i runned the Macro of excel sheet. how to pass this in Navision.
if ur much familiar in pivot report please help me :roll:
Never tried it but I doubt it will work but I might be wrong.
Maybe you can do it via a macro?
there is a download available
http://www.mibuso.com/dlinfo.asp?FileID=484
http://www.BiloBeauty.com
http://www.autismspeaks.org
With best regards,
Jan