asked on

Access Reports vs Data Reports

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?

flyers_pat

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/

sjmmajor

ASKER

So in other words don't use the Data Reports for this? It would more be for basic data display?

Mike McCracken

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

ASKER CERTIFIED SOLUTION

flyers_pat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mike McCracken

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

sjmmajor

ASKER

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.

Mike McCracken

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