Home Subreports
New Blog Posts: Merging Reports - Part 1 and Part 2

subreport drilldown gives error on page boundary

edited July 2006 in Subreports
I have a strange error that appears on a report with a drilldown subreport.
I expand the last line on the first page. The detail cannot fit on the
first page and doesn't appear on the second page.
I expand the detail on the first line on the second page and I get a error
that RB is unable to find the record from the detail table....





Call Stack Information:
-----------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class
|Procedure/Method |Line|
-----------------------------------------------------------------------------------------------------------
|008EDFF9|R6.exe |ppDBPipe.pas |TppDBPipeline
|GotoBookmark |982 |
|0084BAC5|R6.exe |ppDB.pas |TppDataPipeline
|SetRecordNo |1800|
|007FEEF1|R6.exe |ppEngine.pas |TppEngine
|DataPipelineRecToState |3471|
|007FEE0C|R6.exe |ppEngine.pas |TppEngine
|DataPipelineRecToState |3446|
|007F9AD9|R6.exe |ppEngine.pas |TppEngine
|RequestPage |489 |
|007F4A67|R6.exe |ppSubRpt.pas |TppSubReport
|GenerateReport |1429|
|007F4904|R6.exe |ppSubRpt.pas |TppSubReport
|GenerateReport |1405|
|007F5163|R6.exe |ppSubRpt.pas |TppSubReport
|GenerateChild |1666|
|007F4ECC|R6.exe |ppSubRpt.pas |TppSubReport
|GenerateChild |1606|
|007F4349|R6.exe |ppSubRpt.pas |TppSubReport
|CalcSpaceUsed |1140|
|0080D56E|R6.exe |ppStrtch.pas |TppStretchable
|CalcPrintPosition |1087|
|0080D36D|R6.exe |ppStrtch.pas |TppStretchable
|Generate |1011|
|00800513|R6.exe |ppBandEngine.pas |TppBandEngine
|ProcessQueue |806 |
|008004A8|R6.exe |ppBandEngine.pas |TppBandEngine
|ProcessQueue |793 |
|008002FE|R6.exe |ppBandEngine.pas |TppBandEngine
|GenerateObjects |727 |
|00800260|R6.exe |ppBandEngine.pas |TppBandEngine
|GenerateObjects |711 |
|007FFB03|R6.exe |ppBandEngine.pas |TppBandEngine
|Generate |472 |
|00806C06|R6.exe |ppBands.pas |TppDetailBand
|Generate |2184|
|007FA6EF|R6.exe |ppEngine.pas |TppEngine
|GenerateBands |973 |
|007FA64C|R6.exe |ppEngine.pas |TppEngine
|GenerateBands |950 |
|007F9FB8|R6.exe |ppEngine.pas |TppEngine
|GeneratePage |696 |
|00854BE8|R6.exe |ppReport.pas |TppBandedReport
|GetDetail |785 |
|007FB148|R6.exe |ppEngine.pas |TppEngine
|StartPage |1327|
|007F9E78|R6.exe |ppEngine.pas |TppEngine
|GeneratePage |653 |
|007FA299|R6.exe |ppEngine.pas |TppEngine
|RestorePage |814 |
|00896498|R6.exe |ppClass.pas |TppCustomEngine
|ESInclude |9978|
|007F9DD2|R6.exe |ppEngine.pas |TppEngine
|BeforePass |619 |
|007FA170|R6.exe |ppEngine.pas |TppEngine
|RestorePage |762 |
|007F9CA6|R6.exe |ppEngine.pas |TppEngine
|Generate |562 |
|007F9C48|R6.exe |ppEngine.pas |TppEngine
|Generate |537 |
|007F9B86|R6.exe |ppEngine.pas |TppEngine
|RequestPage |510 |
|0085652B|R6.exe |ppReport.pas |TppReport
|RequestPage |1934|
|008A948F|R6.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1233|
|008A9430|R6.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1222|
|008A9183|R6.exe |ppDevice.pas |TppPublisher
|Publish |1043|
|008A9120|R6.exe |ppDevice.pas |TppPublisher
|Publish |1027|
|008AA31A|R6.exe |ppDevice.pas |TppDevice
|MakePageRequest |1989|
|008AA2D8|R6.exe |ppDevice.pas |TppDevice
|MakePageRequest |1982|
|00880DBF|R6.exe |ppViewr.pas |TppViewer
|PaintBoxClickEvent |853 |
|77D4EB39|user32.dll| |
|CallNextHookEx | |
|77D4EB03|user32.dll| |
|CallNextHookEx | |
|77D496C2|user32.dll| |
|DispatchMessageA | |
|77D496B8|user32.dll| |
|DispatchMessageA | |
|0087C295|R6.exe |ppProd.pas |TppProducer
|PrintToScreen |1521|
|0087C210|R6.exe |ppProd.pas |TppProducer
|PrintToScreen |1498|
|0087BF25|R6.exe |ppProd.pas |TppProducer
|Print |1296|
|0087BEC4|R6.exe |ppProd.pas |TppProducer
|Print |1284|
|00855281|R6.exe |ppReport.pas |TppReport
|Print |1043|
|00C31689|R6.exe
|uFrmSalesDaybookListing.pas|TfrmSalesDaybookListing|cxButton1Click
|430 |
|77D4EB03|user32.dll| |
|CallNextHookEx | |
|7C9010ED|ntdll.dll | |
|RtlLeaveCriticalSection | |
|7C90F1CB|ntdll.dll | |
|RtlMultiByteToUnicodeN | |
|7C90F0A5|ntdll.dll | |
|RtlAnsiStringToUnicodeString| |
|7C90D9BF|ntdll.dll | |
|NtFindAtom | |
|77D4EB03|user32.dll| |
|CallNextHookEx | |
|77D4EB03|user32.dll| |
|CallNextHookEx | |
|77D4E900|user32.dll| |
|CallWindowProcA | |
|77D4E8EA|user32.dll| |
|CallWindowProcA | |
|77D494DA|user32.dll| |
|GetCapture | |
|77D496C2|user32.dll| |
|DispatchMessageA | |
|77D496B8|user32.dll| |
|DispatchMessageA | |
|00FB53F5|R6.exe |R6.dpr | |
|508 |
|7C90E64C|ntdll.dll | |
|NtSetInformationThread | |
-----------------------------------------------------------------------------------------------------------

