Crosstab AV

rbuser

Hi!

For some reason I'm geting AV in very simple crosstab report. Call
stack:

Exception class: EAccessViolation
Exception message: Access violation at address 00616F4E in module
'PARK.exe'. Read of address 00000000
Exception address: 00616F4E
----------------------------------------------------------------------------------------------------
[00616F4E] ppCTCell.TppMatrix.GetDataType + $1E
[0040361B] System.@HandleAnyException + $33
[0040331C] System.@CallDynaInst + $4
[0053147C] ppComm.TppCommunicator.GetParentCommunicator + $1C
[0053153A] ppComm.TppCommunicator.FindUserObject + $22
[004024EC] System.SysFreeMem + $164
[00402514] System.SysFreeMem + $18C
[00616F49] ppCTCell.TppMatrix.GetDataType + $19
[006177BF] ppCTCell.TppMatrix.CreateColumnCell + $43
[00617B5E] ppCTCell.TppMatrix.InsertColumns + $72
[0061798C] ppCTCell.TppMatrix.InsertTotalColumn + $44
[004038C6] System.@HandleFinally + $2A
[0052D0C7] ppUtils.TppResourceManager.LoadStr + $13
[0061B5E1] ppCTEng.TppCrossTabEngine.InitCalcGrid + $1A1
[004038C6] System.@HandleFinally + $2A
[00618B45] ppCTEng.TppCrossTabEngine.Calc + $29
[006248CF] ppCTMain.TppCrossTab.CalcSpaceUsed + $157
[004038C6] System.@HandleFinally + $2A
[00570505] ppStrtch.TppStretchable.CalcPrintPosition + $DD
[00570398] ppStrtch.TppStretchable.Generate + $2C
[00565980] ppBandEngine.TppBandEngine.ProcessQueue + $58
[004038C6] System.@HandleFinally + $2A
[00565804] ppBandEngine.TppBandEngine.GenerateObjects + $6C
[00565321] ppBandEngine.TppBandEngine.Generate + $ED
[0056B098] ppBands.TppDetailBand.Generate + $8
[00561353] ppEngine.TppEngine.GenerateBands + $83
[00560E2D] ppEngine.TppEngine.GeneratePage + $CD
[0056104B] ppEngine.TppEngine.RestorePage + $E3
[00560BF1] ppEngine.TppEngine.Generate + $49
[00560AEA] ppEngine.TppEngine.RequestPage + $E6
[0055DC8C] ppReport.TppReport.RequestPage + $E0
[005C8615] ppDevice.TppPublisher.DoOnPageRequest + $41
[005C83F3] ppDevice.TppPublisher.Publish + $63
[005CB966] ppProd.TppProducer.PublishReport + $6
[005CBA02] ppProd.TppProducer.PrintToDevices + $52
[005CBA1A] ppProd.TppProducer.PrintToDevices + $6A
[0055DB79] ppReport.TppReport.PrintToDevices + $65
[005CC62D] ppProd.TppProducer.PreviewFormActivateEvent + $19
[00534F44] ppForms.TppForm.Activate + $1C
[005539CC] ppPrvDlg.TppPrintPreview.Activate + $24


And when closing Preview form another exeption is raised:


Exception class: EListError
Exception message: List index out of bounds (1)
Exception address: 00413CCA
----------------------------------------------------------------------------------------------------
Stack list, generated 13.11.2003 16:51:39
[00413CC5] Classes.TList.Get + $19
[00413C15] Classes.TList.Error + $2D
[00413CC5] Classes.TList.Get + $19
[00616DA6] ppCTCell.TppMatrix.FreeCells + $1E
[00616D59] ppCTCell.TppMatrix.Destroy + $D
[00403144] System.TObject.Free + $8
[00618AED] ppCTEng.TppCrossTabEngine.Clear + $15
[00622F0A] ppCTMain.TppCrossTab.Clear + $52
[00622A0B] ppCTMain.TppCrossTab.Destroy + $F
[0041D4E2] Classes.TComponent.DestroyComponents + $46
[0041D2E3] Classes.TComponent.Destroy + $53
[0043AA10] Controls.TControl.Destroy + $A0
[004034CE] System.@ClassDestroy + $2
[0042059E] Graphics.TBrush.Destroy + $1E
[0043DA77] Controls.TWinControl.Destroy + $BB
[00452BEC] Forms.TScrollingWinControl.Destroy + $28
[0045389B] Forms.TCustomForm.Destroy + $AB
[00403144] System.TObject.Free + $8


Report is attached to DBPipeline, SQL is

SELECT SUM(VSL.Labisoit)AS KuuSumma, VSL.Kuu, VSL.Aasta
FROM VIEW_Labisoit VSL
JOIN TAB_SoidukLisa ON(VSL.Soiduk = TAB_SoidukLisa.Soiduk)
AND(TAB_SoidukLisa.Alates < VSL.Kuupaev)
AND((TAB_SoidukLisa.Kuni >=
VSL.Kuupaev)OR(TAB_SoidukLisa.Kuni IS NULL))
WHERE(TAB_SoidukLisa.Asutus = :Asutus)AND(AASTA <=
:LopAasta)AND(AASTA >= :AlgAasta)
GROUP BY Aasta,Kuu

where Aasta, Kuu and KuuSumma are all integers.

Report setup - Row: Aasta; Column: Kuu; Cells: SUM of KuuSum

I'm using D5 Pro and RB 7.02Pro.
Any idea whats wrong?


TIA
ain

nicocizik

Hello,

There were a couple of fixes to the CrossTab component between versions 7.02
and 7.03. Try updating your version of ReportBuilder to 7.03 and see if
that fixes the problem. If you need help with updating, please contact
sales@digital-metaphors.com with your serial number. (This is a free
upgrade).

--

rbuser

On Thu, 13 Nov 2003 08:52:40 -0700, "Nico Cizik \(Digital Metaphors\)"

nicocizik

Hello,

This is not a known issue with the CrossTab component. If possible please
send an example demonstrating the AV error to support@digital-metaphors.com.

--

rbuser

On Fri, 14 Nov 2003 10:18:31 -0700, "Nico Cizik \(Digital Metaphors\)"