Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
255
Can report be generated with two levels of details
posted

I need to create reports with 2 levels of details.  For example:

(top level):  Name, SSN, Address

    (1st level down): Account type, Account number

        (2nd level down): Deposit/Withdrawl amount, date, payee

Can the infragistics report tool perform this?

Can there be multiple parent/child/grandchild hierarchies in the same report?

---

Also, can the data-source for this report be a hierarchical (in this case, 1 parent level + child levels + grandchild levels) xml file?  How is the reported to the structure of the xml file?

Thanks!

 

 

 

Parents
  • 3070
    posted

    Hi,

    Question 1: Yes, in order to do that you will have to define a data source with all the required data and define two groups. The outer most group will group by SSN (assuming that is the key) and the other by “Account type, Account number”.  You can define those groups at the report level or at the table level or a combination of the two. If it’s a SQL DataSource you will need to join all the required tables in a single SQL statement. If it’s an ObjectDataSource you will need to define the data source over the third level of hierarchy and have a way to navigate to the parent (e.g. if you have Contact/Account/Transactions you need to bind to a list of Transactions and then group by transaction.Account and account.Contact).

    Question 2: Currently the only way to display hierarchies inside the report is using the group by approach previously described. You can include several tables inside the report each one displaying a hierarchy using groups. At the report level you can only associate one data source which is used by the groups defined outside tables.

    But we currently don’t support hierarchical data sources. Add support for them is our lists.

    Question 3: We will support them when we add support for hierarchical data sources.

    Thanks,

    Leo

Reply Children
No Data