Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

Help With Crystal Reports

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
whiwex
Asked:
whiwex
  • 3
  • 3
1 Solution
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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
 
whiwexAuthor Commented:
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
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
whiwexAuthor Commented:
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
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Check New Page After and New Page Before properties for your sections.
Also check 'Keep Together' properties.
0
 
whiwexAuthor Commented:
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
 
mlmccCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now