Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Visual Studio Project Crystal Reports from a directory?

Posted on 2015-02-12
6
Medium Priority
?
246 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 101

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 101

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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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 101

Accepted Solution

by:
mlmcc earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
The main intent of this article is to make you aware of ‘Exchange fail to mount’ error, its effects, causes, and solution.
Progress
Introduction to Processes

609 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