trouble with multiple datasets RRS feed

  • Question

  • Hello,

    I've two Tablix-Controls on a Report with diffrent datasets (property 'DatasetName' is set). Now I would fill the Fields in the Tablix-Controls with the values from dataset.

        Textbox1.Value = Fields!Column1.Value

    raises a error '...Report item expressions can only refer to fields within the current dataset scope...'

    I don't need a aggregate-function (like sum(..., dadaset1)), I'm looking for the current value, like

        Textbox1.Value = dataset1.Fields!Column1.Value

    but this doesn't work. How is the correct syntax to fill the Textbox with the value of the current row?




    Tuesday, November 2, 2010 10:16 AM