Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: One to Many sub-reports Post Reply Post New Topic
Author Message
bigdummy76
Newbie
Newbie


Joined: 17 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote bigdummy76 Replybullet Topic: One to Many sub-reports
     Posted: 12 Jul 2011 at 9:10am
I need to create a report that uses a provider ID as the input parameter. For that provider I need to show all members associated with that provider. For each member I need to show 4 separate reports. medications, problems, interventions and goals. I can create the parameters and sub-reports and I can link the sub-reports to the main. What I can't do is get the sub-reports to display by member so that a provider will have a one page report per member.

The layout would be
Provider: Smith
       Member: 1   
             Medications
                  aspirin
                   tylenol
             Problems
                   Heart disease
                   Obesity
              Interventions
                    weight watchers
              Goals
                     weight loss

        Member: 2 (New Page)
               Medications
                     viagra
                 Problems
                      ED
                 Interventions
                      Counseling
                 Goals
                      Reverse ED       

IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 12 Jul 2011 at 9:14am
did you group by member?
then place your subreports in the details under the group
in the group footer go to section expert
new page after- check that off
sharona
IP IP Logged
bigdummy76
Newbie
Newbie


Joined: 17 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote bigdummy76 Replybullet Posted: 15 Jul 2011 at 4:23am
BINGO! Thanks
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 15 Jul 2011 at 5:02am
no problem.
sharona
IP IP Logged
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