Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

MS Access 2003 - Embedding a Crystal Report into Access to be filtered by a combo box

I have a report generated by Crystal Reports, that's for use in third-party software outside of MS Access.  I have no way to generate a list of multiple records (like Access can) using this third party software, and then filter the crystal report by a selection from the list.  So I'm trying to integrate this report into Access using one of the Crystal Reports controls, and I want a combo box (or list box) on the same form as the report control  to have an after update event that will update the crystal report to whatever is selected in the combo box.  


My question is, can someone tell me the steps I need to take to get a Crystal Report control working on a form, and if I can use that control on the afterupdate event of something else on an Access form?  
I should mention that the crystal report pulls data from SQL tables, and I think I will need to have some sort of connection string.  Thanks in advance.
0
jdol2949
Asked:
jdol2949
  • 7
  • 5
3 Solutions
 
mlmccCommented:
What version of Crystal?

You should be able to link the SQL tables in the Access database so it appears they are part of the Access database

mlmcc
0
 
jdol2949Author Commented:
It's Crystal 10.  I have the SQL tables linked in Access, but I'm trying to see if I can use the Crystal Reports control to pull up an existing report so that way I don't have to create a replication in Access that will need to be updated every time we update our report file.  There is a file called invoice.rpt used for third-party software called ServiceWorks, and we want to be able to use that same report in Access.
0
 
mlmccCommented:
Can you open the report in Crystal?

Can you preview it?

mlmcc
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
jdol2949Author Commented:
I cannot.  I'm trying to figure out how to use the control...  how would I go about opening report.rpt in Access which resides on our server with path \\SRV01\Reports\ ?
0
 
mlmccCommented:
Do you have Crystal?

mlmcc
0
 
mlmccCommented:
Or do you just have the reports from ServiceWorks?

mlmcc
0
 
jdol2949Author Commented:
just the reports generated from Crystal.  I don't have Crystal Reports installed on this computer, but I noticed that the Cystal Reports control found in the Access toolbox actually shows up a preview screen of a crystal report.  I'm wondering if there's any way I can use this control to search for \\Srv01\Reports\report.rpt and populate the control box with the .rpt data.  The report looks at sql tables and has no filter on the report, meaning I want Access to set the filter on an afterupdate event of a button or combo box, using vba code if possible.  I'm not at all familiar with how the Crystal Reports control works though.  You'll have to let me know what's the best way to get a crystal report integrated into an Access form... whether it be through the CR control, or by some other means.  I'll award you the points if you can provide me for a solution to use report.rpt from my server folder path, and be able to filter the report in any way, shape, or form.  Thanks!
0
 
jdol2949Author Commented:
and how would i got about distributing these DLLs?
0
 
mlmccCommented:
Through an Installation package built using a tooll like InstallShield

mlmcc
0
 
mlmccCommented:
To distribute them you need a license for Crystal Developer edition.  Do you have that?

mlmcc
0
 
jdol2949Author Commented:
I do not.  Thanks for researching the requirements though.  I appreciate the time and effort involved in gathering the research, and this information was helpful to me in making my decision to choose an alternative path.

-Ryan
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now