lovettjay
asked on
SSRS to Mail Merge all details(students) on one page
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?
This is what the report look like:
This is what I am able to get from the mail merge:
This is what I am looking for :
Thanks for your help,
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
This is what the report look like:
This is what I am able to get from the mail merge:
This is what I am looking for :
Thanks for your help,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you can share the table details , I can write the complete query for you !
ASKER
Hello Pawan,
select CONVERT(varchar,ME.members _exams_exa mdate, 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
select CONVERT(varchar,ME.members
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
Closing this.