Solved

Crystal Reports viewing

Posted on 2003-11-04
11
438 Views
Last Modified: 2010-05-01
How do I go about setting up viewing CR 8.5 in a VB6 application?  These reports will already be designed.  I want them to refresh and viewed and/or printed from my application.

0
Comment
Question by:sjmmajor
  • 3
  • 3
  • 3
  • +1
11 Comments
 
LVL 1

Expert Comment

by:flyers_pat
ID: 9680956
If CR is installed, open a VB ptoject, click on Project -> Add Crystal Reports 8.5, design your report.  You have to join the source of the data with the designer (access database, sql, etc.)  For more infos go to:

http://www.vbexplorer.com/VBExplorer/vb_feature/august2000/using_crystal_reports.asp
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9681281
Which editioin of Crystal 8.5 do you have?  You need the developer edition to call reports from VB.

Here is a sample
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/SimpleDemo.zip.asp

mlmcc
0
 
LVL 1

Expert Comment

by:flyers_pat
ID: 9681337
well if you want to be able to show or print a report from vb6, yes you do need the developer edition...
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:sjmmajor
ID: 9682868
I am on a different computer right now but I have CR 8.5.  I don't know if it is developer edition or not.  I did develop a report.  What is the difference between the types?  I will develop the reports independant of VB6.  I just want to be able to display the reports and print them if needed.  Also is there a way to see the listing of reports available in the folder?  That way when a report is added then the VB6 app. there won't have to be any changes to the actual app.  They will just see the listing and select and preview or print?

I have increased the points.  This is the last part of the app that I have worked on for a year.  I want to get this completed.

Thanks
0
 
LVL 1

Expert Comment

by:Krelek200
ID: 9682947
Unfortunately you will need the Developer edition or the Advance edition of Crystal Reports V8.5.  Located in the Developer Edition is a help file that lists, along with documentation, which files need to be used and how to use them.  Everything that you are asking is provided in the Developer CR.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 9684113
>>I am on a different computer right now but I have CR 8.5.  I don't know if it is developer edition or not.  
To find out which you have.
1.  Look at the box or the CDs
2. Open Crystal.  Click HELP --> ABOUT ME

What is the difference between the types?  
The developer edition includes the dls required for deploying VB-Crystal applications on machines that don't have Crystal installed.  It also includes a license that allows you to distribute the Crystal dlls.  See this link for more detailed comparison.

http://www.crystaldecisions.com/products/crystalreports/default.asp

You can develop reports in any edition of Crystal.  You only need the developer edition on the machine with VB.

>>Also is there a way to see the listing of reports available in the folder?  
If you maintain a list in a database or file that VB can use to populate a combo box, yes you can do that.  I have 1 subroutine that does all my report displying including passing formulas, parameters, filters, etc.  The report name is passed and then the appropriate file is opened.

mlmcc
0
 

Author Comment

by:sjmmajor
ID: 9686219
I have standard edition.  So I want to be sure.  I have to have developers edition in order for VB6 to utilize the reports and distribute even though no one else will be created reports?  Standard won't help me at all?
0
 
LVL 1

Accepted Solution

by:
Krelek200 earned 250 total points
ID: 9686867
Standard edition is just for report creation and use.  Developer edition has the "RDC" (Report Designer Component) software and help files that Visual Basic needs in order to recognize and access a Crystal Report file.  There are some viewers out on the Internet that you can talk to the developer about, to see if you can utilize them in your software.

The best thing to do is just get an upgrade from CR 8.5 Standard to the CR 8.5 Developer.  I carry CR 8.5 Developer and CR 9.0 Advanced on my machine.  I had CR 8.5 Professional but I looked everywhere on how to build a distribution of a viewer for Crystal Reports.  I ended up developing my own for both CR 8.5 and 9.0.  That is why you have to read the fine print on some programs like Crystal Reports.

I hope this helps you a little bit.  I know it is not what you are looking for but we can't help you anymore because you only have Standard Edition.
0
 

Author Comment

by:sjmmajor
ID: 9687068
Thanks for everyone's help.  I see the picture a lot clearer now.  I will get the developers edition.

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9692044
Glad I could help

mlmcc
0
 
LVL 1

Expert Comment

by:Krelek200
ID: 9694298
Good Lunk in your endeavor

Krelek
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
using web browser with BING 40 132
MS Access - loop through contents of table and iteratively find/replace words from second table 6 80
vbModal 12 57
Problem to line 23 55
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

820 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