Results 1 to 8 of 8

Thread: Reports using CR9

Threaded View

  1. Jul 13th, 2006, 03:57 AM #1
    Simply Me
    Simply Me is offline

    Thread Starter
    PowerPoster Simply Me's Avatar
    Join Date
    Aug 2003
    Posts
    2,748

    Reports using CR9

    I have this code to view my report. Im concerned with the time it takes to load the report when i view it. I have more or less ten pages of report in short bond paper. Is there any solution or alternative to using crystal report?

    VB Code:
    1. Private Sub Form_Load()

    2.   Call openConnection

    3.   Me.Left = 2640

    4.   Me.Top = 325

    5.   

    6.   sSQL = "SELECT Code, ProductDescription,Quantity,Reorder FROM Tblstocks"

    7.   

    8.   Set oRsStocks = New ADODB.Recordset

    9.   Set oRsStocks = oConn.Execute(sSQL)

    10.   Set oApp = New CRAXDRT.Application

    11.   Set oReport = oApp.OpenReport(App.Path & "\Inventory.rpt", 1)

    12.   oReport.Database.SetDataSource oRsStocks, 3, 1

    13.   CRViewer91.ReportSource = oReport

    14.   oReport.DiscardSavedData 'to refresh the data

    15.   CRViewer91.ViewReport

    16.  
    17. End Sub
    Last edited by Simply Me; Jul 13th, 2006 at 04:01 AM.
    To give is always to be NOBLE...
    To received is always to be BLESSED....
    Each day strive to be NOBLE
    Each day strive to be BLESSED

    If this post has helped you. Please take time to rate it.

    >=|+|=< Simply Me >=|+|=<
    ----------------------------------------
    Connection Strings | Number Only in Textbox | Splash Screen with Progress Bar | Printing to 1/2 of perforated bond paper |
    Freeze 2005 DataGridView Column
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width