The task is to change the reports so date parameters can be entered by users generating reports.
The application currently uses ASP files to access crystal reports v7. The report databases are views which have a datediff statement to get a current date.
One option to add parameters to reports and remove datediff from the view. The database is large and the concern is this would slow down the report generation since the view would be returning all the records.
Another option to change views to stored procedures and prompt user for values in ASP file.
A future project is to change the way we access the reports since the username,password can be displayed in view source or if someone prints from IE print icon. We are considering Visual Net or VB. The reason I bring this up is if anyone has experience with this, would it make sense to integrate this project with adding the parameters
Thank you very much for any input .......
The application currently uses ASP files to access crystal reports v7. The report databases are views which have a datediff statement to get a current date.
One option to add parameters to reports and remove datediff from the view. The database is large and the concern is this would slow down the report generation since the view would be returning all the records.
Another option to change views to stored procedures and prompt user for values in ASP file.
A future project is to change the way we access the reports since the username,password can be displayed in view source or if someone prints from IE print icon. We are considering Visual Net or VB. The reason I bring this up is if anyone has experience with this, would it make sense to integrate this project with adding the parameters
Thank you very much for any input .......