I am using Q3 2007 SP1, and I am getting a frustrating error when I view a report I've created. Here is my scenario:
- Created a new typed dataset and set it as the datasource in the report designer; also set the datamember to the appropriate table
- Added 2 textbox items to the report header section and set the expressions to fields that I selected in the expression editor dialog
- Added a new webform containing the reportviewer control; in the codebehind (Page_Load) I add code that creates an exact duplicate of the dataset (reading from same schema file that I used to create the typed dataset) and created a few sample datarows
- Viewed the report and I get the following error:
#ERROR# The expression contains object 'BankEmployeeName_A' that is not defined in the current context.
Why doesn't it find the field? I set a breakpoint in the ItemDataBinding event handler and the report's datasource property does in fact contain this field within the targeted datamember (datatable). Am I missing something?
I am only using the typed dataset for design-time--I will be returning the exact same result set from an Oracle stored procedure and I don't want to use typed datasets for this purpose. Theoretically, this scenario should work perfectly, and in fact, is the way in which we were binding all of our Crystal Reports report objects previously.
Any ideas on why this isn't working??