?
Solved

Access Reports vs Data Reports

Posted on 2003-11-04
7
Medium Priority
?
337 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 101

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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Accepted Solution

by:
flyers_pat earned 2000 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 101

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 101

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

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.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

719 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