Subreports and Shared Variables

[JanVolleyM]

I'm using CR X. I have found out that CR doesn't allow subreports within subreports. This is a big problem for me. I've also heard that there is a workaround for this by using Shared Variables to get a subreport value to the main report, and then Edit > Subreport Links to get it to another subreport. But, I can't figure out how to do this for my particular situation and if it will even work for me.

This is what I'm trying to do:

I have a main report with several unrelated sections. Each unrelated section has a subreport to pull and display the associated data for that section.

I have a lesson plan section that needs to display a list of lesson plan titles (from LessonPlan table), some additional data associated with the lesson plan (still from LessonPlan table), a list of key points for the lesson plan (one to many, child table), and a list of instruction methods/hours for the lesson plan (one to many, child table). So, the lesson plan parent has two sets of children to list. Normally, if this were in its' own report, I would have a subreport for each child list. But, since this is within a larger main report, I can't do this since you can't have subreports within subreports.

Is there any way for me to do this using either shared variables or some other method?

Thanks,
Jan

 

[lbass]

Is the lesson plan "parent" a group in the main report? I.e., what main report section IS the lesson plan section?

-LB

 

[JanVolleyM]

No, it's not a group in the main rpt. The lesson plan section is a subreport in the main rpt because I need to display a list of all lesson plans for a specified course.

 

[lbass]

Please identify the groups in the main report by field you are grouping on. How are the subreports linked to the main report? On what fields? In what sections are they currently placed in the main report?

-LB

 

[JanVolleyM]

I don't have any groups in the main rpt. My main rpt consists of several sections with each section containing a subreport that pulls data from the appropriate tables. The lesson plan section contains a subreport called LessonPlans that needs to list each lesson plan title, the list of key point child data, and the list of instruction method/hours child data.

Each section of the main rpt consists of data that is not really related to data in the other sections.