Click here to Skip to main content
15,851,510 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralVB.NET form location Pin
Joe Surls10-Apr-08 17:54
Joe Surls10-Apr-08 17:54 
GeneralRe: VB.NET form location Pin
Christian Graus10-Apr-08 18:40
protectorChristian Graus10-Apr-08 18:40 
GeneralRe: VB.NET form location Pin
Joe Surls10-Apr-08 18:52
Joe Surls10-Apr-08 18:52 
GeneralRe: VB.NET form location Pin
Herl the Pearl11-Apr-08 0:41
Herl the Pearl11-Apr-08 0:41 
Generalweb based application Pin
shee_dee8610-Apr-08 16:58
shee_dee8610-Apr-08 16:58 
GeneralRe: web based application Pin
LloydA11110-Apr-08 18:08
LloydA11110-Apr-08 18:08 
GeneralRe: web based application Pin
Christian Graus10-Apr-08 18:30
protectorChristian Graus10-Apr-08 18:30 
GeneralVS 2005 VB - MS ACCESS 2007 - Crystal Report XI R2 "Error: Logon failed.." Please help!! [modified] Pin
vbDigger'z10-Apr-08 15:33
vbDigger'z10-Apr-08 15:33 
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
******************
<br />
Private Sub myReportForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        Try<br />
            ChildFormAutoSizeFit(Me)<br />
            Me.Cursor = Cursors.WaitCursor<br />
            Me.MdiParent = frmMain<br />
<br />
            crxApp = New CRAXDRT.Application<br />
<br />
            crxReport = crxApp.OpenReport(strCRSourcePath, CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault)<br />
<br />
            crxDataBase = crxReport.Database<br />
            crxTables = crxDataBase.Tables<br />
<br />
            For Each crxTable In crxTables<br />
                crxTable.Location = DataSource 'My .mdb source path<br />
                crxTable.SetLogOnInfo("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & crxDataBasePath, "myDatabase.mdb", "", "myPassword")<br />
            Next crxTable<br />
<br />
'**** Note:<br />
  'When ever i used this recordSelectionFormula? it works properly<br />
  'and it get connected and show the report but then this<br />
  'recordSelectionFormula is something limited for filtering data thats<br />
  'why i need to use more flexible filter like CRXDRT.Report.SqlQueryString<br />
  'but then my problem is the login connection from the database is somewhat failed...<br />
'****<br />
<br />
            'this RecordSelectionFormula works<br />
            'crxReport.RecordSelectionFormula = strSelectionfrm<br />
<br />
            'this SQLQueryString failed.. why?? what's the different?<br />
            crxReport.SQLQueryString = strSqlQuery<br />
<br />
            AxCRViewer1.ReportSource = crxReport<br />
            AxCRViewer1.ViewReport()<br />
<br />
        Catch ex As Exception<br />
            MsgBox(ex.ToString())<br />
        Finally<br />
            Me.Cursor = Cursors.Default<br />
        End Try<br />
    End Sub<br />
<br />


************

here's my "strSelectionfrm"
***************
<br />
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") & "#"<br />


*****************

and here's my "strSqlQuery"
*************

<br />
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 '*'"<br />

*****************

Please anybody can help or any idea with this?...
Please????...
a lot of appreciation in advance....
Thanks....
GeneralID3v2 tag size not sync byte Pin
clusto10-Apr-08 12:35
clusto10-Apr-08 12:35 
GeneralText Box and String Manipulation Pin
Debi 10-Apr-08 11:39
Debi 10-Apr-08 11:39 
GeneralRe: Text Box and String Manipulation Pin
Dave Kreskowiak10-Apr-08 13:37
mveDave Kreskowiak10-Apr-08 13:37 
GeneralRe: Text Box and String Manipulation Pin
Luc Pattyn10-Apr-08 13:44
sitebuilderLuc Pattyn10-Apr-08 13:44 
GeneralRefreshing the program Pin
mykingdomforanewusername10-Apr-08 8:45
mykingdomforanewusername10-Apr-08 8:45 
GeneralRe: Refreshing the program Pin
Dave Kreskowiak10-Apr-08 10:24
mveDave Kreskowiak10-Apr-08 10:24 
GeneralRe: Refreshing the program Pin
Luc Pattyn10-Apr-08 12:04
sitebuilderLuc Pattyn10-Apr-08 12:04 
Generalresponse.redirect Pin
screwfunk0110-Apr-08 8:37
screwfunk0110-Apr-08 8:37 
GeneralRe: response.redirect Pin
jzonthemtn10-Apr-08 8:43
jzonthemtn10-Apr-08 8:43 
GeneralRe: response.redirect Pin
Herl the Pearl11-Apr-08 0:44
Herl the Pearl11-Apr-08 0:44 
Questioninsert time..can any1 teach me.. [modified] Pin
Member 444291610-Apr-08 6:42
Member 444291610-Apr-08 6:42 
GeneralRe: insert time..can any1 teach me.. Pin
Dave Kreskowiak10-Apr-08 8:23
mveDave Kreskowiak10-Apr-08 8:23 
GeneralRe: insert time..can any1 teach me.. Pin
Christian Graus10-Apr-08 14:35
protectorChristian Graus10-Apr-08 14:35 
GeneralRe: insert time..can any1 teach me.. Pin
Dave Kreskowiak10-Apr-08 17:03
mveDave Kreskowiak10-Apr-08 17:03 
QuestionHow can I monitoring dial and how to Disconnect for POCKET PC Pin
smsm365010-Apr-08 5:59
smsm365010-Apr-08 5:59 
AnswerRe: How can I monitoring dial and how to Disconnect for POCKET PC Pin
Dave Kreskowiak10-Apr-08 10:53
mveDave Kreskowiak10-Apr-08 10:53 
GeneralRe: How can I monitoring dial and how to Disconnect for POCKET PC Pin
smsm365010-Apr-08 13:23
smsm365010-Apr-08 13:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.