Need your opinion on querying data for presentation on winforms / web page and for reports
-
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example: Users report to a manager 1. The process by clicking a button is finding who reports to me (manager) 2. So there is a stored procedure written to find the users reporting to the manager Now, there is a report (rdlc on the web server displayed via reportviewer control) which takes the manager as an input to generate report data for the staff members reporting to that manager. The stored procedure for this report uses existing stored procedure (as in step 2 above) to find the staff members reporting to the manager and then generate required data. My question is: 1. Is this the right way of doing this 2. Is there a need to develop a separate SQL view just for this report 3. What would be the best approach on doing this. Please help. Thanks Regards, Nayan
-
Dear all, I require your opinion on what approach is good and/or practical for the following scenario. There is a web application which queries data from SQL server. For example: Users report to a manager 1. The process by clicking a button is finding who reports to me (manager) 2. So there is a stored procedure written to find the users reporting to the manager Now, there is a report (rdlc on the web server displayed via reportviewer control) which takes the manager as an input to generate report data for the staff members reporting to that manager. The stored procedure for this report uses existing stored procedure (as in step 2 above) to find the staff members reporting to the manager and then generate required data. My question is: 1. Is this the right way of doing this 2. Is there a need to develop a separate SQL view just for this report 3. What would be the best approach on doing this. Please help. Thanks Regards, Nayan
I don't see any issues with this approach, the dedicated view may be useful if reconciliation is required or you are going to use an OLAP system but not for you current requirements.
Never underestimate the power of human stupidity RAH
-
I don't see any issues with this approach, the dedicated view may be useful if reconciliation is required or you are going to use an OLAP system but not for you current requirements.
Never underestimate the power of human stupidity RAH
Thank you very much. I just needed a clarification for not under-estimating my decision over my superior. Thank you very much.