Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Help With Crystal Reports

Posted on 2013-01-17
7
Medium Priority
?
312 Views
Last Modified: 2013-01-19
I can't seem to figure out how to create this report. I am using vb.net and MySQL
1) I query the database and retreive Student Name, Homeroom and Sponsor information
2) I want to create a report that shows each student, followed by all their Sponsors, followed by a letter to all their sponsors. So it looks like this
Student #1
      Student #1's Sponsor #1 Name and address
      Student #1's Sponsor #2 Name and address
      Student #1's Sponsor #3 Name and address

New Page

Dear  Student #1's Sponsor #1 Name

Letter body

new Page

Dear  Student #1's Sponsor #2 Name

Letter body

new Page

Dear  Student #1's Sponsor #3 Name

Letter body

new Page


Then Repeat the above for student #2, 3,4, etc

I can create a report for the Student and their sponsor Information and I can create a report for the Letter and they work fine.

My problem is I can't create a report that will do both and print out in the correct format.

Can anyone help me here.

Thanks
Whiwex
0
Comment
Question by:whiwex
  • 3
  • 3
7 Comments
 
LVL 23

Expert Comment

by:Ido Millet
ID: 38789189
You can use a subreport for one of these purposes (probably to show all the sponsors and their addresses in the student header section.

And the main report can take care of the other purpose.
0
 

Author Comment

by:whiwex
ID: 38789313
I tried to this

Group Header Section
Subreport with student info

Details Section
Subreport with student letter

problem is it prints All the students and their sponsors

then
it prints all the letters

I need it to print the Student and all the sponsors then the letters for each sponsor then
Print the next student and all the sponsors then the letters for the sponsors
0
 
LVL 23

Accepted Solution

by:
Ido Millet earned 2000 total points
ID: 38789326
You need to use a LINKED subreport (the link is the student ID) and use the link to restrict what it shows to info for just that student.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:whiwex
ID: 38789637
Ok I linked the subreport and it's just about working. Here's what i did

Group Header Section 1
The Student Report is in Here

Group Header Section 2
The Letters to the Sponsors are in Here

This works fine but there is always a blank page after the Student Report is Printed. So after the first Student theres a blank page then the sponsors Letters are printed. Then the next next Student is printed then a blank page then the sponsor letters.

I can't seem to get the blank page to not print.
0
 
LVL 23

Expert Comment

by:Ido Millet
ID: 38789674
Check New Page After and New Page Before properties for your sections.
Also check 'Keep Together' properties.
0
 

Author Comment

by:whiwex
ID: 38794337
Ok I got it to work buy removing the New Page After in the report header of the Sponsors Letters.

But because the Sponsor Letters are printed on two sides I need to check how many pages the Student the Student Report is. If the number of pages in each student is odd I need to add a empty page so that the letter doesn't print on the back Side of the Sponsor Letters. I have been tryiung to use PageNumber Mod 2 > 0 but it doesn't work.

I am actually working in the Student report which looks like this

Section1 (ReportHeader) Suppressed

Section2(Page Header)
Columns Headings

GroupHeadingSection1( Group Header #1 Sponsors.Student Name -A)

Section 3 (Details)
       Student Name Sponsor NAme

GroupFooterSection1( Group Footer #1 Sponsors.Student Name -A)

Section4(Group Footer)

Section5(Page Footer)


Section 4

Group Footer Section 1( Group Header #1 Sponsors.Student Name -A)

How do I add a new page after each student?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38795531
I don't follow where you need the page break or page added?

I understand that when the report ends on a full odd page you need to print a blank page.

Which section is the end of the letter where you need to test the paging.

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question