on 04-11-2008 12:04 PM
Is there anybody there have an idea to resolve this vb to crystalreport XI connection problem...
Im using VS2005 VB and MS ACCESS '07 and Crystal Report XI R2
Here's my code
******************
Private Sub frmCrystalReport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
ChildFormAutoSizeFit(Me)
Me.Cursor = Cursors.WaitCursor
Me.MdiParent = frmMain
crxApp = New CRAXDRT.Application
crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault)
crxDataBase = crxReport.Database
crxTables = crxDataBase.Tables
For Each crxTable In crxTables
crxTable.Location = DataSource 'My .mdb source path
crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & crxDataBasePath, "dbEmployee.mdb", "", "00019136392852")
Next crxTable
'**** Note:
'When ever i used this recordSelectionFormula? it works properly
'and it get connected and show the report but then this
'recordSelectionFormula is something limited for filtering data thats
'why i need to use more flexible filter like CRXDRT.Report.SqlQueryString
'but then my problem is the login connection from the database is somewhat failed...
'****
'this RecordSelectionFormula works
'crxReport.RecordSelectionFormula = strSelectionfrm
'this SQLQueryString failed.. why?? what's the different?
crxReport.SQLQueryString = strSqlQuery
AxCRViewer1.ReportSource = crxReport
AxCRViewer1.ViewReport()
Catch ex As Exception
MsgBox(ex.ToString())
Finally
Me.Cursor = Cursors.Default
End Try
End Sub
************
here's my "strSelectionfrm"
***************
strSelectionfrm = "{CmpnyDetails.IDNo} like '*' and {tblCompanyDetails.Status} = 'REGULAR' and {Attendance.AFrom} in #" & Format(DatePickerFrom.Value, "MM/dd/yyyy") & "# to #" & Format(DatePickerTo.Value, "MM/dd/yyyy") & "#"
*****************
and here's my "strSqlQuery"
*************
strfilter = strfilter = "Select * from CmpnyDetails as cd left outer join Attendance as att on att.IDNo = cd.IDNo where (att.AFrom Between #" & Format(DatePickerFrom.Value, "MM/dd/yyyy")
& "# and #" & Format(DatePickerTo.Value, "MM/dd/yyyy") & "#) and cd.[Status] = 'REGULAR' and cd.IDNo like '*'"
*****************
Please anybody can help or any idea with this?...
Please????...
a lot of appreciation in advance....
Thanks....
Moved to Crystal Reports RDC.
You are using RDC, not CR.NET so I have moved it to the COM forum.
Good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.