Solved

Visual Studio Project Crystal Reports from a directory?

Posted on 2015-02-12
6
217 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

If your app took Google’s lash recently, here are the 5 most likely reasons.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Viewers will learn how to use the Hootsuite Dashboard.

808 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