I am new to reportviewer in visual studio 2008.
I want to create a dataset using code and then display that in a report.
Basically I need to pass a variable to the reportviewer sql statement so it only display's data based on that variable.
Something like "select WO_TYPE, WO_TYPE_ID from WO_TABLE where WO_TYPE = 'variable.value' and then the report will only display the report where that value = the variable.
I have tried to create a report and bind it to the dataset using the qui then modify the binding to use my code generated dataset. But I haven't been successful.
If any body can tell me how to create a report based on a variable it would be great.