SQL Server Performance

sql server 2008 formatting

Discussion in 'SQL Server 2008 Reporting Services' started by jassie, Mar 5, 2010.

  1. jassie New Member

    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 price
    line 4 (detail data)
    bike a 8 $752
    bike b 1 $890
    bike g 3 $275
    thanks!
  2. satya Moderator

    Just checking whether you had any update or solution for this problem?
  3. jassie New Member

    No i do knot have a solution. What third party tool(s) would you purchase?
    thanks!

Share This Page