Results 1 to 10 of 10

Thread: need help with crystal report viewer and no database

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    159

    need help with crystal report viewer and no database

    So far i've been working with a crystal report connected to a database.
    the problem is that i register data in a form and i don't want it to be saved in the database ..I wonder if it is possible to load a crystal report with data from a textbox, a combobox before saving the data
    for example when you register a documentyou want to see a preview (the document ) before saving the data
    I'm not sure how to do that
    Should i use richtextbox... if I do so How??
    please send me some examples
    THANX

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

    Re: need help with crystal report viewer and no database

    Welcome to the Forums.

    I just posted some code on CR, but its using VB6. You should be able to get the mechanics for using the Viewer control.

    HTH
    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
    Addicted Member
    Join Date
    Feb 2005
    Posts
    159

    Re: need help with crystal report viewer and no database

    No that's not what i want.
    I have some data in a textbox and i want to see it in a paper (richtextbox)or in a crystal record before loading the information in a database
    Please in .net
    any help

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

    Re: need help with crystal report viewer and no database

    You can create an ADO recordset with your data on your form as an rs in memory. Then pass the rs to
    the CR as the .ReportSource for the report.
    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
    Addicted Member
    Join Date
    Feb 2005
    Posts
    159

    Re: need help with crystal report viewer and no database

    can you send me an exmaple please i would really appreciate it

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

    Re: need help with crystal report viewer and no database

    Hmm.. What about placing the data in a temp table. Then show the report from there. If the user changes
    their mind you can easily delete it.
    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
    Addicted Member
    Join Date
    Feb 2005
    Posts
    159

    Re: need help with crystal report viewer and no database

    i am trying to do that

    how do i place the data?? i am not very good at crystal report

    EXAmple:

    Crystalreport1:


    Dr MR _______(texbox1.text)

    You are wlcome to enter to the program :_____________(textbox2.text)


    Greettings
    _____________(textbox3.text)

  8. #8
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373

    Re: need help with crystal report viewer and no database

    you can use parameters for that then... just create parameters in the report and put them where those spaces are...

    then when you are going to generate the report in your code and display it/print it whatever...

    you write code to pass the params in..

    rptMyReport.SetParameterValue("CustomerName",Texbox1.Text)

    where customername is the name of the param in the report... since it sounds like you are not producing a report that has row after row of data, this is probably the best route for you...

  9. #9

    Thread Starter
    Addicted Member
    Join Date
    Feb 2005
    Posts
    159

    Resolved Re: need help with crystal report viewer and no database

    Excellent my friend
    that was what i wanted

    I finally resolved my problem

  10. #10
    I'm about to be a PowerPoster! kleinma's Avatar
    Join Date
    Nov 2001
    Location
    NJ - USA (Near NYC)
    Posts
    23,373

    Re: need help with crystal report viewer and no database

    glad to hear.. CR can be your best friend or worst nightmare in .net

    www.businessobjects.com is their website and they have a good amount of help/support/samples on there so if you run into more problems, you can check there as well as post here..

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