Solved

Access Reports vs Data Reports

Posted on 2003-11-04
7
325 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Link a textbox in excel to a cell with more than 255 characters. 5 67
Windows Script Host failed (Access is denied.) error 6 108
Adding to a VBA? 6 61
Child Form in front 4 38
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now