I am developing an ASP.Net website. I created a report that uses a dataset I created using the dataset designer, and resides in the App Code folder and is viewed via a report viewer (i.e. not crystal report)
It uses one parameter, passed in a query string on the URL. I thought it was working just fine until I realised that the data is static. i.e. The data displayed is static as of the time I originally created the dataset. I can add new records to my database, but I canot display them in a report.
So how can I fix this?
My skills just about stretch to creating a dataset on page load. Can I then bind it to the report I designed? If so, how?
Or is there an easier option, i.e. forcing the dataset to refresh each time the report is called?
As always, any suggestions or help gratefully recieved.