Results 1 to 2 of 2

Thread: [RESOLVED]report cannot refresh data

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    33

    Resolved [RESOLVED]report cannot refresh data

    hello,
    i make a report using crystal report designer 8.5 and VB6.In first run, the report display the data i want.secondly i change the tangggal variable and operator variable but it doesnt display new data .here is my code :
    VB Code:
    1. Option Explicit
    2. Dim Report As New rpt_total_penambahan
    3. Dim tanggal, operator As String
    4.  
    5. Private Sub Form_Load()
    6. Screen.MousePointer = vbHourglass
    7. crv_total_penambahan.Zoom (100)
    8. tanggal = total_penambahan.cmb_tanggal.text ' date
    9. operator = total_penambahan.cmb_operator.text ' string
    10. Unload total_penambahan
    11. Call init_database
    12. rs.Open "SELECT * from qry_total_penambahan where tanggal_entry=#" + tanggal + "# and operator='" + operator + "'order by departemen", con, adOpenKeyset, adLockPessimistic
    13. Report.Database.SetDataSource rs
    14. crv_total_penambahan.ReportSource = Report
    15. crv_total_penambahan.ViewReport
    16. Screen.MousePointer = vbDefault
    17. End Sub
    18.  
    19. Private Sub Form_Resize()
    20. crv_total_penambahan.Top = 0
    21. crv_total_penambahan.Left = 0
    22. crv_total_penambahan.Height = ScaleHeight
    23. crv_total_penambahan.Width = ScaleWidth
    24.  
    25. End Sub

    thanks for your help
    Last edited by little_mouse; Aug 4th, 2005 at 10:22 AM. Reason: resolved
    everything is possible

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