Solved

Help With Crystal Reports

Posted on 2013-01-17
7
296 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 22

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 22

Accepted Solution

by:
Ido Millet earned 500 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

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 22

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 100

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
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…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now