Crystal Reports/MS Access

Posted on 1998-06-04
Medium Priority
Last Modified: 2010-05-03
Is there a procedure to capture MS Access DB Reports into Crytal Reports?  Or a procedure to 'query' the MS Access DB report information using VB?
Question by:BWATERS

Expert Comment

ID: 1462549
I don't think that there is any procedure for capturing the MS Access DB Reports into Crystal Reports.  Actually, we can call the reports done in MS Access from Crystal Reports.  Through VB we could write a procedure to query the MS Access DB report information.

Author Comment

ID: 1462550
Sounds good to me! I know it's two questions...but you brought it up.  How can Crystal Report call the MS Access reports, and what would be the query in VB to do same?  Another 50 pts. into the pot.
Please wait for vamsi_k to respond.

Expert Comment

ID: 1462551
There is now such thing as to transform the reports from access format to Cristal reports.

You can call an Access report from VB, for that you need to have the access installed in the same machine.

Another way you can call an Access report from VB is by using the VSReports from videosoft, this Control reads an Access report and open it in VB environment without the need for Access.

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.


Expert Comment

ID: 1462552
If you really want to see something cool, check out ActiveReports from Data Dynamics. If forget the URL. They have a new product which mimics the Access report generator, but runs as a VB designer.

Expert Comment

ID: 1462553
The site for Data Dynamics is www.datadynamics.com

Active Reports it's a great report generator, use it if you do not need to mantain compatibility with Access Reports, but if you need to maintain that compatilibity you must use VSReports: www.videosoft.com

Accepted Solution

chdy earned 500 total points
ID: 1462554
Option Explicit

Dim YY$, Y$

Private Sub cmdStart_Click()
Dim RFormula$

YY = Text1.Text

RFormula = "{post.sGuGun}" & " like " & "'" & YY & "'"

MsgBox RFormula

cryTest.Formulas(0) = "sTitle = '" & Text3.Text & "'"  'Title. Nothing Mean

cryTest.SelectionFormula = RFormula

cryTest.Action = 1

End Sub

Private Sub Form_Load()
Data1.DatabaseName = "C:\Zip\Seoul.mdb"  'Very important ... ^.^

cryTest.ReportFileName = "C:\DevStudio\VB\sample.rpt"

End Sub

I want to sufficent answer.. Sorry! I'm korean because novice in english


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

597 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