Databases
StackOverflow2013
Postsdbo
POCan I do two levels of linking in Crystal Reports?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan I do two levels of linking in Crystal Reports?
    primarykey
    data
    text
    <p>Let's say I have three lists: Departments, Divisions, and Groups. A Department is made up of Divisions, which in turn is made up of Groups.</p> <p>The Divisions have the Department ID as a foreign key. The Groups have the Division ID as a foreign key.</p> <p>I'd like to produce a report that looks like this:</p> <pre>Department 1 Division 1A Group 1A-i Group 1A-ii Group 1A-iii Division 1B Group 1B-i Group 1B-ii Group 1B-iii Division 1C Group 1C-i Group 1C-ii Group 1C-iii Department 2 Division 2A Group 2A-i Group 2A-ii Group 2A-iii Division 2B Group 2B-i Group 2B-ii Group 2B-iii Division 2C Group 2C-i Group 2C-ii Group 2C-iii Department 3 Division 3A Group 3A-i Group 3A-ii Group 3A-iii Division 3B Group 3B-i Group 3B-ii Group 3B-iii Division 3C Group 3C-i Group 3C-ii Group 3C-iii </pre> <p><a href="https://stackoverflow.com/questions/2166906/crystal-reports-is-there-a-way-to-get-effectively-a-subreport-within-a-subrepor">I know how to use a subreport</a> in Crystal Reports (VB.NET and Visual Studio 2005) to get me to the Division level:</p> <pre>Department 1 Division 1A Division 1B Division 1C Department 2 Division 2A Division 2B Division 2C Department 3 Division 3A Division 3B Division 3C </pre> <p>But since <a href="https://stackoverflow.com/questions/2166906/crystal-reports-is-there-a-way-to-get-effectively-a-subreport-within-a-subrepor">I can't include a subreport within a subreport</a>, I'll need to go about it some other way. Is there a way to do this?</p> <p>Thanks in advance!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJohn
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCan I do two levels of linking in Crystal Reports?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload