Solved

Visual Studio Project Crystal Reports from a directory?

Posted on 2015-02-12
6
199 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
Comment Utility
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
Comment Utility
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
Comment Utility
What program?

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

mlmcc
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 4

Author Comment

by:urthrilled
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you so much for taking the time to understand my situation and coming up with great, helpful information!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

A short article about problems I had with the new location API and permissions in Marshmallow
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
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.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

771 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

9 Experts available now in Live!

Get 1:1 Help Now