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
Showing posts with label lines. Show all posts
Showing posts with label lines. Show all posts
Friday, March 30, 2012
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?
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?
Subscribe to:
Posts (Atom)