ADO.NET methods interact with Stored procedures to retrieve the data and load into DataTable object.
When the Download button is selected, loop through DataTable columns and rows and copy data from DataTable to CSV file.
The requirement involves generating various CSV files based on user's selection i.e., generate report for Jan to Feb or Current Month etc.
The spread sheet consists of various statistics i.e., No.of Visits during certain period, Total users, Expired users etc. Similar to the one here
I like to know if there is a solution from SQL Server BI tools, through SSRS. I am aware that using SSRS it is feasible to produce CSV files, Excel sheets etc.
1. I like to know if it supports doing calculations to count Expired/Current users etc statistics ? Should be through custom methods (SQL).
2. Can these custom methods can be called through WCF service? where the UI is Web forms and the reports generation engine
View Complete Post