I'm trying to figure out why my reportviewer isn't displaying a report like it should after the user clicks on the button "RunReportButton" on Reports.aspx. I have a sql statement that has 2 parameters: @PersonID and @Category. this sql statement searches all records in PersonExercise table that have PersonID = @PersonID And @Category = Category. I execute a dataset based on this sql statement and then pass that into my reportDataSource in the code behind of my reports.aspx.
I then created Report1.rdlc and linked that up to my dataset dsCardio. I dragged ExerciseDate, Distance, Speed from my dataset onto a matrix on Report1.rdlc. When the user clicks on RunReportButton on Reports.aspx then I get the following error: "A data source instance has not been supplied for the data source 'DataSet2'". I debugged my code and I saw that thisDataSet.Tables[0].Rows.Count = 3, which it should. I also have processingmode = local for reportviewer. Any help? Thanks so much!
According to the tutorials there should be a smart tag. This does not happen, and I cannot see any properties i can link to the report. I've tried linking the reportviewer to the rdlc by putting it into the localreport ReportEmbeddedResource property but nothing shows when you run the code.
df19127ead