Incorrect printed pages in SQL Report-Imp. pls. reply asap

Hi
Can someone tell me why my printed pages from the print icon on SQL Report
2005
is different from the page # shown on the browser. Meaning, if I specify
that I want to print page # 10 of a 50 paged report, the printed output is a
different page and not the page #10 which is seen in the browser.
Any clues why this is happening?
--
Thanks,
SDRoyBecause on screen in your browser you are viewing it in pdf. If you want to
see exactly how your page will print you need to use print preview or export
to pdf.
"SDRoy" wrote:
> Hi
> Can someone tell me why my printed pages from the print icon on SQL Report
> 2005
> is different from the page # shown on the browser. Meaning, if I specify
> that I want to print page # 10 of a 50 paged report, the printed output is a
> different page and not the page #10 which is seen in the browser.
> Any clues why this is happening?
> --
> Thanks,
> SDRoy|||I'm sorry...I meant you are viewing it in html on screen in your
browser...forgive my typo please.
"KimB" wrote:
> Because on screen in your browser you are viewing it in pdf. If you want to
> see exactly how your page will print you need to use print preview or export
> to pdf.
> "SDRoy" wrote:
> > Hi
> >
> > Can someone tell me why my printed pages from the print icon on SQL Report
> > 2005
> > is different from the page # shown on the browser. Meaning, if I specify
> > that I want to print page # 10 of a 50 paged report, the printed output is a
> > different page and not the page #10 which is seen in the browser.
> >
> > Any clues why this is happening?
> >
> > --
> > Thanks,
> > SDRoy|||SDRoy,
Different renderers are being used, (html v. rtf) so the pagnation is
different.
thx
-jsh
"SDRoy" wrote:
> Hi
> Can someone tell me why my printed pages from the print icon on SQL Report
> 2005
> is different from the page # shown on the browser. Meaning, if I specify
> that I want to print page # 10 of a 50 paged report, the printed output is a
> different page and not the page #10 which is seen in the browser.
> Any clues why this is happening?
> --
> Thanks,
> SDRoy

IN SQL Server Management Studio - Can connect to database sort of but Icon isn't green anymore

Preface: I'm a newbie at 2005 and sql server in general.

I can connect to a sql server (2005 express) but I can only make views and not run queries. When I open up a new query and create it with query designer and click add table I see no tables, views or anything in the box. When I create a new view in the database I do see tables and views though.

The little circle part of the icon on the server in the left hand pane is clear now when before it was green. I still can connect to the database ok but I can't use the query analyzer for queries anymore. I need to do that because I do have some slow running queries.

~Capt howdy

Select the database first (ie:AdventureWorks), 'new query' and then click design view.

|||I'm such a n00b with sql server it hurts sometimes. Thanks! I am used to access but it is definitely time to step up.

~Capt. Howdy

IN SQL Server Management Studio - Can connect to database sort of but Icon isn't green anym

Preface: I'm a newbie at 2005 and sql server in general.

I can connect to a sql server (2005 express) but I can only make views and not run queries. When I open up a new query and create it with query designer and click add table I see no tables, views or anything in the box. When I create a new view in the database I do see tables and views though.

The little circle part of the icon on the server in the left hand pane is clear now when before it was green. I still can connect to the database ok but I can't use the query analyzer for queries anymore. I need to do that because I do have some slow running queries.

~Capt howdy

Select the database first (ie:AdventureWorks), 'new query' and then click design view.

|||I'm such a n00b with sql server it hurts sometimes. Thanks! I am used to access but it is definitely time to step up.

~Capt. Howdy