Groups | Blog | Home
all groups > sql server reporting services > february 2007 >

sql server reporting services : CASS Certification and Postal Discounts


Julian I. Spring
2/28/2007 6:56:55 AM
My organization is moving to a SQL based CRM solution that is customized for
our industry. As a part of this move we are converting all our documents
over to SQL Reports. We have also been contemplating using a CASS certified
product to help us get some substantial postal discounts for our mailings.

Is anyone aware of a product that can take the data being fed into a
reporting server and queue the reports, sort and certify, and then print to
allow postal discounts?

I realize that I am simplifing the process some but I am trying to find out
if there are any vendors servicing this market yet.

--
Wayne Snyder
3/2/2007 3:28:47 PM
I don't know of a product that will do what you want...

However, you might think of this in two parts..
Certifying the addresses in the database,
sorting/printing/printing the CASS Cert documents

The first will be much easier than the second...
In order to get the lowest rate you must print the documents in the same
group together... Docs will print in the order that they complete, so you'd
probably have to buy/write something to group reports into a single printing
batch..

Another thing you might try is to print each group of reports one at a time,
don't start the second group until the first has completed...

In any case - you'll probably have to work very hard if each report is
specific to the address, instead of printing the same report and delivering
it to many people.



--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.


[quoted text, click to view]
AddThis Social Bookmark Button