Solved

SSRS - Help with Mail Merge

Posted on 2009-05-14
2
993 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to disable/enable multiple sql jobs in efficient way 11 100
Date Differences SSRS 3 59
Query to Add Late Tolerance 10 60
SQL 2012 R2 Express report problem 2 83
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…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now