Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Request help on report design Post Reply Post New Topic
Author Message
RavensAngel
Newbie
Newbie


Joined: 02 Jul 2008
Online Status: Offline
Posts: 4
Quote RavensAngel Replybullet Topic: Request help on report design
    Posted: 14 Jul 2008 at 5:05am
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
       ...
 
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? Dead
 
It probably has something todo with groups, or subreports ... but i can't figure things out!
 
If you have an idea, please help me! Confused
 
Thanks!
 
 
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 14 Jul 2008 at 1:05pm
Is there a limit as to how deep this will nest?
 
-Dell
IP IP Logged
RavensAngel
Newbie
Newbie


Joined: 02 Jul 2008
Online Status: Offline
Posts: 4
Quote RavensAngel Replybullet Posted: 15 Jul 2008 at 1:59am
Well,
 
i assume the max is:
 
an item in a box and that box in another box, so:
   - BOX1
       -BOX2
           -item1
 
but in theory this can be endless...
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Jul 2008 at 8:37am
If it can be limited to just one box inside a box, then the report is not a big deal.  If it can be a deeper nesting, but still limited, then you may be able to do this using a command instead of tables.  If it is indeed endless, there's no way to do this just in Crystal.
 
The easiest way to handle the one level nesting is going to be to use a subreport.  The subreport will have the same tables as your main report and you'll link from the main report Box.ID field to the subreport Box.ParentID field.  In the main report, set the selection criteria to select only the records in Box where the ParentID field is null.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.