Greetings everyone!
My problem: I decided that I should add a bunch of reports in the app develop for a hospital. I programmatically coded a search from a Mysql database and added a dataset (let me call it "patients_search) as usual. Then I created a DataGridView and used the created Dataset as its data source, this works properly, no problem.
But as of recent, I decided that I should quit using datagrid for my reporting and use the VS 2013 inbuilt MS Report Viewer. I would like to create a report and let it pick its data from the existing dataset ("patients_search") which is created programmatically. So instead of binding my dataset to a datagridview, now I want to bind it to a report.
But it seems the MS Report wants me to use a dataset created with the designer, not programmatically created dataset-and I don't want this.
I have searched many places online, I have not seen anyone do that. I have seen some people say that it is impossible to link the MS Report to a programmatically created dataset.
I have come here to ask for more experts help. Is there a way I can do this inside VB.NET? Please help.
If this is not possible, then what's the other possible way of creating reports? I can't purchase Crystal Reports.
Any help is appreciated.
Thanks,
Frank.