Hi!
I have an ACCESS data project linked to a SQL database. In that database I have a stored procedure which is used by a Crystal Report. I have created a form using RDC and the Crystal Viewer that calls up the report quite well and prompts for the stored procedure parameters. However, my boss doesn't like how crystal's parameter screens look. So, I'm creating a form that asks the users to enter the parameters independently. Then, when they click on the "Print Now" button, I should be able to pass their parameters to Crystal so they won't be prompted a second time. The problem is, I'm not sure how to do that. If anyone knows of instructions or tips on passing parameters from an access form to a Crystal Reports stored procedure, I'd appreciate knowing where I can find that. Any advice or guidance you can give would be greatly appreciated.
Thanks!
Karen Grube
klgrube@aol.com
I have an ACCESS data project linked to a SQL database. In that database I have a stored procedure which is used by a Crystal Report. I have created a form using RDC and the Crystal Viewer that calls up the report quite well and prompts for the stored procedure parameters. However, my boss doesn't like how crystal's parameter screens look. So, I'm creating a form that asks the users to enter the parameters independently. Then, when they click on the "Print Now" button, I should be able to pass their parameters to Crystal so they won't be prompted a second time. The problem is, I'm not sure how to do that. If anyone knows of instructions or tips on passing parameters from an access form to a Crystal Reports stored procedure, I'd appreciate knowing where I can find that. Any advice or guidance you can give would be greatly appreciated.
Thanks!
Karen Grube
klgrube@aol.com