Thanks alot guys. I am really sorry, if I am not very clear in my postings. I will try to give you the complete picture below. (I don't see anyway to attach the report for your information. If this is not clear, then I will provide the report over the web)
This is basically a report which will have lot of text pages. As I said, I have divided my Details section into around 12 sections. Each section's content is similar to the one following
*****************************
Detail Section 1
The land with the buildings thereon situated in {city}, {County} County, {State} known and being numbered {Address}:
Being on the easterly side of {Address} containing {area} square feet, more or less, and being shown as {lot} which plan is recorded with {RegistryName} in Book {book}, Page {page}, and to which plan reference may be had for a more particular descriptin of said {lot}.
Detail Section 2
{Schedule A}
******************************
The data is retrieved from database using "only one" stored procedure, which returns just "one row". (There will be only one record for one report. So it is not like a typical Detail section, where there will be multiple number of records returned). The data retrieved from this sp, used in all the sections (Basically same data fields are used in most of the sections).
I have such similar text in rest of the sections. (I used different sections, because I need to suppress some sections if user don't want to see them. I provide him the input screen where he selects which sections to show. So, I suppress the sections not selected by the user) Since I am using the same data in rest of the sections, I use only one stored procedure to get the data.
I am not creating any groups. I just divided Details into 12 sections. I don't have a page header, but I have only page footer. I need the page footer for only first 5 sections. For these sections I need to show N of M pageNumber(1 of 5 pages.. etc.) For rest of the pages, I should not show these page numbers. (When the user takes the print out, he is going to present the data in first 5 sections as a Title and get's the client's signatures on that. Looks like it is the format of that document to have that page numbers.) Rest of the sections, I have things like this.
*****************************
Prepared For: {BankName}
{BankAddress}
{BankCityStateZip}
Prepared By: {AgentName}
Requested by: {DocumentControlOffice}
{OfficeAddress}
{OfficeCityStateZip}
Telephone: {OfficePhone}
Report Date: {ReportDate}
Customer Reference: {ReferenceNumber}
This is to cirtify that the borrowers are present at the time of......
.....
...
..
*****************************
These are more like letters. Each section goes in a single page when the user prints out. (So, NewPageBefore is selected for these sections). Since each letter going to be in one page, I don't need the footer in this. My boss don't want to compromise on that. I told him that I will divide this into two reports, with first few 5 sections as one report and rest of the pages as second report, but he don't want that eiter. He wants the customer to see all the pages in one report and print it like wise.
This is my situation guys. I hope I have enough information. If there are doubts, you can send me a mail at cankalu at ataclosings dot com.
Thanks alot for your patience. Thanks again.
Chandra
