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

    Question Crystal Report Design, HELP!


    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!


  2. #2
    Join Date
    Dec 2005
    Waterloo ON

    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

    Re: Crystal Report Design, HELP!

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


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