Hi,
I am creating a project where I have a form in which parameters are entered. I would like to click a command button to run a query based on the parameters which open the data in a Crystal Report. I was going to use the Crystal ActiveX Report Viewer Control, but I could not find a place to identify the path. The second issue is how to get the parameters to work being selected on the Access side and executed through the query creating a crystal report. The confusing part to me is that there are at least 50 different parameters that could be used/queries that result. I would like to write one report to be used and the report contents determined by parameters/query results. The end result is an income statement if that helps at all. I appreciate any help anyone can provide.
Thanks!!
I am creating a project where I have a form in which parameters are entered. I would like to click a command button to run a query based on the parameters which open the data in a Crystal Report. I was going to use the Crystal ActiveX Report Viewer Control, but I could not find a place to identify the path. The second issue is how to get the parameters to work being selected on the Access side and executed through the query creating a crystal report. The confusing part to me is that there are at least 50 different parameters that could be used/queries that result. I would like to write one report to be used and the report contents determined by parameters/query results. The end result is an income statement if that helps at all. I appreciate any help anyone can provide.
Thanks!!