The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members! Already a Member?
Join your peers on the Internet's largest technical computer professional community. It's easy to join and it's free. Register now while it's still free! Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Students Click Here. I have created some crystal reports that I want to distribute to the users. The users do not have crystal reports on their computer. I want to package the crystal reports in the access application and package it. Access application will have a list box with all the reports and user will have to select one and click "Run report" button. What controls I need to pull into the access form?
Your help will be appreciated. Thanks very much in advance.. Kempes Registered User. Local time Today, Joined Oct 7, Messages Don't quote me on this but I beleive the software included something called info analyzer. I beleive this is a viewing tool that can be installed onto users machines purely to view saved data within a crystal report, but it would require somebody to generate the data first in order to save it.
Not sure if any licenses are required for the viewing tool. Other options would be Crystal enterprise, or Crystal Reports Distributer depending on the volume and regularity of reports.
Local time Today, Joined Feb 4, Messages On the access form insert the active x control called Crystal Reports Control.
I usually change the name of the control to CrystalReports go to properties on the control and go to the Other tab. After you insert the active x control on the form type the following code on whatever event you want to generate the report: CrystalReport. Perhaps you should ask it in a Crystal Reports newsgroup, or address it to their tech support. Alan Webb. Joriz, Seems like putting the cart before the horse. If you can get Crystal Reports to connect to and make available the data in Access, why bother with more?
I just thought there might be a "wizard' way to do it. David W. This is a Crystal Reports question, not an Access question. I doubt that it's possible. Why in the hell would you use a third-party report writer when you've got the Access report writer available to you directly?
Pieter Linden. If you want to create "snapshot" reports that won't change, you could output your reports to PDF Joriz wrote: Obviously im new with ms access.. You get me? Please feel free to ask more Q's. I'd like to give my users the ability to answer some of their own basic questions so they don't have to knock on my door for every small modification.
Reports that they create and like can then be incorporated into the set of standard reports. Follow Post Reply. Patrick Fisher. IMHO this is a nobrainer, use Access at no cost, assuming that you already have it, if you ever find something that you cannot do then may'be look at Crystal. The Access Report Generator is an excellent product for most reort types. Certainly if you already have one and not the other, the cost implications of the change may make the decision for you.
I personally prefer Access over just about any other reporting tool I've seen, but then, I'm a developer with a long track record with Access. I haven't used Crystal much, but here are some considerations: 1.
Crystal reports is a reporting tool only. There is absolutely no way that a user with Crystal can change your data. Access is a more flexible tool - if you don't want your users changing the data, you'll have to take steps to prevent this. An Access report is totally static; once it's been produced, you can't do anything to it, except go back into design view, change it there, and then re-run it.
If you give your users a full version of Crystal, they can do a lot of summing, moving around, etc.
0コメント