Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS - Help with Mail Merge

Posted on 2009-05-14
2
Medium Priority
?
1,016 Views
Last Modified: 2012-05-07
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
Comment
Question by:Rogero
2 Comments
 
LVL 8

Accepted Solution

by:
tpi007 earned 2000 total points
ID: 24383004
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
 

Author Comment

by:Rogero
ID: 24387319
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

916 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