How to Freeze the header for Reports

I am creating reports using SQL Server Management Studio 2005. When I
get my final report I am not seeing a frozed header, ie the header
keeps moving as I scroll down. Can somebody let me know on what I
should do to freeze my hearder in each page.On Dec 13, 6:00 pm, Dani <tharani.mahend...@.gmail.com> wrote:
> I am creating reports using SQL Server Management Studio 2005. When I
> get my final report I am not seeing a frozed header, ie the header
> keeps moving as I scroll down. Can somebody let me know on what I
> should do to freeze my hearder in each page.
Somewhere you turned on the Table's "Header should remain visible
while scrolling" option. Right click your table, Properties, General
Tab, and uncheck that option.
-- Scott|||On Dec 13, 4:13 pm, Orne <polysilly...@.yahoo.com> wrote:
> On Dec 13, 6:00 pm, Dani <tharani.mahend...@.gmail.com> wrote:
> > I am creating reports using SQL Server Management Studio 2005. When I
> > get my final report I am not seeing a frozed header, ie the header
> > keeps moving as I scroll down. Can somebody let me know on what I
> > should do to freeze my hearder in each page.
> Somewhere you turned on the Table's "Header should remain visible
> while scrolling" option. Right click your table, Properties, General
> Tab, and uncheck that option.
> -- Scott
No Prne, the option you mentioned is not available.|||Actually the option she mentioned is there. You need to make sure that you
are right clicking on the table and not a column,textbox or row in the
table. When the properties window appears it will say "Table Properties" at
the top. The option you are looking for is the very last check box on the
"General" tab.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: Dani <tharani.mahendran@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: How to Freeze the header for Reports
> Date: Thu, 13 Dec 2007 15:21:25 -0800 (PST)
> On Dec 13, 4:13 pm, Orne <polysilly...@.yahoo.com> wrote:
> > On Dec 13, 6:00 pm, Dani <tharani.mahend...@.gmail.com> wrote:
> >
> > > I am creating reports using SQL Server Management Studio 2005. When I
> > > get my final report I am not seeing a frozed header, ie the header
> > > keeps moving as I scroll down. Can somebody let me know on what I
> > > should do to freeze my hearder in each page.
> >
> > Somewhere you turned on the Table's "Header should remain visible
> > while scrolling" option. Right click your table, Properties, General
> > Tab, and uncheck that option.
> >
> > -- Scott
> No Prne, the option you mentioned is not available.
>|||Is there a different place to do this in RS2000?
"Chris Alton [MSFT]" wrote:
> Actually the option she mentioned is there. You need to make sure that you
> are right clicking on the table and not a column,textbox or row in the
> table. When the properties window appears it will say "Table Properties" at
> the top. The option you are looking for is the very last check box on the
> "General" tab.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > From: Dani <tharani.mahendran@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: Re: How to Freeze the header for Reports
> > Date: Thu, 13 Dec 2007 15:21:25 -0800 (PST)
> >
> > On Dec 13, 4:13 pm, Orne <polysilly...@.yahoo.com> wrote:
> > > On Dec 13, 6:00 pm, Dani <tharani.mahend...@.gmail.com> wrote:
> > >
> > > > I am creating reports using SQL Server Management Studio 2005. When I
> > > > get my final report I am not seeing a frozed header, ie the header
> > > > keeps moving as I scroll down. Can somebody let me know on what I
> > > > should do to freeze my hearder in each page.
> > >
> > > Somewhere you turned on the Table's "Header should remain visible
> > > while scrolling" option. Right click your table, Properties, General
> > > Tab, and uncheck that option.
> > >
> > > -- Scott
> >
> > No Prne, the option you mentioned is not available.
> >
>|||On Mar 4, 7:57=A0am, Scott <Sc...@.discussions.microsoft.com> wrote:
> Is there a different place to do this in RS2000?
>
> "Chris Alton [MSFT]" wrote:
> > Actually the option she mentioned is there. You need to make sure that y=ou
> > are right clicking on the table and not a column,textbox or row in the
> > table. When the properties window appears it will say "Table Properties"= at
> > the top. The option you are looking for is the very last check box on th=e
> > "General" tab.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no righ=ts.
> > --
> > > From: Dani <tharani.mahend...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: Re: How to Freeze the header for Reports
> > > Date: Thu, 13 Dec 2007 15:21:25 -0800 (PST)
> > > On Dec 13, 4:13 pm, Orne <polysilly...@.yahoo.com> wrote:
> > > > On Dec 13, 6:00 pm, Dani <tharani.mahend...@.gmail.com> wrote:
> > > > > I am creating reports using SQL Server Management Studio 2005. Whe=n I
> > > > > get my final report I am not seeing a frozed header, ie the header=
> > > > > keeps moving as I scroll down. Can somebody let me know on what I
> > > > > should do to freeze my hearder in each page.
> > > > Somewhere you turned on the Table's "Header should remain visible
> > > > while scrolling" option. =A0Right click your table, Properties, Gene=ral
> > > > Tab, and uncheck that option.
> > > > -- Scott
> > > No Prne, the option you mentioned is not available.- Hide quoted text =-
> - Show quoted text -
The feature is not available in RS 2000.|||Instead create the header in the page footer, remove the header for
the table. go to page header properties.see the properties of page
header if there is any option for remain visible
I didnt try this.this is just my idea. Thank youe
Raj Deep.A

how to fix report layout problems

When you use Report designer in the BI development studio, on the Preview tab, you can have a straight preview or a print layout preview. I suppose what you see in the print layout preview is what you get when you print the report or export the report to the other format.

However, often you see everything looks perfect in a straight preview but does look right in the print layout preview. For example, you might get the following problems in the print layout preview, even if everything looks perfect in a straight preview.

· Every even page is a blank page

· Items that should be together on the same page are separated into different pages. For example, on the first page, I had a TextBox1 followed by Image1 then followed by TextBox2. Both textboxes have constant (static) values, and Image1 holds a jpg image. Strangely enough, when I do print layout preview, I saw both textboxes and blank space in-between on the first page, and then saw the image on the second page. No matter how I adjust and what I adjust (position, size, bring to front, send to back, ... etc), I just could not get them into the same page, and I have no clue why.

Can anyone provide some suggestions, advices, experience, knowledge, or pointers?

Where and what elements should I look into to fix the layout problems stated above?

Thanks in advance.

Chris in Toronto

Hi There,

It's probably a problem with page width. Your report is too wide to fit on a single page, and so the right hand edge will be carved off into a new page, hene every other page is blank or your data is split across pages.

The report should be something like 21cm by 29.7cm (sorry, I can't remember the inch equivalents). And the body should be about 18cm wide. (at least these measurements certainly fit on a sheet of A4 in one of my reports).

Cheers - Andrew.
|||

I have already considered the page width.

No matter how I adjust the page width, it does not fix the two problems that I described.

Thanks anyway.

|||

When you looked at the page width vs. body width, did you consider the size of the margins? This blog article might help:

http://blogs.msdn.com/chrisbal/archive/2006/08/10/694892.aspx

This situation is the only one I'm aware of that will reliably cause every other page to be blank in physical page layout renderers.

-Chris