Let me begin by saying I'm not sure if this is the correct forum to post or not? If others would be more suitable, please advise.
Current Problem:
I have a rather large Oracle database that is currently connected via ODBC to Crystal Reports(CR). I have needed to place several select statements in the Record Selection clause because generating all records constantly produces a timeout. Right now the administrators have to open CR and manually run reports every morning for previous days activity.
Preferred Solution:
I would like a web based solution that runs the report when they click on a link or button. The ODBC connection constantly prompts for a password upon every "refresh", so I assume this would need to be passed as well.
Should I be looking at an add-on to CR that is a type of auto-scheduler. Or can this be done using either asp.net or vb.net to deliver a web based application that runs these reports with minimal user intervention? Preferably the reports would output in either .pdf, html, or xml formats.
Thanks for any help you can provide.
Regards,
Tread42
Current Problem:
I have a rather large Oracle database that is currently connected via ODBC to Crystal Reports(CR). I have needed to place several select statements in the Record Selection clause because generating all records constantly produces a timeout. Right now the administrators have to open CR and manually run reports every morning for previous days activity.
Preferred Solution:
I would like a web based solution that runs the report when they click on a link or button. The ODBC connection constantly prompts for a password upon every "refresh", so I assume this would need to be passed as well.
Should I be looking at an add-on to CR that is a type of auto-scheduler. Or can this be done using either asp.net or vb.net to deliver a web based application that runs these reports with minimal user intervention? Preferably the reports would output in either .pdf, html, or xml formats.
Thanks for any help you can provide.
Regards,
Tread42
