crystal report- mailing page with conditions

A report grouped by School & semester 1 & 2
having mailing layout with 2 columns.

How can i display the right side column with Sem 1 and left side to be Sem 2 in a report for each school

sample doc attached
test.docx
mercybthomas74Asked:
Who is Participating?
 
mlmccCommented:
That is a much different issue than I was expecting.

Right click the student group in the left margin
Click CHANGE GROUP
Click the second tab
Click KEEP GROUP TOGETHER

mlmcc
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Section expert for detail section: turn on Format with Multiple Columns.
A new 'Layout' tab appears.  Turn on the option to 'Format Groups with Multiple Columns'.

Cheers,
- Ido
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
For even more flexibility, you can embed 2 linked subreports.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
mlmccCommented:
I think the subreports will work.

Do you always have the same number of labels for each semester for a school?

Is there any relationship between the columns?
For example are the names on the label the same in each row?
Is there some way to group within a school so that each group has 2 records - one for each semester?
If so then using the multiple column approach and acrposs then down option would work.

mlmcc
0
 
mercybthomas74Author Commented:
I have the   'Format Groups with Multiple Columns'.  turned on
When a kid does no have same no.of course (for e.g: Name : cccc) , them Sem 2 is printed in column 1

How can i have them printed all sem 2 in same column, no matter the no.of course for each students is different
------------------------------------------------------------------------------------------------
Sample Rpt
-----------------------
School 002                        
Name : aaaa                  Name : aaaa      
sem 1                  sem 2      
                        
Period      Course            Period      Course
1      Reading            1      Reading
2      Math            2      Math
3      Arts            3      Arts
4      Science            4      Science
5      Social             5      Social
6      PE            6      PE
                        
Name : bbbb                  Name : bbbb      
sem 1                  sem 2      
                        
Period      Course            Period      Course
1      Reading            1      Reading
2      Math            2      Math
3      Arts            3      Arts
4      Science            4      Science
5      Social             5      Social
6      PE            6      PE

                        
Name : cccc                        
sem 1                        
                        
Period      Course                  
1      Reading                  
2      Math                  
3      Arts                  
                        
Name : cccc                  Name :dddd      
sem 2                  sem 1      
                        
Period      Course            Period      Course
1      Reading            1      Reading
2      Math            2      Math
3      Arts            3      Arts
4      Science            4      Science
5      Social             5      Social
6      PE            6      PE
0
 
mlmccCommented:
There are 2 ways to handle that.

1.  Use the main report for Sem1 and a subreport for Sem2

2.  Use formulas to build the output then display in the group footer.

I assume you have a group on the student
In the group header add a formula
WhilePrintingRecords;
Global StringVar strPeriodsSem1;
Global StringVar strPeriodsSem2;
Global StringVar strClassesSem1;
Global StringVar strClassesSem2;

strPeriodsSem1 := "";
strPeriodsSem2:= "";
strClassesSem1:= "";
strClassesSem2:= "";

In the detail section
WhilePrintingRecords;
Global StringVar strPeriodsSem1;
Global StringVar strPeriodsSem2;
Global StringVar strClassesSem1;
Global StringVar strClassesSem2;
If {SemesterField} = 1 then
(
   strPeriodsSem1 := strPeriodsSem1 & {PeriodField} & chr(13);
   strClassesSem1:= strClassesSem1 & {ClassField} & chr(13);
)
Else
(
   strPeriodsSem2 := strPeriodsSem2 & {PeriodField} & chr(13);
   strClassesSem2:= strClassesSem2 & {ClassField} & chr(13);
);
""

IN the group footer put the headers
Add formulas for each list
WhilePrintingRecords;
Global StringVar strPeriodsSem1;
strPeriodsSem1

You need 1 for each list

mlmcc
0
 
mercybthomas74Author Commented:
I forgot to mention, The results is shown in group header, there is no detail section for this report,

The Group headers are ":
Group a : School
Group ab: Student
Group c : Sem
Group d: Is the detail data as shown above & is using crosstab to show the Period, Course......
0
 
mlmccCommented:
Can you upload the report so we can see what you are doing?

mlmcc
0
 
mercybthomas74Author Commented:
0
 
mlmccCommented:

Can you show screen shot of the output showing the issue?

mlmcc
0
 
mercybthomas74Author Commented:
Attached is the screen shots...
Page 1 - 3

Semester 1 should show on the left side and Semester 2 on the right side, regardless the no.of course each kid have

At Page 2  - The last kid Adorno, Brianna Necole,have few course, so it truncated the and on the Page 3 started Semester 2 on the leftside , messing the whole order....

How to set the Crosstab records to set no.of line.....

RptTest.docx
0
 
mercybthomas74Author Commented:
tried it, did not work
0
 
mlmccCommented:
Check the KEEP TOGETHER on the sections
Right click the DETAILS in the left margin
Click SECTION EXPERT
Uncheck KEEP TOGETHER

mlmcc
0
 
mercybthomas74Author Commented:
Got it to work,
what if the student does not have Semester 1 any data , so the  the Semester 2 is showing on the left side instead of right were all Semester 2 is showing , can there be any conditions be applied to show all Semester 2 on right side?
0
 
mlmccCommented:
Not sure.

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.