I want to generate a rdlc report by manually populating values to dataset because I send the date as an input to the query.
I use the following code to do that
//my list get populated with the relevant records according to its date and I'm using the tableadapter of my dataset to do that
List<DailySalesEntity> list = DailySalesHandler.GetSalesByDate(dateTimePicker1.Value);
reportViewer1.LocalReport.DataSources.Clear();
Microsoft.Reporting.WinForms.ReportDataSource report = new Microsoft.Reporting.WinForms.ReportDataSource("DataSet_Dailysales", list);
reportViewer1.LocalReport.DataSources.Add(report);
reportViewer1.LocalReport.Refresh();
.
I’m using a tablix to show my data using the dataset.I have set the correct report to the report viewer.
I don’t get any exceptions. But the report keeps loading and does not show the report. What is it I’m doing wrong.
How can I populate the dataset by passing a parameter to the query, and use the resulting dataset in the report?
Best Answer
I just had this problem and solved it. The loading sign kept showing and never dissapearing. In my case the problem was that I wasn't handling the
IsPostBack
value. TheLocalReport.Refresh()
generates a postback and if not handled, it will keep posting and posting.This was my problem. By walling Refrеsh the page kept doing PostBacks
SOLUTION:
So, check that you are handling the PostBack and not getting an infinite loop.