Results 1 to 1 of 1

Thread: Display Problems with datareport

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    May 2006
    Posts
    58

    Display Problems with datareport

    Hi guys.
    I have set the data source of a data report but it is being displayed whithout i tell it to show(rptdeposit.show).
    VB Code:
    1. Set pbRst = RstSel("SELECT RESERVATION.MemberShipId, RESERVATION.SerialNo, CATALOGUE.Title, MEDIA.MediaType, RESERVATION.Deposit FROM CATALOGUE INNER JOIN _
    2. (RESERVATION INNER JOIN MEDIA ON RESERVATION.SerialNo=MEDIA.SerialNo) ON CATALOGUE.CatId=MEDIA.CatId WHERE reservation.serialno in ( " & ssql & ")")
    3.         If Not pbRst.EOF And Not pbRst.BOF Then
    4.             Set rptdeposit.DataSource = pbRst
    5.             rptdeposit.Sections("Section5").Controls.Item("lblrstotal").Caption = total
    6.            
    7.                        
    8.         End If

    How can i solve this guys?
    btw i'am on vb6 using an access database

    thanks for your cooperation
    Last edited by roubesh14; Jun 11th, 2006 at 03:45 PM.

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