Multiple DataSet in same table object RRS feed

  • Question

  • Hi,

    I'm pretty new in ReportViewer.

    I would like to show fields from two differents db tables in the same table object.

    Example : I have an object inside my object datasource. Let's say, an "Employee" object (which is my datasource), containing a "Company" Object, and I want to access a property of the Company object. Automatically the datasetname is set to "Employee". If I remove the 'First' from my Compagny field, i got the following error.

    Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

    I understand that it's normal because my Compagny fields are not the the Employee table.

    Is there a way to work arround that? Like a view or something?


    Tuesday, July 3, 2007 1:30 PM

All replies