December 7, 2011 at 3:07 pm
Hi All,
I've created a letter that gets prepopulated with data from a created query. The Letter breaks for every new 'Location' in the result set so things seem to be good there.
The problem seems to be in the page breaks which are also affecting the Page Borders (where I've created an expression that changes the color of the border based on the criteria).
The letter is created using a 'Table' with header, details, and footer (only 1 table). All of the text is pretty standard in the form except for what I'm calling for in the 'Details' section. ('details' could result in multiple rows for any given location).
Can someone please help in providing guidance for appropriately applying the pagebreaks? I only care that the pagebreaks adhere to the page setting (i.e. 8.5 x 11) and the full page border that I've set is applied to 'every' page in the results.
Any help?
Desparately needing help on this one ;o(
Many thanks,
Doc
December 13, 2011 at 6:02 pm
There's not much to go on here for anyone trying to help.
Is your print formatting instructions table in SQL Server 2005?
Please provide:
1. Table definition of formatting table as CREATE TABLE statement
2. Data as INSERT statements
3. What is driving the SELECT query and page printing (Reporting Services, VB, PHP, ASP, ...)
4. Where does the data for the letter come from? Another table? If so please provide CREATE and INSERTs and the SELECT
5 What the letter looks like
6. The business logic of what is supposed to happen
Thanks,
Peter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply