Solved

SSRS - Help with Mail Merge

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

734 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