Solved

CrystalReport in Visual Basic

Posted on 2011-09-08
1
390 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now