1. We have requirement where users can build there own SSRS Reports and integrate it with the existing system dynamically.
2. We have an Existing Application (Called
APP1), our approach is user will build the report as per there requirement and from APP1 we have report configuration screen when user will select the report file to import to our system.
3. While doing importing, we have special requirement like
3.1 Retrieve the all fields from the Report DataSource and display to the user
3.2 User configures that what values they want to filter when the report is shown from the application. ex: employee information is
displayed in the report, DataSet query is "select empid,empname,..... * from employee"
3.3 from APP1 when user gives the report we have to dynamically load the report and get the fields from the dataset, so user can configure like this, when the report
is shown report must ask for parameter value for empid .
View Complete Post