Solved

Access Reports vs Data Reports

Posted on 2003-11-04
7
329 Views
Last Modified: 2010-05-01
When I wrote a report in access and then displayed it through my VB6 app, it opened Access and displayed the whole database, tables, queries and reports.  I don't want the user to be able to see anything but the view of the report.  Is there a way to do this?  Also, that user may not actually have Access on their computers.  I then switched to Data Reports and it works well but it is limited on functions as far as I can see.  My goal is to print data from the Access database and calculate percentages off the sums of the fields.  Which way would you suggest to do this?  

0
Comment
Question by:sjmmajor
  • 3
  • 2
  • 2
7 Comments
 
LVL 1

Expert Comment

by:flyers_pat
ID: 9678828
get Crystal Reports, it's Data Reports in better but you'll have to spend some money... but con can get a demo (i think) at www.crystaldecisions.com/ 
0
 

Author Comment

by:sjmmajor
ID: 9678879
So in other words don't use the Data Reports for this?  It would more be for basic data display?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9681192
There is a version of Crystal on your VB CDs.  Locatioin is dependent on which version of VB or Studio.

I'll see if I can find the reference.

mlmcc
0
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 
LVL 1

Accepted Solution

by:
flyers_pat earned 500 total points
ID: 9681234
well it's just that Crystal Reports is the best on the market, i'm working for a software development company and i'm using it and it's great.  Currently the version is 8.5 i think

there's no reference for cr on Visual Studio 98, there were one for the old version but that's why DataReports was include in VS98...
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9681327
Here you go


HOWTO: Install Crystal Reports for Use in Visual Basic 6.0
http://support.microsoft.com/default.aspx?scid=KB;en-us;q193336


The version of Crystal Reports is 4.6.1.0

Located on your Visual Basic CD
dir: \Common\Tools\VB\CrysRept\Crystl32.exe

Which cd ?
  Product                        Disk
  -----------------------------------
   Visual Basic Professional      1
   Visual Basic Enterprise        1
   Visual Studio Professional     2
   Visual Studio Enterprise       3

I hope this helps

mlmcc
0
 

Author Comment

by:sjmmajor
ID: 9682830
Thanks.  I do have a copy of CR 8.5.  I hadn't used it before.  I installed it and you are right.  Just on the trial ones I did independant of VB, the reports are easy and are very visual.

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 9684002
Actually CR is up to version 9 and VS does still include Crystal it just doesn't install through the normal installation.  You must install it separately.

mlmcc
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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

828 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