• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1031
  • Last Modified:

SSRS - Help with Mail Merge

Hi there,

I am trying to do a mail merge with SSRS. I must be missing a trick somewhere. The page footer is coming out on each page no problem, but the table of data that pulls the info from our sql 2005 database repeats twice per page.

Any ideas anyone?

Cheers, Roger
0
Rogero
Asked:
Rogero
1 Solution
 
tpi007Commented:
Things to check:
  1. Run the exact same query direct in query analyser to check that data is in fact being duplicated
  2. Is there some group by condition in Report causing data to be repeated
  3. Does data appear duplicated when report run on SSRS website, I have had bizarre results when viewing report in BIDS report viewer (can cache data for previews)
0
 
RogeroAuthor Commented:
Hi,

The stored procedure is fine, the only group is the address, with the detail as the text of letter.

How do you tell SSRS to print to A4, and start new page every group?





0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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