Solved

Set Crystal Report Data Source to Application Startup Path

Posted on 2006-11-13
2
361 Views
Last Modified: 2008-03-06
This seems like it should be a simple thing to do, but I've been wrestling with this for hours.

Just need to set the DataSource for my Crystal Reports to my Application Startup Path.

All of my information for the report is calculated and dropped into a single table for a CR to display.

When I set this up at design time, everything works fine, but need to work when deployed by pointed at application startup path.

Thanks!!
0
Comment
Question by:kerryw60
2 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
ID: 18071426
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Private Sub myFormName_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Dim rep As New myReportName()
    Dim t As New TableLogOnInfo
    t.ConnectionInfo.DatabaseName = My.Application.Info.DirectoryPath.Replace("C:\OLD DATABASE PATH", Application.StartupPath) & "\myAccess.mdb"
    t.ConnectionInfo.UserID = ""
    t.ConnectionInfo.Password = ""
    rep.Database.Tables(0).ApplyLogOnInfo(t)
    myCrystalReportViewer.ReportSource = rep
End Sub
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
0
 
LVL 6

Author Comment

by:kerryw60
ID: 18071665
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
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 …

803 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