Solved

Visual Studio Project Crystal Reports from a directory?

Posted on 2015-02-12
6
221 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 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

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.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
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.
Viewers will learn how to use the Hootsuite Dashboard.

730 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