• How to Set Subreport Column Visible False? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » How to Set Subreport Column Visible False? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    Author
    Topic
    WSSupport4John
    AskWoody Lounger
    July 12, 2008 at 3:17 am #452384

    I have a report with Subreport.

    I use this Report to print two types of transactions:

    Subreport Transaction type 1, I want to print:

    Date Invoice Type Amount

    Subreport Transaction type 2, I want to print:

    Date Invoice          Amount

    In the Report section I know which type of transaction I’m dealing with and would like some code to set the Subreport Type column visible = false

    Where and how does it go?

    Thanks, John

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      July 12, 2008 at 3:24 am #1116843

      You can put code in the On Format event of the section that contains the Type control, e.g.

      Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
      Me.Type.Visible = (SubreportTransactionType = 1)
      End Sub

      where SubreportTransactionType is the name of the variable or control that determines the transaction type.

      Reply | Quote
      • WSSupport4John
        AskWoody Lounger
        July 12, 2008 at 9:28 am #1116874

        That did it, for others here is the code to remove the labels

        Thank, John

        Private Sub Report_Open(Cancel As Integer)
    
If gloGetValue("TypeOfCheck") = "VENDOR" Then
    Me.PatientLabel.Caption = ""
    Me.MemberLabel.Caption = ""
    Me.BenefitLabel.Caption = ""
    Me.FeeLabel.Caption = ""
End If
    
End Sub

        Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If gloGetValue("TypeOfCheck") = "VENDOR" Then
    Me.curTBEN.Visible = False
    Me.curTBenTotal.Visible = False
    Me.curTFEE.Visible = False
    Me.curFeeTotal.Visible = False
End If

End Sub
        Reply | Quote
    Viewing 0 reply threads
    Reply To: How to Set Subreport Column Visible False? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.