Solved

Visual Studio Project Crystal Reports from a directory?

Posted on 2015-02-12
6
204 Views
Last Modified: 2015-02-13
We're working with an older Visual Studio client based program that had Crystal Reports within the software that pointed to data definition files.

We brought the reports out of the software and hooked them up to run from the stored procedure, but I've never coded a project to call a crystal report from an ntfs directory (outside the software).

Can anyone give me pointers or show me some articles that would assist?
0
Comment
Question by:urthrilled
  • 3
  • 3
6 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40606904
What are you going to run them in?

Are you running in the Crystal designer?
You should just have to create a connection to the new data source and point (SET DATASOURCE) the reports to the source.

mlmcc
0
 
LVL 4

Author Comment

by:urthrilled
ID: 40606911
Currently, they are an rpt file (Crystal XI sp6) in a directory.  I'd like to run them from the program and use the Crystal viewer locally to see them?

Doris
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40606945
What program?

Is this an existing Crystal viewer that allows you to select reports?
Is this a program you want to write?

mlmcc
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 4

Author Comment

by:urthrilled
ID: 40608462
The program is custom Visual Studio built client based program.  Originally created in Visual Studio 2003, then converted to Visual Studio 2012.

The Crystal Reports were created in the Visual Studio Crystal Report addin and used data definition files.  There are over 50 reports in the program and every time the users want any kind of formatting or any change to the report, it requires rebuilding and reinstalling the clients.

We want to build the software to point to the Crystal Report (now running on stored procedures from Crystal XI sp6) so that we can make formatting changes to the reports without having to rebuild the software.

Our Company's financial software runs this way, there is a form to add reports so they will show up on the software's menu.  The current custom program we're working on doesn't have to provide a form to change the menu to be able to add reports, we just want to have the reports reside outside of the program, but run through the program.

Thank you for any insight you can lend!
Doris
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40608849
I believe this is what you want

'Implies you have imported CrystalDecisions.CrystalReports.Engine
Private mrptDoc As New ReportDocument
'Load the standalone report
mrptDoc.Load(Forms.Application.StartupPath & "\rptTest.rpt")
'Pass the Report Document object to the viewer
CrystalReportViewer1.ReportSource = mrptDoc

Open in new window


I got the code from a good article on passing the dataset to the report
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

mlmcc
0
 
LVL 4

Author Closing Comment

by:urthrilled
ID: 40608960
Thank you so much for taking the time to understand my situation and coming up with great, helpful information!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Let’s list some of the technologies that enable smooth teleworking. 
Skype is a P2P (Peer to Peer) instant messaging and VOIP (Voice over IP) service – as well as a whole lot more.
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

947 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

22 Experts available now in Live!

Get 1:1 Help Now