Modules Information:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Handle |Name |Description
|Version |Size |Path
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00330000|CONTAINER.DLL| |
|54784 |D:\Advprog\SOURCE
|
|00350000|PRNDEV.DLL | |
|171008 |D:\Advprog\SOURCE
|
|00380000|INVOICE.DLL | |
|142848 |D:\Advprog\SOURCE
|
|00400000|R6.exe |
|1.0.4.32770 |24635904|D:\Advprog\SOURCE
|
|12170000|ACE32.DLL |Advantage Client Engine DLL
|8.0.0.4 |913408 |D:\Advprog\SOURCE
|
|187B0000|axcws32.dll |Advantage 32-bit remote communication library
|8.0.0.0 |151552 |D:\Advprog\SOURCE
|
|4EC50000|gdiplus.dll |Microsoft GDI+
|5.1.3102.2180 |1712128
|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.GdiPlus_6595b64144ccf1df_1.0.2600.2180_x-ww_522f9f82
|
|5AD70000|uxtheme.dll |Microsoft UxTheme Library
|6.0.2900.2180 |218624 |C:\WINDOWS\system32
|
|5EDD0000|olepro32.dll |
|5.1.2600.2180 |83456 |C:\WINDOWS\system32
|
|61E00000|mapi32.dll |Extended MAPI 1.0 for Windows NT
|1.0.2536.0 |112128 |C:\WINDOWS\system32
|
|662B0000|hnetcfg.dll |Home Networking Configuration Manager
|5.1.2600.2180 |344064 |C:\WINDOWS\system32
|
|71A50000|mswsock.dll |Microsoft Windows Sockets 2.0 Service Provider
|5.1.2600.2180 |245248 |C:\WINDOWS\system32
|
|71A90000|wshtcpip.dll |Windows Sockets Helper DLL
|5.1.2600.2180 |19968 |C:\WINDOWS\System32
|
|71AA0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT
|5.1.2600.2180 |19968 |C:\WINDOWS\system32
|
|71AB0000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL
|5.1.2600.2180 |82944 |C:\WINDOWS\system32
|
|71AD0000|wsock32.dll |Windows Socket 32-Bit DLL
|5.1.2600.2180 |22528 |C:\WINDOWS\system32
|
|71B20000|mpr.dll |Multiple Provider Router DLL
|5.1.2600.2180 |59904 |C:\WINDOWS\system32
|
|72D10000|msacm32.drv |Microsoft Sound Mapper
|5.1.2600.0 |20480 |C:\WINDOWS\system32
|
|72D20000|wdmaud.drv |WDM Audio driver mapper
|5.1.2600.2180 |23552 |C:\WINDOWS\system32
|
|73000000|winspool.drv |Windows Spooler Driver
|5.1.2600.2180 |146432 |C:\WINDOWS\system32
|
|732E0000|RICHED32.DLL |Wrapper Dll for Richedit 1.0
|5.1.2600.0 |3584 |C:\WINDOWS\system32
|
|74720000|MSCTF.dll |MSCTF Server DLL
|5.1.2600.2180 |294400 |C:\WINDOWS\system32
|
|74E30000|RICHED20.DLL |Rich Text Edit Control, v3.0
|5.30.23.1221 |431616 |C:\WINDOWS\system32
|
|76380000|msimg32.dll |GDIEXT Client DLL
|5.1.2600.2180 |4608 |C:\WINDOWS\system32
|
|76390000|imm32.dll |Windows XP IMM32 API Client DLL
|5.1.2600.2180 |110080 |C:\WINDOWS\system32
|
|763B0000|comdlg32.dll |Common Dialogs DLL
|6.0.2900.2180 |276992 |C:\WINDOWS\system32
|
|76600000|CSCDLL.dll |Offline Network Agent
|5.1.2600.2180 |101888 |C:\WINDOWS\System32
|
|76B40000|winmm.dll |MCI API DLL
|5.1.2600.2180 |176128 |C:\WINDOWS\system32
|
|76BF0000|PSAPI.DLL |Process Status Helper
|5.1.2600.2180 |23040 |C:\WINDOWS\system32
|
|76C30000|WINTRUST.dll |Microsoft Trust Verification APIs
|5.131.2600.2180 |176640 |C:\WINDOWS\system32
|
|76C90000|IMAGEHLP.dll |Windows NT Image Helper
|5.1.2600.2180 |144384 |C:\WINDOWS\system32
|
|76F20000|DNSAPI.dll |DNS Client API DLL
|5.1.2600.2180 |148480 |C:\WINDOWS\system32
|
|76F60000|WLDAP32.dll |Win32 LDAP API DLL
|5.1.2600.2180 |172032 |C:\WINDOWS\system32
|
|76FB0000|winrnr.dll |LDAP RnR Provider DLL
|5.1.2600.2180 |16896 |C:\WINDOWS\System32
|
|76FC0000|rasadhlp.dll |Remote Access AutoDial Helper
|5.1.2600.2180 |8192 |C:\WINDOWS\system32
|
|76FD0000|CLBCATQ.DLL |
|2001.12.4414.308|498688 |C:\WINDOWS\system32
|
|77050000|COMRes.dll |
|2001.12.4414.258|792064 |C:\WINDOWS\system32
|
|77120000|oleaut32.dll |
|5.1.2600.2180 |553472 |C:\WINDOWS\system32
|
|773D0000|comctl32.dll |User Experience Controls Library
|6.0.2900.2180 |1050624
|C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9|
|774E0000|ole32.dll |Microsoft OLE for Windows
|5.1.2600.2726 |1285120 |C:\WINDOWS\system32
|
|77A20000|cscui.dll |Client Side Caching UI
|5.1.2600.2180 |326656 |C:\WINDOWS\System32
|
|77A80000|CRYPT32.dll |Crypto API32
|5.131.2600.2180 |597504 |C:\WINDOWS\system32
|
|77B20000|MSASN1.dll |ASN.1 Runtime APIs
|5.1.2600.2180 |57344 |C:\WINDOWS\system32
|
|77B40000|appHelp.dll |Application Compatibility Client Library
|5.1.2600.2180 |126976 |C:\WINDOWS\system32
|
|77BD0000|midimap.dll |Microsoft MIDI Mapper
|5.1.2600.2180 |18944 |C:\WINDOWS\system32
|
|77BE0000|MSACM32.dll |Microsoft ACM Audio Filter
|5.1.2600.2180 |71680 |C:\WINDOWS\system32
|
|77C00000|version.dll |Version Checking and File Installation
Libraries|5.1.2600.2180 |18944 |C:\WINDOWS\system32
|
|77C10000|msvcrt.dll |Windows NT CRT DLL
|7.0.2600.2180 |343040 |C:\WINDOWS\system32
|
|77D40000|user32.dll |Windows XP USER API Client DLL
|5.1.2600.2622 |577024 |C:\WINDOWS\system32
|
|77DD0000|advapi32.dll |Advanced Windows 32 Base API
|5.1.2600.2180 |616960 |C:\WINDOWS\system32
|
|77E70000|RPCRT4.dll |Remote Procedure Call Runtime
|5.1.2600.2180 |581120 |C:\WINDOWS\system32
|
|77F10000|GDI32.dll |GDI Client DLL
|5.1.2600.2818 |280064 |C:\WINDOWS\system32
|
|77F60000|SHLWAPI.dll |Shell Light-weight Utility Library
|6.0.2900.2861 |474112 |C:\WINDOWS\system32
|
|77FE0000|Secur32.dll |Security Support Provider Interface
|5.1.2600.2180 |55808 |C:\WINDOWS\system32
|
|7C800000|kernel32.dll |Windows NT BASE API Client DLL
|5.1.2600.2180 |983552 |C:\WINDOWS\system32
|
|7C900000|ntdll.dll |NT Layer DLL
|5.1.2600.2180 |708096 |C:\WINDOWS\system32
|
|7C9C0000|shell32.dll |Windows Shell Common Dll
|6.0.2900.2869 |8452096 |C:\WINDOWS\system32
|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Registers:
-----------------------------
EAX: 0628723C EDI: 040559EC
EBX: 0410DE04 ESI: 062871F8
ECX: 00000000 ESP: 0012ECE8
EDX: 00610FA8 EIP: 00610FA3

