CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2008
    Posts
    3

    Question Crystal Report Design, HELP!

    All,

    i have troubles creating a working report for the following design:

    I have "Boxes" and "Items".

    An Item as an "ID", "Name" and "ParentID". Where the parent ID is a foreignkey to the Box table.

    A Box as an "ID" and a "Name", but also a "ParentID". Because a box can exist out of other boxes...

    So a Box can contain more then one boxes and also more then one items... An item can only be in one box.

    So a small treeview example:

    - BOX1
    ---- item1
    ---- item2
    ---- BOX2
    ------- item3
    ------- item4
    - BOX3
    ---- item5
    - BOX4
    - BOX5
    ...

    I created all links in MySql, and i created an ODBC connection. But how do i create a report which will list me a nested structure of all items and boxes?

    It probably has something todo with groups, or subreports ... but i can't figure things out!

    If you have an idea, please help me!

    Thanks!

  2. #2
    Join Date
    Dec 2005
    Location
    Waterloo ON
    Posts
    545

    Re: Crystal Report Design, HELP!

    So you don't know how many levels in your report? Like BOX1 contains BOX2, BOX2 contains BOX3, BOX3 contains BOX4, etc.

    If you know exact number of levels, you can use group and subreport to show the whole thing. Subreport would be the better way. If there is no data in subreport, suppress it.
    The difficulty is that you have no idea how difficult it is.

    .Net 3.5/VS 2008

  3. #3
    Join Date
    Jul 2008
    Posts
    3

    Re: Crystal Report Design, HELP!

    Ok, thanks ... i think i'll need to put a limit in the nested structure

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured