Hi,

I have a prebuilt report here and have to make some changes in it. The datasource and fields - everything is present on the report. Now, I have to add one more field from another table(that is not present in the datasource of the report). I am trying to do it as follows: I am creating a blank formula field on the report. Then in the code I am accessing that field and setting its text property to a data table's column. I get an error saying that 'The Field name is not known'

How should I set the datasource for the formula field progamaticaly?

My code is as follows:

MyFormula.Text = "{MyTable.MyColumn}"

When I run the report, it says - "The field name (MyColumn) is not known".

When i try using the following code:

MyFormula.Text = MyTable.rows(0)(MyColumn)

..the report is displayed with the value of zero - th record for every row in the report.

How should I set the text value of the formula field in the code (I am working with VB.NET)


Thanks in advance
Gauri