I have designed a report in VS2010. I created a dataset (from a stored procedure no parameters) and linked it to the report. Now
I load the report and try to execute (runtime). I create a dataset in C# and populate it, then I use SETDATASOURCE
to apply the dataset and hook it to the Viewer. The selected fields are the same but the results will be different because a parameter is set
to change the data returned. The parameter can be -1 (ALL data), 0 some data, 1 the other data. When I pass the dataset
with the proper data (test parameter is 0), it still seems to report on the original dataset (ALL).
Problem:
1. I would like to pass dynamic datasets and not be tied to the design dataset
2. I design with an open Stored Procedure so as not to elicit the confounded prompts for parameters and I do
NOT want to use the parmaterized mechanism because that mechanism is messy and crazy.
So can this be done? How is it done?
NOTE: The only samples I have are V12 and this is V13, therefore the samples are corrupted because the
the object model is different and they just don't work. So please only direct me to samples if they truly work..
Thanks for any help...