print header on the first page only

I have a table grouped by id. The detail for a particular group can span
serveral pages.
I have 3 header lines for each group . I want to print all 3 header rows on
the first page of the group and only one of the header rows on the next pages
of the group.
Does any one know how to do this?
--
MarieI found a solution here.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=227646
--
Marie
"Marie" wrote:
> I have a table grouped by id. The detail for a particular group can span
> serveral pages.
> I have 3 header lines for each group . I want to print all 3 header rows on
> the first page of the group and only one of the header rows on the next pages
> of the group.
> Does any one know how to do this?
> --
> Marie

print header / footer on all pages?

Is there a way to print the header and footer on all pages? Also I have a
footer and the textboxes in it wont print, lines will but no text the
expressions are like this (below) any idea? they show up on screen as on the
footer but when printed are blank
textbox1
="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
textbox2
="Report ran on "+Globals!ExecutionTimenope, the only thing on the page right now since its a brand new report is
the header and footer and the header has a single image in it and the footer
has a line above the two text boxes of which they are 50% of the width each
and left and right aligned, no overlapping...
"William" <William@.discussions.microsoft.com> wrote in message
news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
>I dropped your expressions into text boxes on a report I am working on and
> they both displayed correctly. Are you possible overlaying your footer
> with
> another text box?
> "Smokey Grindle" wrote:
>> Is there a way to print the header and footer on all pages? Also I have a
>> footer and the textboxes in it wont print, lines will but no text the
>> expressions are like this (below) any idea? they show up on screen as on
>> the
>> footer but when printed are blank
>> textbox1
>> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
>> textbox2
>> ="Report ran on "+Globals!ExecutionTime
>>|||ah got it, margin sizes where off
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:uhjRh0oNHHA.324@.TK2MSFTNGP06.phx.gbl...
> nope, the only thing on the page right now since its a brand new report is
> the header and footer and the header has a single image in it and the
> footer has a line above the two text boxes of which they are 50% of the
> width each and left and right aligned, no overlapping...
> "William" <William@.discussions.microsoft.com> wrote in message
> news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
>>I dropped your expressions into text boxes on a report I am working on and
>> they both displayed correctly. Are you possible overlaying your footer
>> with
>> another text box?
>> "Smokey Grindle" wrote:
>> Is there a way to print the header and footer on all pages? Also I have
>> a
>> footer and the textboxes in it wont print, lines will but no text the
>> expressions are like this (below) any idea? they show up on screen as on
>> the
>> footer but when printed are blank
>> textbox1
>> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
>> textbox2
>> ="Report ran on "+Globals!ExecutionTime
>>
>|||On Jan 12, 3:30 pm, "Smokey Grindle" <nos...@.dontspamme.com> wrote:
> ah got it, margin sizes where off
> "Smokey Grindle" <nos...@.dontspamme.com> wrote in message
> news:uhjRh0oNHHA.324@.TK2MSFTNGP06.phx.gbl...
> > nope, the only thing on the page right now since its a brand new report is
> > the header and footer and the header has a single image in it and the
> > footer has a line above the two text boxes of which they are 50% of the
> > width each and left and right aligned, no overlapping...
> > "William" <Will...@.discussions.microsoft.com> wrote in message
> >news:0665879C-B9F3-4F58-86FC-75E74BF1A84B@.microsoft.com...
> >>I dropped your expressions into text boxes on a report I am working on and
> >> they both displayed correctly. Are you possible overlaying your footer
> >> with
> >> another text box?
> >> "Smokey Grindle" wrote:
> >> Is there a way to print the header and footer on all pages? Also I have
> >> a
> >> footer and the textboxes in it wont print, lines will but no text the
> >> expressions are like this (below) any idea? they show up on screen as on
> >> the
> >> footer but when printed are blank
> >> textbox1
> >> ="Page "+str(Globals!PageNumber)+" of "+str(Globals!TotalPages)
> >> textbox2
> >> ="Report ran on "+Globals!ExecutionTime
I am having the same problem - where the footer appears when viewing
the report, but not when printing. Could you please elaborate on how
you fixed this with margin sizes?

Print data from an ASP.NET ReportViewer that contains multiple pages from FireFox?

Hi,

I have this application in which I am using a number of reports containing one or more pages. When using IE as explorer, the printing button is be?ng displayed properly. When clicking that button, everything works as it should. But when using Firefox as browser, the print button doesn't show up. So I thought about going to the menu of the browser and choose File > Print. The result looks just like a printscreen and when the report contains multiple pages, I am not able to print them in a decent way.

On the internet I read the main reason for this is that Firefox does not work with ActiveX-Objects. In this way it would not be possible to print out the pages!

Can anyone help me out?

Thx a lot!

Recloose!

Anyone?

Print blank pages after change server

Hi,
I have a Seagate Info 7 server on NT4, recently I migrate the it to a new server running on NT4. I install a new SI7 in the new server and then copy the old SI7 database and reports to the new server. After that I change the APS name to a new name using the utility in SI7.

All work well, except the printing. A blank page come out after each print for all the old report that I have created. But new report is OK.

Can some please help me! Thanks a lotOpen the Old Reports and Do verify Database

Preview <> PrintPreview

Hi,
i created a report that works fine, in preview it shows 3 pages, but in
print preview it shows 4, i allready checked the sizes, Report.PageWidth is
21cm, left and right Margins are both with 1cm and body width is 18.75cm ...
so 21-1-1 = 19 that is great then 18.75... what i miss ?
rgards
JFRYou may want to check your object sizes in the layout view. I have found that
if the report layout is larger than the set pagesize that it will move the
extra space onto a blank page. In this case, make sure that the width of the
report in the layout view is 19 cm or less, preferably a little less. You
might also want to check the length and make sure that its not running over
there.
"JFR" wrote:
> Hi,
> i created a report that works fine, in preview it shows 3 pages, but in
> print preview it shows 4, i allready checked the sizes, Report.PageWidth is
> 21cm, left and right Margins are both with 1cm and body width is 18.75cm ...
> so 21-1-1 = 19 that is great then 18.75... what i miss ?
> rgards
> JFR