Skip to Content
0
Former Member
Nov 19, 2012 at 05:39 PM

Dynamic DataSets, No Parameter Prompt, No Design DataSet

28 Views

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...