Results 1 to 14 of 14

Thread: Crystal Reports 9 & VB6 help required

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    7

    Crystal Reports 9 & VB6 help required

    Hi , I am in a deep mess. I need help with VB6 . I want to use Crystal Reports 9 with VB 6 , but have no clue how to use it and how to call the report in VB6.I know how to use data reports , but crystal reports is new to me.

    Please can anyone suggest me the steps in doing so , or a tutorial for the steps.

    PLEASE I NEED HELP ASAP.

    Thanks ,
    Muneer

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

    Re: Crystal Reports 9 & VB6 help required

    Welcome to the Forums.

    After you have created your report you can view it using the CR Viewer control on a form in VB6. I have a small example in my signature.
    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

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    7

    Re: Crystal Reports 9 & VB6 help required

    Thanks dude, u saved my valuable time . God Bless u

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

    Re: Crystal Reports 9 & VB6 help required

    Thanks If you have any other questions on this just post back.
    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

  5. #5

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    7

    Exclamation Re: Crystal Reports 9 & VB6 help required

    Dude i have another problem , i just installed crystal reports 9 on my home pc (i installed crystal reports9 on my office pc in the morning).when i add a data enviroment and set the properties for a connection(e.g. connection1) i get a message stating "MISSING MICROSOFT DATA SOURCE LOCATOR"

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

    Re: Crystal Reports 9 & VB6 help required

    Do you have MDAC installed? What OS are you running? I dont use the DE as its old and cumbersome.
    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

  7. #7

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    7

    Re: Crystal Reports 9 & VB6 help required

    I am using Wiondows XP Professional Sp1(version 2002).

    The VB6 i am using was working perfectly fine before i installed crystal reports 9.

    I am just scared that this factor about the message"MISSING MICROSOFT DATA SOURCE LOCATOR" shouldnt affect my ADO, RDO ,etc connections or files

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

    Re: Crystal Reports 9 & VB6 help required

    I couldnt find anything on it either at CR's website - businessobjects.com or via google search.
    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

  9. #9

    Thread Starter
    New Member
    Join Date
    Jul 2006
    Posts
    7

    Re: Crystal Reports 9 & VB6 help required

    Thanks anyways --- i tried to do a google search but coudlnt find anything .

    Thanks for all the help

  10. #10
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal Reports 9 & VB6 help required

    Quote Originally Posted by Muneer_B
    Hi , I am in a deep mess. I need help with VB6 . I want to use Crystal Reports 9 with VB 6 , but have no clue how to use it and how to call the report in VB6.I know how to use data reports , but crystal reports is new to me.

    Please can anyone suggest me the steps in doing so , or a tutorial for the steps.

    PLEASE I NEED HELP ASAP.

    Thanks ,
    Muneer
    Lots of examples here..

    http://support.businessobjects.com/f...ch/default.asp

    ETA: I had this once and had to reinstall the latest MDAC. When I went to the latest version the error went away. I think it's 2.8 now. Download it and install it from the MS website.
    Last edited by King_George; Jul 18th, 2006 at 02:49 PM.
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

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

    Re: Crystal Reports 9 & VB6 help required

    When searched for the error message I get - "No results were found." for "MISSING MICROSOFT DATA SOURCE LOCATOR".

    Perhaps you could link to a page with an exact solution?
    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

  12. #12
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal Reports 9 & VB6 help required

    Quote Originally Posted by RobDog888
    When searched for the error message I get - "No results were found." for "MISSING MICROSOFT DATA SOURCE LOCATOR".

    Perhaps you could link to a page with an exact solution?
    I wish I could. I simply took a stab at doing something and it apparently did the trick for me. I have no idea why.

    I searched everywhere and I never found an answer either.
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

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

    Re: Crystal Reports 9 & VB6 help required

    Yes, I was also thinking MDAC as the culprit as in post #6 but depending on how the connection is being setup its probably missing either MDAC, reference to MDAC, or ????
    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

  14. #14
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal Reports 9 & VB6 help required

    Quote Originally Posted by RobDog888
    Yes, I was also thinking MDAC as the culprit as in post #6 but depending on how the connection is being setup its probably missing either MDAC, reference to MDAC, or ????
    Perhaps the OP could post the connection string???
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

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