TIME DELAY WAITING FOR REPORT!

[johnvai]

I was wondering how can i decrease the time for the report to be shown from the moment i ask it till it's ready.

I have a VB interface that imports to crystal reports Parameters like startdate and enddate. the time for the report to appear it's way too much comparing to the time needed from crystal (design mode) or comparing to a list that doesn't need parameters.

I have a sybase anywhere adaptive database.

Another question is, I have a field in the table of timestamp datatype. I am asking the crystal report to show me all the records between two parameters of DateTime datatype in crystal. it's not working for the same date but different time.

Example: system Format(dd/MM/yyyy)
1-2003/10/11 7:13:42
2-2003/10/11 7:25:14
3-2003/10/11 13:36:25

asking all the records from 2003/10/11 7:00:00 AM to 2003/10/11 11:59:59 Pm is giving nothing.
blank report, therefore it works if I ask it from 2003/10/11 7:00:00 AM to 2003/10/12 12:00:00 am

I need your help!

 

[synapsevampire]

You probably aren't getting the SQL passed to the database properly as a result of this parameter passing. Please consider posting more information, such as connectivity used, versions of CR/VB used, and the code.

-k

 

[johnvai]

Public Crystal As New CRAXDRT.Application
Public CReport As CRAXDRT.Report 'Type of CReport


Private Sub LoadReport()
Dim ReportPathFile As String
Screen.MousePointer = vbHourglass
ReportPathFile = "C:\Active Products Listing.rpt"
Set CReport = Crystal.OpenReport(ReportPathFile)
CReport.Database.Tables (1).SetLogOnInfo "POS", "POS.DB", "dba", "6things"
CReport.DiscardSavedData
' Set the Parameters for the Report
'Sdate and edate are datetime values to be sent to the prameteters in crystal version 8
CReport.ParameterFields(1).AddCurrentValue SDate
CReport.ParameterFields(2).AddCurrentValue EDate
CRViewer1.ReportSource = CReport
CRViewer1.ViewReport
Me.WindowState = vbMaximized
CRViewer1.DisplayGroupTree = True
CRViewer1.EnableGroupTree = True
CRViewer1.Zoom 100
Screen.MousePointer = vbDefault
End Sub

the version of VB is 6

Your help is greatly appreciated!