Stack: Memory Dump:
------------------ ---------------------------------------------------------------------------
0012ECE8: 0012ED18 00610FA3: E8 84 40 DF FF EB 13 8B CE B2 01 A1 00 AF 60
00 ..@...........`.
0012ECEC: 00404F60 00610FB3: E8 F8 EB DF FF E8 6F 40 DF FF 33 C0 5A 59 59
64 ......o@..3.ZYYd
0012ECF0: 0012ED10 00610FC3: 89 10 68 DA 0F 61 00 8D 45 FC E8 06 47 DF FF
C3 ..h..a..E...G...
0012ECF4: 062D8BB4 00610FD3: E9 58 3F DF FF EB F0 5E 5B 8B E5 5D C3 FF FF
FF .X?....^[..]....
0012ECF8: 00628054 00610FE3: FF 06 00 00 00 25 73 3A 20 25 73 00 00 55 8B
EC .....%s: %s..U..
0012ECFC: 0410DDD4 00610FF3: 6A 00 53 56 57 8B F9 8B F2 8B D8 33 C0 55 68
3C j.SVW......3.Uh<
0012ED00: 0003EC0B 00611003: 10 61 00 64 FF 30 64 89 20 8D 45 FC 50 8B D6
8B .a.d.0d. .E.P...
0012ED04: 062871F8 00611013: CF 8B C3 E8 8D B8 DF FF 8B 45 FC 8B 55 08 E8
1E .........E..U...
0012ED08: 0410DE0B 00611023: FF FF FF 33 C0 5A 59 59 64 89 10 68 43 10 61
00 ...3.ZYYd..hC.a.
0012ED0C: 00000000 00611033: 8D 45 FC E8 9D 46 DF FF C3 E9 EF 3E DF FF EB
F0 .E...F.....>....
0012ED10: 0012ED34 00611043: 5F 5E 5B 59 5D C2 04 00 90 55 8B EC 83 C4 F4
53 _^[Y]....U.....S
0012ED14: 0061FFB4 00611053: 56 57 33 DB 89 5D FC 8B F1 8B FA 33 D2 55 68
B3 VW3..].....3.Uh.
0012ED18: 0012ED8C 00611063: 10 61 00 64 FF 32 64 89 22 8B D6 E8 79 DF 00
00 .a.d.2d."...y...
0012ED1C: 00404F60 00611073: 8B D8 85 DB 75 24 57 8D 55 FC A1 BC 19 FD 00
E8 ....u$W.U.......
0012ED20: 0012ED34 00611083: 4D 6D DF FF 8B 45 FC 50 89 75 F4 C6 45 F8 0B
8D Mm...E.P.u..E...
0012ED24: 0410DE04 00611093: 55 F4 33 C9 58 E8 53 FF FF FF 33 C0 5A 59 59
64 U.3.X.S...3.ZYYd



EurekaLog 4.5.8

Application:
------------------------------------------------------
1.1 Start Date : Thu, 6 Jul 2006 14:46:41 +0100
1.2 Name/Description: R6.exe
1.3 Version Number : 1.0.4.32770
1.4 Parameters :

Exception:
-----------------------------------------------
2.1 Date : Thu, 6 Jul 2006 15:11:19 +0100
2.2 Address: 00610FA3
2.3 Module : R6.exe
2.4 Type : EDatabaseError
2.5 Message: tblLineDetail: Record not found.

Active Controls:
------------------------------------
3.1 Form Class : TppPrintPreview
3.2 Form Text : Print Preview
3.3 Control Class: TppEdit
3.4 Control Text :

Computer:
-----------------------------
4.1 Name : PAULPC
4.2 User : Paul
4.3 Total Memory: 2015 Mb
4.4 Free Memory : 1310 Mb
4.5 Total Disk : 155.63 Gb
4.6 Free Disk : 149.77 Gb

Operating System:
---------------------------------------
5.1 Type : Microsoft Windows XP
5.2 Build # : 2600
5.3 Update : Service Pack 2
5.4 Language: English (United States)

Comments

  • edited July 2006
    Hi Paul,

    Are you able to recreat this error using the drilldown demo in the
    \RBuilder\Demos\1. Reports\... directory? In my quick testing, everything
    seemed to work correctly. If you can recreat the error, please give me the
    exact steps you are taking to do so and I'll work on finding the cause of
    the problem for you.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2006
    I increased the footer spacing - it was only like a pixel high and it seems
    to have solved it but I have to check a little more.

This discussion has been closed.