Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

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?  

0
sjmmajor
Asked:
sjmmajor
  • 3
  • 2
  • 2
1 Solution
 
flyers_patCommented:
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
 
sjmmajorAuthor Commented:
So in other words don't use the Data Reports for this?  It would more be for basic data display?
0
 
mlmccCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
flyers_patCommented:
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
 
mlmccCommented:
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
 
sjmmajorAuthor Commented:
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
 
mlmccCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now