Results 1 to 33 of 33

Thread: using cr 9 in vb apps

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    using cr 9 in vb apps

    I have a vb6 app that uses crystal reports 9 to view and print out some labels. I'm using the Package and Deployment Wizard to distribute my app. When I run the app on a machine other than the developer machine, I get this error:

    Run-time error '-2147206461(80043ac3)'
    File not found.

    Can anyone tell me what is wrong?

  2. #2
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: using cr 9 in vb apps

    When do you get this Error?

    Seems like you have not packaged the report file alongwith your setup package.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    No, I packaged the report files. They are in the program folder. It seems like the error happens when it tries to display the report. None of the machines have CR9 on them except for my developer machine.

  4. #4
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: using cr 9 in vb apps

    Are the CR runtime file in place on the machines? Take a look at the readme with CR9 for a list of all required files and ensure that they are included in the Package.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  5. #5
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: using cr 9 in vb apps

    How are trying to access the report from the code? Can you post the that part of your code.

    It seems to me that the program is not able to find the report file when you install it on the client PC.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  6. #6

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    This is the code I used to call the report:
    VB Code:
    1. Set Report = Appl.OpenReport("saturation_tags.rpt")

  7. #7

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    None of the machines have Crystal run times files installed. I'll see if I can find a list of the files from the readme.

  8. #8
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: using cr 9 in vb apps

    Quote Originally Posted by bezaman
    None of the machines have Crystal run times files installed. I'll see if I can find a list of the files from the readme.
    If you are using Package & Deployment Wizard then all the dependency files should have been included in the Setup Package.
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  9. #9
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    You should have the Runtim.hlp help file. This help file describes each and every dll and ocx needed for every function, method, and control used in your CR/VB app. you just need to add each that you find as needed to your P&D setup and your good to go.

    Its located in the directory -
    ?:\Program Files\Seagate Software\Crystal Reports\Developer Files\Help\Runtime.hlp
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  10. #10

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    Runtime.hlp does not exist on my computer.

  11. #11
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: using cr 9 in vb apps

    This might help.

    Runtime CR Requirements

  12. #12

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    Still no luck getting it to work. I get the same error. What does it mean when the PDW cannont find dependency information for a file? Maybe this is my problem?

  13. #13
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: using cr 9 in vb apps

    Quote Originally Posted by bezaman
    Still no luck getting it to work. I get the same error. What does it mean when the PDW cannont find dependency information for a file? Maybe this is my problem?
    It seems to me that you are using Late-Binding. When you use Late Binding the PDW will not include the dependencies.

    Have you added references to the specific crystal report libraries in your VB Project?

    Can you post the code that is used to show the report and how the objects are declared?
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  14. #14

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    VB Code:
    1. Dim Appl As New CRAXDRT.Application
    2. Dim Report As New CRAXDRT.Report
    3.  
    4.     CRViewer91.DisplayBorder = False
    5.     CRViewer91.DisplayTabs = False
    6.     CRViewer91.EnableRefreshButton = False
    7.     CRViewer91.EnableGroupTree = False
    8.     CRViewer91.EnableSearchControl = False
    9.     CRViewer91.EnableExportButton = True
    10.     CRViewer91.Top = 100
    11.     CRViewer91.Left = 100
    12.     CRViewer91.Height = 14300
    13.     CRViewer91.Width = 19000
    14.  
    15.     If frmMain.OptFlat.Value = False Then
    16.         Set Report = Appl.OpenReport(App.Path & "\saturation_tags.rpt")
    17.     ElseIf frmMain.OptFlat.Value = True Then
    18.         Set Report = Appl.OpenReport(App.Path & "\saturation_tags_flats.rpt")
    19.     End If
    20.  
    21.     CRViewer91.ReportSource = Report
    22.     CRViewer91.ViewReport
    23.    
    24.     Do While CRViewer91.IsBusy
    25.         DoEvents
    26.     Loop
    27.     CRViewer91.Zoom 80

  15. #15

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    And yes I have added the references.

  16. #16
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Its not the P&Ds fault as its more of CR's fault that the dependancies are not found.

    You are running CR 9 so its should be Runtime.chm instead.

    These are some of the ones for the CR Viewer control but remember I have 8.5 so it may be different for 9. Thats why you need to locate your helpfile.

    CRYSTL32.OCX
    MFCANS32.DLL
    OLEPRO32.DLL
    CRPE32.DLL
    CRPAIG80.DLL
    IMPLODE.DLL
    MFC42.DLL
    MSVCIRT.DLL
    MSVCP60.DLL
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  17. #17

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    runtime.chm does not exist on my computer either. I'm using Crystal Reports Professional Version 9 SP5. Is there anywhere else I can find a list of the required runtime files?

  18. #18
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    I dont think so. Did you do a full install of CR?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  19. #19

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    As far as I know, yes. Crytal runs fine. In the crystal web site it says that runtime.chm is only included with the Developer and Advanced editions of Crystal Reports 9. I am using the CR Pro 9 SP5, so it would seem that this file was not include in my installation. Here is the article:

    http://support.businessobjects.com/l...s/c2008238.asp

  20. #20
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Yes, I got that from Hacks link in post #9. So I guess you can include most dlls and do a trial and error. It doesnt hurt, other then size of the setup.exe, to include more then you need.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  21. #21

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I found this article:

    http://support.businessobjects.com/l...s/c2012421.asp

    I'm going to try and follow these guidelines and see what happens.

  22. #22
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Cool, glad they at least give some kind of help on their support site.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  23. #23

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I've almost got it it, but now I get this error:

    UFL 'u25precisionid.dll' that implements this function is missing.

    the dll is included in the package but I still get the error. Any suggestions?

  24. #24
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    No, sorry but was there anything on the cr site? Maybe an known issue?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  25. #25

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I'll check it out. I sorta know what it is referring to. I have some text in my crystal report that is turned into a barcode using the precision id barcode font. I created a formula in crystal to accomplish this. So I think this error has something to do with that.

  26. #26

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    Ok, now I got another error:

    Crystal Report Viwer not implemented.

    Anyone seen this before?

  27. #27
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Did you include CRYSTAL32.OCX?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  28. #28

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I searched my computer for this file and it does not exist.

  29. #29
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    That is the viewer controls file but for 8.5 Not sure if its different for 9.1
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  30. #30

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I have these files included already:

    comdlg32.ocx
    mscomctl.ocx

    I think these are the ones you're talking about.

  31. #31
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Nope, those are for VB6 and not CR. Maybe search on businessobjects again for info pertaining to CR 9 and the viewer as it has to be there if you have the control on your form. It will be named the same as the component you added to your toolbox when you built your app.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  32. #32

    Thread Starter
    Fanatic Member
    Join Date
    Sep 2002
    Posts
    779

    Re: using cr 9 in vb apps

    I use the Crystal Report Viewer Control 9 which utilizes the crviewer9.dll. I have this dll already included.

  33. #33
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: using cr 9 in vb apps

    Try using Depends.exe on the crviewer9.dll andd see what special already not included files you need. Note it will pickup system api dependancies like user32.dll which you dont need to include.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width