I have a few Crystal Reports that I have created that reference an Access DB. It works without a problem.
My question is, I would like to be able to use parameters on a web page that will be supplied to a Crystal Report to query the Access DB. The parameters on the web page would be something like this:
Start Date: __/__/__ (text box - mm/dd/yy format)
End Date: __/__/__ (text box - mm/dd/yy format)
Dept: ___________ (multi-selection list box)
and a Button called "Generate" that supplies Crystal with the SQL string and brings the report up in GenericPageViewer.asp.
I really don't care how I get this done, so I'm open to the best options. I also realize that I may need some expertise in another forum area, but figured I'd come here to get your ideas on how to best accomplish this. I'm open to any suggestions. Thank you.
My question is, I would like to be able to use parameters on a web page that will be supplied to a Crystal Report to query the Access DB. The parameters on the web page would be something like this:
Start Date: __/__/__ (text box - mm/dd/yy format)
End Date: __/__/__ (text box - mm/dd/yy format)
Dept: ___________ (multi-selection list box)
and a Button called "Generate" that supplies Crystal with the SQL string and brings the report up in GenericPageViewer.asp.
I really don't care how I get this done, so I'm open to the best options. I also realize that I may need some expertise in another forum area, but figured I'd come here to get your ideas on how to best accomplish this. I'm open to any suggestions. Thank you.