I am currently working on a reporting component of a project. We have already defined and coded our stored procedures and data generation modules.
So, I have a dataset which has data populated in runtime and I have my reportviewer control. What I need is a report object and binding that object to the dataset in runtime.
In order to form the report object, I need to add a datasource. After all the searches I have done, I figured out how to form the report for a dataset that does not have the data in it yet. I've created an XSD schema of the dataset and used it as the datasource to define which dataset column will be visible in which report column.
My question is, how can I bind my dataset, that will have data in it in runtime, without using ANY sql within the controls, or without using any object that has sql statements or call to stored procedures within (for ex. TableAdapter object.)?