Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CrystalReport in Visual Basic

Posted on 2011-09-08
1
393 Views
Last Modified: 2012-05-12
I have a visual basic.net (2008) that will run Crystal Reports against a sql database.  This works fine.  I can not get Visual baisc to run a crystal report against a Visual FoxPro database / table.  There is only one table linked to the report.  The crystal report runs fine in the Crystal Report developer.  All connections are made and the information is updated and correct.  If I do not use the "refresh" in the VB code, the viewer will pull the last report run and display it.  If the "refersh" is added (see the attached code), it pops up and ask for log in information.  Everything that I have tried gives me the "Log On Failed" box.  I am trying to supply the correct connection information in the code, but nothing works.  I think foxpro does not require a uer id or passwork (?).  Again the Crystal Report runs fine in the developer.  My code is below.  Thanks for any help


Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

Public Class Form1
    ' Added reference to CrystalDecisions.CrystalReports.Engine
    ' Added reference to CrystalDecisions.ReportSource
    ' Added reference to CrystalDecisions.Shared

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim icon As String
        Dim strreportname As String = "g:\Ft9 reports - 2008\employee_list_test.rpt"
        Dim ii As CrystalDecisions.Shared.TableLogOnInfo
        Dim ci As CrystalDecisions.Shared.ConnectionInfo
        Dim cr As New CrystalDecisions.CrystalReports.Engine.ReportDocument


        cr.Load(strreportname)
        cr.Refresh()
        CrystalReportViewer1.ReportSource = cr
        CrystalReportViewer1.Visible = True

        ii = cr.Database.Tables(0).LogOnInfo
        ci = ii.ConnectionInfo
        icon = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=f:\gashouse\maint.dbc;Exclusive=No;"
        icon = icon & "NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO"
        ci.ServerName = icon
        ci.DatabaseName = "maint"
        ci.UserID = ""
        ci.Password = ""
        ci.IntegratedSecurity = False

        cr.Database.Tables(0).ApplyLogOnInfo(ii)

    End Sub
0
Comment
Question by:Tomwo
1 Comment
 
LVL 29

Accepted Solution

by:
Olaf Doschke earned 500 total points
ID: 36508466
The login might be a windows dialog asking for login to the directory f:\gashouse\. While VFP does not have any security aspects, the file system has.

I don't have crystal to check how it would behave. Using VFP to connect to a dbc in a folder I have removed access rights, I don't get a connection, but also no dialog. Instead VFP get's an ODBC error and the ODBC driver error message simply is: "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file c:\secure\secure.dbc"

If setting file/folder access permissions does not work out, then what version is the {Microsoft Visual FoxPro Driver} you use?

Bye, Olaf.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question