Solved

SSRS to Mail Merge all details(students) on one page

Posted on 2016-09-13
6
96 Views
Last Modified: 2016-10-05
Looking for some help on a mail merge process.  I would like to group all students into one page however when I run the mail merge all the students have their own page instead of being grouped by school.  

I have the report grouped by school then by group by child on exam description then group by child on the exam date.  


When I go to mail merge in word it will list out the students as individuals.  Where do I add the group by school so all students who fit that exam description & exam date  are under the school.  Where is this option at?  Is this a word mail merge,  SSRS report builder, or done in the sql query itself?


select CONVERT(varchar,ME.members_exams_examdate, 101) as exam_date,
		mem.members_firstname, mem.members_lastname, 
		me.members_exams_id, me.members_exams_score,  me.members_exams_examdate,
		ex.exams_description, 
		sc.schools_name, sc.schools_city, sc.schools_state	
from members_exams as me
join exams as ex
on me.exams_id = ex.exams_id
join schools as sc
on me.schools_id = sc.schools_id
join members as mem
on me.members_id = mem.members_id

Open in new window



This is what the report look like:  
Report.JPG
This is what I am able to get from the mail merge:
Single.JPG
This is what I am looking for :
group.JPG

Thanks for your help,
0
Comment
Question by:lovettjay
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 28

Accepted Solution

by:
Pawan Kumar earned 500 total points (awarded by participants)
ID: 41797367
I think you should do all the operations in the SQL itself. that should help,
0
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41797369
If you can share the table details , I can write the complete query for you !
0
 

Author Comment

by:lovettjay
ID: 41797944
Hello Pawan,

select CONVERT(varchar,ME.members_exams_examdate, 101) as exam_date,
            mem.members_firstname, mem.members_lastname,
            me.members_exams_id, me.members_exams_score,  
            ex.exams_description,
            sc.schools_name, sc.schools_city, sc.schools_state      
from members_exams as me
left join exams as ex
on me.exams_id = ex.exams_id
join schools as sc
on me.schools_id = sc.schools_id
join members as mem
on me.members_id = mem.members_id

Thanks,

Jay
0
 

Author Comment

by:lovettjay
ID: 41801635
Here is the SSRS table:

SSRS table
The Row Groups:
Row-Groups.JPG
0
 
LVL 28

Expert Comment

by:Pawan Kumar
ID: 41829523
Closing this.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Outlook Free & Paid Tools
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how the fundamental information of how to create a table.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

726 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