Opening an existing CR Report in ACCESS

[dday01]

Hi All,

I am a novice as far as integrating applications goes. Here is what I need to do: I have an ACCESS data base of info for different agencies. I also have a crosstab crystal report based on another database that contains monthly service data for each agency. I have a form in ACCESS that displays all of the basic information for the agency. What I would like to do is be able to display the crystal report on my ACCESS form and have it display the service data for only the agency I have brought up on my form. The ACCESS database and the crystal report have a field (AGENCY NAME) that is unique and could be used for linking. Can anyone get me started in the right direction.

Thanks,

D

 

[glalsop]

Have a look at this sample Access app provided by Business Objects:

http://support.businessobjects.com/communityCS/FilesAndUpdates/rdc_vba.exe.asp

Should set you on the right path.

-Gary