Iphone

I have an Access database (XP) from which I created several Crystal Reports (8.5) because Access would not handle all the fields required for the reports.

I tried using the Wizard only to find that it asked for a password. My database has no passwords. Also it looks as if the Wizard is used to create reports. If this is the way to go then hopefully this will be a simple copy/paste procedure once I get into it because I've already created the reports.

What I really would like to do is view the reports from within Access using the Crystal Active-X. I've been over the Accocx97.mdb example on how to set up a CR in Access, however in XP I don't see a place to put the file name of the report. I'm thinking that I have an Active X Control problem.

This is what I did. I registered the Active X by going to Tools/ActiveX Controls/Crystal Report Viewer Control and registering crviewer.dll. Then I opened a form and chose Insert/ActiveX Control/ and chose Crystal Report Viewer Control. From what I've read I expected to bring up the Other tab on the properties and enter a ReportFileName and then be able to change in programatically. That option was not available.

Then I tried registering Crystal Report Viewer Control9 using the same method crviewer9.dll. When I tried to insert the ActiveX Control I got the following message. "The OLE Server isn't registered. To register the OLE server, reinstall it." I have no idea what this means. I'm not even sure I want a CR9 viewer because I'm writing in CR8.5.

I'm hoping someone can help me real quick as I've already wasted too much time re-doing these reports in Crystal
after having found out that Access won't handle them.

Iphone

First download the file from the link above, and register the ocx. (This is for crystl32.ocx)

Then on your form, use the toolbox and go to more controls.

select "Crystal Report Control" and place it on your form. Once placed, you won't be able to see it in normal view. It shows up in design view only.

Then in design view, double click the control and you will get a properties dialog box popup with a ton of stuff to select or deselect.

If you want to assign the report name from code use this:

name of control: CrystalReport1

CrystalReport1.ReportFileName = 'full path and filename here

then to actually run the report use this code

CrystalReport1.Action = 1

If you need help with any of the other properties let me know.

I would suggest under the General tab choose destination "To Window", also you can put the file name there.

Under preview you can select what buttons will appear, including the preview window size, here you can make sure the export button is in the preview window.