Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jasminegirl
Starting Member
7 Posts |
 Posted - 2010-03-05 : 14:13:03
|
| The following two questions pertain to format questions I have about sql server 2008: 1. When I export some of the sql server 2008 tables to either word or PDF, and the table goes to two or more pages, there is a complete empty page break. Basically I will see the table, followed by a blank page, the table is continued to another page, there is another empty page, the table is continued to another page, there is another empty page. Thus can you tell me how to make certain there are not all the empty pages I just listed above? 2. I am thinking of creating 1 table that would look like the following. Each sentence would be a different row in the table. When looking at the data below: a. How would I get lines 1 and 2 to show up only once? b. How would I get lines 3 and 4 to show up on every page? line 1 'The table contains the following sales figures:line 2 ' Company XYX Bike sales'line 3 (column headers look like Product name product quantity total priceline 4 (detail data) bike a 8 $752 bike b 1 $890 bike g 3 $275 thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-06 : 02:22:32
|
| 1. you need to adjust table width so as make it fit to page size2.you need a table with three header rows and single detail row------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
jasminegirl
Starting Member
7 Posts |
Posted - 2010-03-06 : 10:34:25
|
| If I use a table with three header rows, then the header rows will appear on every page of the report where the table is generated, correct? If a table goes to more than 2 or more pages, won't this title appear on every page? If not, how would you keep the rows that are not column headers from appearing on every page of the report where the a table goes over two pages? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-07 : 02:33:48
|
quote:
Originally posted by jasminegirl
If I use a table with three header rows, then the header rows will appear on every page of the report where the table is generated, correct? If a table goes to more than 2 or more pages, won't this title appear on every page? If not, how would you keep the rows that are not column headers from appearing on every page of the report where the a table goes over two pages?
Ok in that case you simply place two textboxes that spans entire length of table and add headers in it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
sql report formatting