LocalReport: Object-in-Object as DataSource not working?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Pieter
    #1

    LocalReport: Object-in-Object as DataSource not working?

    Hi,

    I have a Report (VB.NET 2005), and I'm using Objects as DataSource.

    I have the object objCompany, which contains a public property MyAdress
    (instance of objAdress). objAdress has a propert Street.

    When I add objCompany as a DataSource, I want to be able to show the
    Street-property of MyAdress. So I do a drag-and-drop of that property from
    the Data Sources - Window to the Report. Everything seems fine: I get a
    textbox on my report with Value "=First(Fields! Street.Value,
    "MyApplication_ objCompany")".

    But when I run the report, it doesn't show any value in it...

    Does anybody knows why this happens? I somehow think because of the fact
    that Street isn't directly on MyApplication_o bjCompany, but when I change it
    into MyApplication_o bjCompany_MyAdr ess is complains about the fact that it
    doesn't exist...

    How should I do this?

    Thanks a lot in advance,

    Pieter


    Tags: None
    • Pieter
      #2
      Re: LocalReport: Object-in-Object as DataSource not working?

      I found the solution here for nested objects and reporting services
      localreport in the reportviewer:

      Object data sources
      http://www.gotreportviewer.com/objectdatasources/index.html


      Apparently I have to do something like "=First(Fields! MyAdress.Value. Street,
      "MyApplication_ objCompany")".

      It gave me these 2 errors:
      The Value expression for the textbox 'Adresse' refers to the field
      'ReportAdresse' .
      Report item expressions can only refer to fields within the current data set
      scope or, if inside an aggregate, the specified data set scope.

      The Value expression for the textbox 'textbox19' has a scope parameter that
      is not valid for an aggregate function.
      The scope parameter must be set to a string constant that is equal to either
      the name of a containing group, the name of a containing data region, or the
      name of a data set.

      But sddenly it started to work...
      strange... :-/



      "Pieter" <pietercoucke@h otmail.com> wrote in message
      news:u64%23GAki GHA.1204@TK2MSF TNGP02.phx.gbl. ..[color=blue]
      > Hi,
      >
      > I have a Report (VB.NET 2005), and I'm using Objects as DataSource.
      >
      > I have the object objCompany, which contains a public property MyAdress
      > (instance of objAdress). objAdress has a propert Street.
      >
      > When I add objCompany as a DataSource, I want to be able to show the
      > Street-property of MyAdress. So I do a drag-and-drop of that property from
      > the Data Sources - Window to the Report. Everything seems fine: I get a
      > textbox on my report with Value "=First(Fields! Street.Value,
      > "MyApplication_ objCompany")".
      >
      > But when I run the report, it doesn't show any value in it...
      >
      > Does anybody knows why this happens? I somehow think because of the fact
      > that Street isn't directly on MyApplication_o bjCompany, but when I change
      > it into MyApplication_o bjCompany_MyAdr ess is complains about the fact that
      > it doesn't exist...
      >
      > How should I do this?
      >
      > Thanks a lot in advance,
      >
      > Pieter
      >[/color]


        Comment

        Previous template Next
        Working...