ReportViewer bug

[Chris Botha]

I have a report that uses 2 datasets (2 tables on the report)
VS2005 correctly generates 2 ObjectDataSource objs when selecting the report
in the smart tag of the ReportViewer.

Depending on values the user enter, example start/end date, the report must
display only that data, so I have 2 classes that selects the data and return
the relevant data sets (set up in the TypeName and SelectMethod properties
of the ObjectDataSource objs). The framework calls these classes when the
report is being generated.
These user entered values are stored in session variables and the 2 classes
get the values from the session variables.
This works fine for the first class being called. When the second class is
being called, trying to get the session object throws an error.

I've been using this technique a number of times for reports with 1 dataset.
My workaround for the time being is static variables rather than session
variables to store the user entered values, which will of course blow up if
2 users run the report simultaneously.

 

[jhcorey]

You might want to post this at
microsoft.public.sqlserver.reportingsvcs, although admittedly the
response level is not very high over there.

Otherwise, can you provide any more info about the error?

Jim