i need a crystal report integrated with asp.net
what i need is the following:
-i need a page in which the responsible engineer will authorize any data,this page will gets the data from(region)and (region_operation_data)tables and when he chooses the date from calendar and press 'get data' he will get the outflow of the regions and review them,this data will be shown in tabular format.
-then he press 'authorize' and that will make the data transfered in to a table(region_report_table)and will have a column to indicate that this is 'version 1' of the reports.
-there is another page in which the users will be able todownload the data by choosing the date and report type and this will load the authorized data from (region_report_table) into crystal report .
-in case that any changes happens after the first authorization for the data,then there will be a second authorization from the engineer but this time the data will take 'version 2' indication and stored in the table(region_report_table).
-when the user will choose this time to download data,he will be able to choose from both versions.
-the second verion report should highlights the changed values in different color.
-i attached the database and the report layout but in the database i didn't create the (region_report_table).
-the excel sheet (sheet DMD)is the report layout
windows 2000 prof
MS sql 2000