Solved

SSRS - Help with Mail Merge

Posted on 2009-05-14
2
1,000 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 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

820 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