Results 1 to 6 of 6

Thread: [RESOLVED] 3 Copies of same Crystal report

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Resolved [RESOLVED] 3 Copies of same Crystal report

    I am using VB6, CR 8.5 and Access database. I have a want to print 3 copies of same invoice with title 1. Original 2. Duplicate 3. Triplicate with crystal report CrInv which has text object text1 on my report. when i press "Print" button from my VB form i want to print 3 copies with text1 field value as "Original, "Duplicate and Triplicate". How can I do this?

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

    Re: 3 Copies of same Crystal report

    Create another parameter and use it on the report where you want it to display "Original" etc. Then when you open your report you pass the appropriate value. Thiis will work if your performing a loop with the .PrintOut method.
    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
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Re: 3 Copies of same Crystal report

    i dont know how to perform a loop with .PrintOut method can you please help me?

  4. #4

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Re: 3 Copies of same Crystal report

    Can you please write codes in vb to print 3 copies of CRInv ?

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

    Re: 3 Copies of same Crystal report

    I have a couple of code examples in my signature and more on the forums.

    Look at - VB6/CR Print Dialog Ex.


    VB Code:
    1. '...
    2. '...
    3. Dim i As Integer
    4. For i = 1 To 3
    5.     'Set Orig. Copy, Trip etc here by passing param.
    6.     '...
    7.     'Open Report/Refresh
    8.     oReport.PrintOut True, 1
    9. Next
    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

  6. #6

    Thread Starter
    Member
    Join Date
    Mar 2001
    Location
    India
    Posts
    34

    Re: 3 Copies of same Crystal report

    Thans RobDog888 this will solve my prob...

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