There is a bug with RepeatOnNewPage in RS 2000 that makes my reports look
really ugly and unprofessional.
I have a TableGroup with a Header and Footer.
Group is set to PageBreakAtEnd.
Header is set to RepeatOnEveryPage.
Footer has nothing special.
I'm rendering as PDF and have installed all service packs and hotfixes.
Everything works fine except when the detail section completely fills the
last page of the group, pushing the Footer off to its own page. In this
case, the header does not repeat.
For example: if 2 rows of details can fit on a page, the report will come
out looking like:
Header1
details
details
-- page break --
Header1
details
Footer1
-- page break --
Header2
details
details
-- page break --
Header2
details
details
-- page break --
Footer2 -- :(
-- page break --
Header3
details
Footer3
One possible workaround would be to move the Footer into the details section
and use Visibility to only show it when on the the last record of the group,
but this seems pretty sloppy.
Anyone have a better solution? MSFT care to respond?Another workaround is to split the group in two -- one that contains just the
Header with RepeatOnEveryPage and one that contains just the Footer with
PageBreakAtEnd and a GroupExpression of "true".
"davedave" wrote:
> There is a bug with RepeatOnNewPage in RS 2000 that makes my reports look
> really ugly and unprofessional.
> I have a TableGroup with a Header and Footer.
> Group is set to PageBreakAtEnd.
> Header is set to RepeatOnEveryPage.
> Footer has nothing special.
> I'm rendering as PDF and have installed all service packs and hotfixes.
> Everything works fine except when the detail section completely fills the
> last page of the group, pushing the Footer off to its own page. In this
> case, the header does not repeat.
> For example: if 2 rows of details can fit on a page, the report will come
> out looking like:
> Header1
> details
> details
> -- page break --
> Header1
> details
> Footer1
> -- page break --
> Header2
> details
> details
> -- page break --
> Header2
> details
> details
> -- page break --
> Footer2 -- :(
> -- page break --
> Header3
> details
> Footer3
>
> One possible workaround would be to move the Footer into the details section
> and use Visibility to only show it when on the the last record of the group,
> but this seems pretty sloppy.
> Anyone have a better solution? MSFT care to respond?
Showing posts with label header. Show all posts
Showing posts with label header. Show all posts
Tuesday, March 20, 2012
RepeatOnNewPage
I have this property set to true for several table header rows in a table
that I want repeated on each page. It doesn't seem to be working. it
displays on the first page and that's it... Any ideas...?
TIA,
DanWhich property have you set to true..'
there is a 'RepeatOnNewPage' property which will set for the whole page
header. you don't really set them one by one. you can click this on the most
left of your header row. one thing to indicate that you are clicking the
right thing is that, it will select the whole row, and show the
RepeatOnNewPage property.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have this property set to true for several table header rows in a table
> that I want repeated on each page. It doesn't seem to be working. it
> displays on the first page and that's it... Any ideas...?
> TIA,
> Dan
>|||The property name is RepeatOnNewPage, I have it set to true and it's not
repeating, displays only on the first page...
Dan
"Daniel" <danielk@.adstream.com.au> wrote in message
news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> Which property have you set to true..'
> there is a 'RepeatOnNewPage' property which will set for the whole page
> header. you don't really set them one by one. you can click this on the
most
> left of your header row. one thing to indicate that you are clicking the
> right thing is that, it will select the whole row, and show the
> RepeatOnNewPage property.
>
> "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
wrote
> in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have this property set to true for several table header rows in a
table
> > that I want repeated on each page. It doesn't seem to be working. it
> > displays on the first page and that's it... Any ideas...?
> >
> > TIA,
> >
> > Dan
> >
> >
>|||Does that table only have items on the first page? If so that is your
problem. What it really should say is repeat on every page which has
items in this table.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote in message news:<evwuUEvfEHA.592@.TK2MSFTNGP11.phx.gbl>...
> The property name is RepeatOnNewPage, I have it set to true and it's not
> repeating, displays only on the first page...
> Dan
>
> "Daniel" <danielk@.adstream.com.au> wrote in message
> news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> > Which property have you set to true..'
> > there is a 'RepeatOnNewPage' property which will set for the whole page
> > header. you don't really set them one by one. you can click this on the
> most
> > left of your header row. one thing to indicate that you are clicking the
> > right thing is that, it will select the whole row, and show the
> > RepeatOnNewPage property.
> >
> >
> >
> > "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
> wrote
> > in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have this property set to true for several table header rows in a
> table
> > > that I want repeated on each page. It doesn't seem to be working. it
> > > displays on the first page and that's it... Any ideas...?
> > >
> > > TIA,
> > >
> > > Dan
> > >
> > >
> >
> >
that I want repeated on each page. It doesn't seem to be working. it
displays on the first page and that's it... Any ideas...?
TIA,
DanWhich property have you set to true..'
there is a 'RepeatOnNewPage' property which will set for the whole page
header. you don't really set them one by one. you can click this on the most
left of your header row. one thing to indicate that you are clicking the
right thing is that, it will select the whole row, and show the
RepeatOnNewPage property.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> I have this property set to true for several table header rows in a table
> that I want repeated on each page. It doesn't seem to be working. it
> displays on the first page and that's it... Any ideas...?
> TIA,
> Dan
>|||The property name is RepeatOnNewPage, I have it set to true and it's not
repeating, displays only on the first page...
Dan
"Daniel" <danielk@.adstream.com.au> wrote in message
news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> Which property have you set to true..'
> there is a 'RepeatOnNewPage' property which will set for the whole page
> header. you don't really set them one by one. you can click this on the
most
> left of your header row. one thing to indicate that you are clicking the
> right thing is that, it will select the whole row, and show the
> RepeatOnNewPage property.
>
> "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
wrote
> in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > I have this property set to true for several table header rows in a
table
> > that I want repeated on each page. It doesn't seem to be working. it
> > displays on the first page and that's it... Any ideas...?
> >
> > TIA,
> >
> > Dan
> >
> >
>|||Does that table only have items on the first page? If so that is your
problem. What it really should say is repeat on every page which has
items in this table.
"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote in message news:<evwuUEvfEHA.592@.TK2MSFTNGP11.phx.gbl>...
> The property name is RepeatOnNewPage, I have it set to true and it's not
> repeating, displays only on the first page...
> Dan
>
> "Daniel" <danielk@.adstream.com.au> wrote in message
> news:OJ8Pg7ofEHA.2896@.TK2MSFTNGP11.phx.gbl...
> > Which property have you set to true..'
> > there is a 'RepeatOnNewPage' property which will set for the whole page
> > header. you don't really set them one by one. you can click this on the
> most
> > left of your header row. one thing to indicate that you are clicking the
> > right thing is that, it will select the whole row, and show the
> > RepeatOnNewPage property.
> >
> >
> >
> > "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
> wrote
> > in message news:O8Xo6gjfEHA.632@.TK2MSFTNGP12.phx.gbl...
> > > I have this property set to true for several table header rows in a
> table
> > > that I want repeated on each page. It doesn't seem to be working. it
> > > displays on the first page and that's it... Any ideas...?
> > >
> > > TIA,
> > >
> > > Dan
> > >
> > >
> >
> >
Repeating table header on "every" page
Hi guys,
I have a question and want to ask you a favor in terms of question. How do I let a table header repeat on every page. I know the "repeat on every page" property and I set that to true, but the problem is that, when the table is not displayed on a certain page, the header doesn't get displayed, especially if the sub-report in the page is large. In other words table is not displaying header on every page when itself is not on every page or something like that? I want that table header to repeat on every single page without glitching.
Any help and pointers?
Thanks for the help,
Enkh.
I have created many reports with subreports. Have you considered making one generic header in the header of the page? It will print on every page, even the subreports. Then you can add a simple text box if you want some unique text for a subreport. Just a thought.Repeating subreport header on each page
Hi All
I'm new to Crystal XI so have a basic question for you guys. I have a report with 3 subreports and sometimes some of the subreports run onto more than one page. I would like to be able to repeat the subreport header on each page when this happens. Any ideas?
Much appreciated
OzHello I have got the same problem but, I am using the version 8.5.0.217
I have a report with 3 subreports each one giving some totally different information from one to the other and only the Header of the main report has common information. I need to print a subreport header in each page this subreports needs
Example
TITLE
A.- details main rep
B.- subreport_1
b.0 Title Subreport_1
b.1 detail Subreport_1
C.- subreport_2
c.0 title subreport_2
c.1 detail Subreport_2
D.- subreport_3
d.0 title Subreport_3
d.1 detail Subreport_3
The page header involves TITLE + A (details main rep)
The report detail involves the different subreports (B+C+D).
I need this b.0 (Title Subreport_1) line at the top of each page (under the main report Page header) the Subreport 1 is displaying.
Do you have any idea about how to solve this? Thank you very much
I'm new to Crystal XI so have a basic question for you guys. I have a report with 3 subreports and sometimes some of the subreports run onto more than one page. I would like to be able to repeat the subreport header on each page when this happens. Any ideas?
Much appreciated
OzHello I have got the same problem but, I am using the version 8.5.0.217
I have a report with 3 subreports each one giving some totally different information from one to the other and only the Header of the main report has common information. I need to print a subreport header in each page this subreports needs
Example
TITLE
A.- details main rep
B.- subreport_1
b.0 Title Subreport_1
b.1 detail Subreport_1
C.- subreport_2
c.0 title subreport_2
c.1 detail Subreport_2
D.- subreport_3
d.0 title Subreport_3
d.1 detail Subreport_3
The page header involves TITLE + A (details main rep)
The report detail involves the different subreports (B+C+D).
I need this b.0 (Title Subreport_1) line at the top of each page (under the main report Page header) the Subreport 1 is displaying.
Do you have any idea about how to solve this? Thank you very much
Repeating report item in page header
Hi,
In a SSRS 2005 I am having a problem:
My report consists of one table report en multiple subreports.
The report and subreports have to be paged by product. So page 1 contains
the data of product 1 for the report + each subreport.
I've achieved this by putting the report and subreports within a list item,
which is grouped by product.
To put the product of the current page in the header I put product on the
dataset of the report and put it in a textbox on the report. Next I put the
product in the header by refrencing the textbox with
=reportitems!product.value.
My problem with this solution is that when 1 product generates more then one
page, I only see the product in the header of the first page. The header of
the next page is empty. I would like to see the product repeated on every
page until the page shows the next product.
Does anyone have a solution or work-around for this?Hi Pieter,
not sure whether the following will help (or that you've tried this
already). If you select the table, right click and select 'properties' and in
the tab 'general' you'll see at the bottom the following option: 'repeat
header rows on each page'... you can even select that the header needs to
remain visible when scrolling. You'll have to tick both options if you want
the header to remain visible while scrolling on all pages.
hope it helps & best regards,
mischa
"Pieter M" wrote:
> Hi,
> In a SSRS 2005 I am having a problem:
> My report consists of one table report en multiple subreports.
> The report and subreports have to be paged by product. So page 1 contains
> the data of product 1 for the report + each subreport.
> I've achieved this by putting the report and subreports within a list item,
> which is grouped by product.
> To put the product of the current page in the header I put product on the
> dataset of the report and put it in a textbox on the report. Next I put the
> product in the header by refrencing the textbox with
> =reportitems!product.value.
> My problem with this solution is that when 1 product generates more then one
> page, I only see the product in the header of the first page. The header of
> the next page is empty. I would like to see the product repeated on every
> page until the page shows the next product.
> Does anyone have a solution or work-around for this?
In a SSRS 2005 I am having a problem:
My report consists of one table report en multiple subreports.
The report and subreports have to be paged by product. So page 1 contains
the data of product 1 for the report + each subreport.
I've achieved this by putting the report and subreports within a list item,
which is grouped by product.
To put the product of the current page in the header I put product on the
dataset of the report and put it in a textbox on the report. Next I put the
product in the header by refrencing the textbox with
=reportitems!product.value.
My problem with this solution is that when 1 product generates more then one
page, I only see the product in the header of the first page. The header of
the next page is empty. I would like to see the product repeated on every
page until the page shows the next product.
Does anyone have a solution or work-around for this?Hi Pieter,
not sure whether the following will help (or that you've tried this
already). If you select the table, right click and select 'properties' and in
the tab 'general' you'll see at the bottom the following option: 'repeat
header rows on each page'... you can even select that the header needs to
remain visible when scrolling. You'll have to tick both options if you want
the header to remain visible while scrolling on all pages.
hope it helps & best regards,
mischa
"Pieter M" wrote:
> Hi,
> In a SSRS 2005 I am having a problem:
> My report consists of one table report en multiple subreports.
> The report and subreports have to be paged by product. So page 1 contains
> the data of product 1 for the report + each subreport.
> I've achieved this by putting the report and subreports within a list item,
> which is grouped by product.
> To put the product of the current page in the header I put product on the
> dataset of the report and put it in a textbox on the report. Next I put the
> product in the header by refrencing the textbox with
> =reportitems!product.value.
> My problem with this solution is that when 1 product generates more then one
> page, I only see the product in the header of the first page. The header of
> the next page is empty. I would like to see the product repeated on every
> page until the page shows the next product.
> Does anyone have a solution or work-around for this?
Monday, March 12, 2012
Repeating Headers and Footers in all pages
I used ReportItems!textbox4.Value for displaying a data field in the header and footer.
But it is not getting repeated in the subsequent pages...
It is getting displayed only in the first page...
Kindly provide me with a solution to get it repeated in all the pages asap!!!........
Regards,
Aravind RJ
Hi,
can you check where you have placed the field you are refering to using the report items.Place that field in the table header or footer or else in the body of the report.If you are placing it in the table header set the property "repeat on new page" for the table header. For the body of the report this property is auotmatically set. you can place it either in the body or the table header or footer.
Also set the visibility of the field being referred accordingly.
hope this works,
somiya
|||Hi,
i am sorry if i wasnt clear earlier...
by body of the report,i meant put the textbox in the detailed section of the report.
Regards,
Somiya
|||Hi somiya,
yes. i placed the fields which i wanted to display using ReportItems! in a table's detail section only.... i also made it repeat on each page... but it dint work and in vain......
in the mean time i found out another way for this.... add those fields which you want to be present in the header / footer to the "Report Parameters", make it hidden and relate it to the database fields which you want to display.... this way, the items get repeated in all the pages....
Thanks,
Aravind RJ
Repeating Group headers on reports with subreports
I have a report that contains a table. The group header in the table is set
to repeat on a new page. However, as soon as I place a subreport in the table
of the main report and that subreport causes a page break...the group header
on the top-level report doesn't repeat. Is there a workaround for this
shortcoming?
Regards,
Dean NeroNero,
Did you ever find an answer for this? I am having the same issue...and
its killin' me!
Michael
"Dean Nero" wrote:
> I have a report that contains a table. The group header in the table is set
> to repeat on a new page. However, as soon as I place a subreport in the table
> of the main report and that subreport causes a page break...the group header
> on the top-level report doesn't repeat. Is there a workaround for this
> shortcoming?
> Regards,
> Dean Nero
to repeat on a new page. However, as soon as I place a subreport in the table
of the main report and that subreport causes a page break...the group header
on the top-level report doesn't repeat. Is there a workaround for this
shortcoming?
Regards,
Dean NeroNero,
Did you ever find an answer for this? I am having the same issue...and
its killin' me!
Michael
"Dean Nero" wrote:
> I have a report that contains a table. The group header in the table is set
> to repeat on a new page. However, as soon as I place a subreport in the table
> of the main report and that subreport causes a page break...the group header
> on the top-level report doesn't repeat. Is there a workaround for this
> shortcoming?
> Regards,
> Dean Nero
Repeating Group Footer in a Subreport
I have a subreport that can be pages long. On each page, I need the group footer repeated. I can get the header to repeat, but not the footer.
Any help will be greatly appreciated!I think you can't.. as it appears at the end of the group...
could you use the page footer ?
Luc|||Thanks for letting me know that I can't repeat the group footer - now I'll have to try and take a different approach!
I suppose I could try sticking the subreports in the detail, so that I could have a page footer... I'll try it and see how it goes.
Any help will be greatly appreciated!I think you can't.. as it appears at the end of the group...
could you use the page footer ?
Luc|||Thanks for letting me know that I can't repeat the group footer - now I'll have to try and take a different approach!
I suppose I could try sticking the subreports in the detail, so that I could have a page footer... I'll try it and see how it goes.
Repeating data on every page's header
My report has 9 subreports. When main report has 3 records then this report
goes into loop and run these 9 subreports 3 times. But I want the heading
in all the pages and should change the data as record changes.. This report
can be 30 - 40 pages long.
I am giving you an example on my report.
Suppose I want to show the detail of 3 staffs.
A, B and C
In heading, I want to show the name, age and gender of staff which will
change on next record.
In detail, In 1st subreport shows the brothers of the staff and 2nd
subreport shows the sisters of that staff etc.
I want to show the heading in all the page.
ThanksYou would have created a group in the table.. you have to check "Repeat
Group Header" checkbox.
Include Name,age, gender in Group Header in the table.
Edit Group -> General Tab -> Check Repeat Group Header.
hth
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
> report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
> report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>|||Can anyone help me.
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>
goes into loop and run these 9 subreports 3 times. But I want the heading
in all the pages and should change the data as record changes.. This report
can be 30 - 40 pages long.
I am giving you an example on my report.
Suppose I want to show the detail of 3 staffs.
A, B and C
In heading, I want to show the name, age and gender of staff which will
change on next record.
In detail, In 1st subreport shows the brothers of the staff and 2nd
subreport shows the sisters of that staff etc.
I want to show the heading in all the page.
ThanksYou would have created a group in the table.. you have to check "Repeat
Group Header" checkbox.
Include Name,age, gender in Group Header in the table.
Edit Group -> General Tab -> Check Repeat Group Header.
hth
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
> report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
> report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>|||Can anyone help me.
"Savita Gupta" <savita.r.gupta@.au.pwc.com> wrote in message
news:e6XRIZfoEHA.324@.TK2MSFTNGP11.phx.gbl...
> My report has 9 subreports. When main report has 3 records then this
report
> goes into loop and run these 9 subreports 3 times. But I want the heading
> in all the pages and should change the data as record changes.. This
report
> can be 30 - 40 pages long.
> I am giving you an example on my report.
> Suppose I want to show the detail of 3 staffs.
> A, B and C
> In heading, I want to show the name, age and gender of staff which will
> change on next record.
> In detail, In 1st subreport shows the brothers of the staff and 2nd
> subreport shows the sisters of that staff etc.
> I want to show the heading in all the page.
> Thanks
>
>
Repeating Data On Each Page
Hi
Pulled all my hair out now, can someone please offer some help before I go totally mad...
I have no page header, this is all in the body. I have a List with account number and job number in it at the top, called list1. In list1 I have list2, with the job details, basically a list of people who attended the job. The fields in list2 are textboxes, they're not in a table.
EG:
Acc No: 12345
Job No: 54321
Name
Fred Bloggs
Joe Bloggs
Etc
When my list2 of names goes over 1 page, I want to repeat the account number and job number on each subsequent page. In my real report I actually have 10 fields I want to repeat.
I then want to be able to export this report to a PDF.
I can't put the header in the page header 
Does anyone have a workaround for this please?
Cheers
HiI don't want to ask the obvious but why can't you use a table? I initially used listboxes for most of my reports but have since found that I can use tables for almost anything once I start merging cells and things like that.
|||
Hello.
I can't use a table because I have all different spacing between the columns and rows. It's not a list of data as in my example, I've just made it simpler in that so it's easier to understand the problem.
For info, in the meantime, I've used an answer provided at the top of this page http://forums.microsoft.com/msdn/showpost.aspx?postid=638813&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1 which I really didn't want to do because it's so damn messy. But it does mean I can have information in the page header and it appears on more than just the first page. Silly me for thinking I can use a Repeat property and it will actually work.
It's so funny reading posts, MSDN and websites about this problem when MS try to justify why this is so difficult to achieve and what the problems are behind it, as if it's something so out of the ordinary people will just accept it the reasoning behind it. I'd love to have been in that meeting where someone said we're releasing RS without the ability to put data in the page header/footer, surely they were sacked on the spot....weren't they?
repeating a header with fields from the dataset
Hi,
I'm designing a report and have the requirement that the report title needs to be repeated on each page. However, the report title is dynamic, retrieved from the database, so i cannot place it in the page header (what an annoyance). The solution i first thought of was placing the title in a table, repeating the table header on each page, however the problem i'm encountering is that when i have a subreport in that table, that subreport is in one row
--> if the subreport spans across multiple pages, the header will only be shown on the first page the row where the subreport is actually in...
any thoughts anyone on a possible solution?
1. Place a hidden textbox in the report body with a value of =First(Fields!<TitleField>.Value).
2. Place another textbox in the page header referencing the first textbox with a value of =ReportItems!<Textbox1Name>.Value.
|||hi
thanks for the reply but that actually doesn't quite fully solve my problem; apparently it will only display the value of the textbox on the page where that textbox WOULD be rendered; my report consists of several subreports, i placed the hidden textbox "after" all the subreports, and the title would only appear on the last page.
Putting the textbox at the first place in the report yielded similar results; it would only display on the first page...
|||i'm testing the report by exporting to pdf, by the way|||Yes, the report item will come back as null if not rendered on the page. If possible, make the hidden textbox repeatable on every page. For example, if the report has a table put the hidden textbox on a detail table row. You will need to change the scope of the hidden textbox expression to reference the dataset, e.g. =First(Fields!<TitleField>.Value, "<DatasetName").
An ugly hack, I know.
repeating a header with fields from the dataset
Hi,
I'm designing a report and have the requirement that the report title needs to be repeated on each page. However, the report title is dynamic, retrieved from the database, so i cannot place it in the page header (what an annoyance). The solution i first thought of was placing the title in a table, repeating the table header on each page, however the problem i'm encountering is that when i have a subreport in that table, that subreport is in one row
--> if the subreport spans across multiple pages, the header will only be shown on the first page the row where the subreport is actually in...
any thoughts anyone on a possible solution?
1. Place a hidden textbox in the report body with a value of =First(Fields!<TitleField>.Value).
2. Place another textbox in the page header referencing the first textbox with a value of =ReportItems!<Textbox1Name>.Value.
|||hi
thanks for the reply but that actually doesn't quite fully solve my problem; apparently it will only display the value of the textbox on the page where that textbox WOULD be rendered; my report consists of several subreports, i placed the hidden textbox "after" all the subreports, and the title would only appear on the last page.
Putting the textbox at the first place in the report yielded similar results; it would only display on the first page...
|||i'm testing the report by exporting to pdf, by the way|||Yes, the report item will come back as null if not rendered on the page. If possible, make the hidden textbox repeatable on every page. For example, if the report has a table put the hidden textbox on a detail table row. You will need to change the scope of the hidden textbox expression to reference the dataset, e.g. =First(Fields!<TitleField>.Value, "<DatasetName").
An ugly hack, I know.
Friday, March 9, 2012
Repeat on New Page
If I have my header row set to "repeat on new page", is there a way to add
the text "continued" to the header if the data has spilled over to the next
page? I want to distinguish between the first time a group of data appears
and when it is continuing on the next page.
ie. Page 1: January 1, 2004
Page 2: January 1, 2004 continued
January 2, 2004
Page 3: January 2, 2004 continued
Thanks,
MelissaThere's no way to do this given the current architecture of the system.
Content of the report body is calculated first, then pagination is applied
after the fact. So there's no way to have the content of the report body
depend on pagination.
The closest you can get is putting the "continued" part in the page header:
1. Put a hidden column in your table with an expression something like
this:
=iif(Fields!Date.Value=Previous(Fields!Date.Value),Nothing,"X")
2. Put a texbox in the page header with an expression something like this:
=First(ReportItems!DateTextbox.Value) &
iif(First(ReportItems.MarkerTextbox.Value)="X"," continued","")
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Melissa" <a@.a.com> wrote in message
news:eBi9yKZeEHA.3928@.TK2MSFTNGP11.phx.gbl...
> If I have my header row set to "repeat on new page", is there a way to add
> the text "continued" to the header if the data has spilled over to the
next
> page? I want to distinguish between the first time a group of data
appears
> and when it is continuing on the next page.
> ie. Page 1: January 1, 2004
> Page 2: January 1, 2004 continued
> January 2, 2004
> Page 3: January 2, 2004 continued
> Thanks,
> Melissa
>
the text "continued" to the header if the data has spilled over to the next
page? I want to distinguish between the first time a group of data appears
and when it is continuing on the next page.
ie. Page 1: January 1, 2004
Page 2: January 1, 2004 continued
January 2, 2004
Page 3: January 2, 2004 continued
Thanks,
MelissaThere's no way to do this given the current architecture of the system.
Content of the report body is calculated first, then pagination is applied
after the fact. So there's no way to have the content of the report body
depend on pagination.
The closest you can get is putting the "continued" part in the page header:
1. Put a hidden column in your table with an expression something like
this:
=iif(Fields!Date.Value=Previous(Fields!Date.Value),Nothing,"X")
2. Put a texbox in the page header with an expression something like this:
=First(ReportItems!DateTextbox.Value) &
iif(First(ReportItems.MarkerTextbox.Value)="X"," continued","")
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Melissa" <a@.a.com> wrote in message
news:eBi9yKZeEHA.3928@.TK2MSFTNGP11.phx.gbl...
> If I have my header row set to "repeat on new page", is there a way to add
> the text "continued" to the header if the data has spilled over to the
next
> page? I want to distinguish between the first time a group of data
appears
> and when it is continuing on the next page.
> ie. Page 1: January 1, 2004
> Page 2: January 1, 2004 continued
> January 2, 2004
> Page 3: January 2, 2004 continued
> Thanks,
> Melissa
>
Repeat on Every Page - For Headers
Using SSRS 2005:
I created a text box in my report header, which references a text box in my
report body: =ReportItems!textbox88.Value
In my report body, hidden textbox88 contains my data:
=Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
This all works great, except for the fact that textbox88 only exists on the
first page, so the header only has a value on the first page.
Here's the question: How do I make textbox88 Repeat on Every Page, which
let's me see a value in the header on Every Page?
Thanks,
--
RandyYou could copy that box into your page header instead of your report
headrer.
"randy1200" <randy1200@.newsgroups.nospam> wrote in message
news:6BAB5E73-F556-4778-8B89-766C99075F90@.microsoft.com...
> Using SSRS 2005:
> I created a text box in my report header, which references a text box in
> my
> report body: =ReportItems!textbox88.Value
> In my report body, hidden textbox88 contains my data:
> =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> This all works great, except for the fact that textbox88 only exists on
> the
> first page, so the header only has a value on the first page.
> Here's the question: How do I make textbox88 Repeat on Every Page, which
> let's me see a value in the header on Every Page?
> Thanks,
> --
> Randy|||I'm working with SSRS 2005 using Visual Studio 2005. I don't see what the
difference is between a page header and report header. I created the header
by viewing the report in the Layout tab, right-clicking off to the side of
the page, and selecting "Page Header."
There are many posts in the archives here that describe why you can't put
fields directly into headers. Fields must be put into something in the body
and then the header can reference that something to allow the data in appear
in the header.
I still haven't been able to spot anything that allows a field in the body
to repeat on every page, so that the data in the field appears in the header
on every page.
--
Randy
"Ben Watts" wrote:
> You could copy that box into your page header instead of your report
> headrer.
> "randy1200" <randy1200@.newsgroups.nospam> wrote in message
> news:6BAB5E73-F556-4778-8B89-766C99075F90@.microsoft.com...
> > Using SSRS 2005:
> >
> > I created a text box in my report header, which references a text box in
> > my
> > report body: =ReportItems!textbox88.Value
> >
> > In my report body, hidden textbox88 contains my data:
> > =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> >
> > This all works great, except for the fact that textbox88 only exists on
> > the
> > first page, so the header only has a value on the first page.
> >
> > Here's the question: How do I make textbox88 Repeat on Every Page, which
> > let's me see a value in the header on Every Page?
> >
> > Thanks,
> > --
> > Randy
>
>|||I see that textbox88 takes its value from a report parameter rather than a
dataset, so there is no need for the page header text box to take its value
from textbox88. It can be taken directly from the parameter!The expression
for your page header textbox can be:
=Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
HTH,
magendo_man
"randy1200" wrote:
> Using SSRS 2005:
> I created a text box in my report header, which references a text box in my
> report body: =ReportItems!textbox88.Value
> In my report body, hidden textbox88 contains my data:
> =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> This all works great, except for the fact that textbox88 only exists on the
> first page, so the header only has a value on the first page.
> Here's the question: How do I make textbox88 Repeat on Every Page, which
> let's me see a value in the header on Every Page?
> Thanks,
> --
> Randy
I created a text box in my report header, which references a text box in my
report body: =ReportItems!textbox88.Value
In my report body, hidden textbox88 contains my data:
=Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
This all works great, except for the fact that textbox88 only exists on the
first page, so the header only has a value on the first page.
Here's the question: How do I make textbox88 Repeat on Every Page, which
let's me see a value in the header on Every Page?
Thanks,
--
RandyYou could copy that box into your page header instead of your report
headrer.
"randy1200" <randy1200@.newsgroups.nospam> wrote in message
news:6BAB5E73-F556-4778-8B89-766C99075F90@.microsoft.com...
> Using SSRS 2005:
> I created a text box in my report header, which references a text box in
> my
> report body: =ReportItems!textbox88.Value
> In my report body, hidden textbox88 contains my data:
> =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> This all works great, except for the fact that textbox88 only exists on
> the
> first page, so the header only has a value on the first page.
> Here's the question: How do I make textbox88 Repeat on Every Page, which
> let's me see a value in the header on Every Page?
> Thanks,
> --
> Randy|||I'm working with SSRS 2005 using Visual Studio 2005. I don't see what the
difference is between a page header and report header. I created the header
by viewing the report in the Layout tab, right-clicking off to the side of
the page, and selecting "Page Header."
There are many posts in the archives here that describe why you can't put
fields directly into headers. Fields must be put into something in the body
and then the header can reference that something to allow the data in appear
in the header.
I still haven't been able to spot anything that allows a field in the body
to repeat on every page, so that the data in the field appears in the header
on every page.
--
Randy
"Ben Watts" wrote:
> You could copy that box into your page header instead of your report
> headrer.
> "randy1200" <randy1200@.newsgroups.nospam> wrote in message
> news:6BAB5E73-F556-4778-8B89-766C99075F90@.microsoft.com...
> > Using SSRS 2005:
> >
> > I created a text box in my report header, which references a text box in
> > my
> > report body: =ReportItems!textbox88.Value
> >
> > In my report body, hidden textbox88 contains my data:
> > =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> >
> > This all works great, except for the fact that textbox88 only exists on
> > the
> > first page, so the header only has a value on the first page.
> >
> > Here's the question: How do I make textbox88 Repeat on Every Page, which
> > let's me see a value in the header on Every Page?
> >
> > Thanks,
> > --
> > Randy
>
>|||I see that textbox88 takes its value from a report parameter rather than a
dataset, so there is no need for the page header text box to take its value
from textbox88. It can be taken directly from the parameter!The expression
for your page header textbox can be:
=Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
HTH,
magendo_man
"randy1200" wrote:
> Using SSRS 2005:
> I created a text box in my report header, which references a text box in my
> report body: =ReportItems!textbox88.Value
> In my report body, hidden textbox88 contains my data:
> =Format(Parameters!StartDate.Value, "dd MMM yy HH:mm:ss")
> This all works great, except for the fact that textbox88 only exists on the
> first page, so the header only has a value on the first page.
> Here's the question: How do I make textbox88 Repeat on Every Page, which
> let's me see a value in the header on Every Page?
> Thanks,
> --
> Randy
Repeat Header? Anyone can solve it?
Problem 1:
Can anyone let me know how can I set a Fields!value inside the textbox in the header?
I have try to assign a value into the header textbox =ReportItems!textbox1.Value (where textbox1 is inside body of the repeat and hide it)
It works on Page 1 header, however, it shows nothing in Page 2 header.
------
Problem 2:
How can set the table header display on every page? It is not working although I install Reporting Service SP2 and also set the table header RepeatOnNewPage=true...
Can anyone let me know how to solve the problem please?I have the same problem as the first one above - anyone having a solution for this ?
BR
//Peter
|||Found a solution at last ...
http://support.microsoft.com/newsgroups/newsReader.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0cddca0c-47b3-4e6f-8a96-3b698ecbca5a
Can anyone let me know how can I set a Fields!value inside the textbox in the header?
I have try to assign a value into the header textbox =ReportItems!textbox1.Value (where textbox1 is inside body of the repeat and hide it)
It works on Page 1 header, however, it shows nothing in Page 2 header.
------
Problem 2:
How can set the table header display on every page? It is not working although I install Reporting Service SP2 and also set the table header RepeatOnNewPage=true...
Can anyone let me know how to solve the problem please?I have the same problem as the first one above - anyone having a solution for this ?
BR
//Peter
|||Found a solution at last ...
http://support.microsoft.com/newsgroups/newsReader.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=0cddca0c-47b3-4e6f-8a96-3b698ecbca5a
Repeat Group Header on new page
Hi,
To explain my question, I need to explain the report a bit, so, pl bear with me.
I have a table in the body of my report.
The table has one grouping.
The group header has been set to repeat on new page and this works fine.
Here is my problem..
The group footer has another table embedded in it. (call it the FooterTable)
When the FooterTable runs to the next page, the GroupHeader of the MainTable doesn't repeat itself. I am assuming it should as the FooterTable is still in the GroupFooter of the main table.
But I cannot get the GroupHeader to repeat on a new page.
(FYI : The reason I had to embed a second table was because I have a set of 3,4 lines in the Group Footer which must stay together in one page. I put these lines in the second table and use the KeepTogether property on the table. I didnt know of any other way to do this. )
Thanks.
SriWithAQuestion.
The structure of a table is:
header
subgroups / details
footer
The RepeatOnNewPage property is available for headers & footers and we will attempt to render them on every page of the subgroups and details.
We have few other rules implemented for tables:
- every row of the table has an implicit keep together
- widow and orphan rules
In your case:
- if the FooterTable is smaller than page height than it will be on its own page (because of its implicit keep together)
- if there is enough room left on the page, a detail of the main table (assuming there is more than one) should be rendered together with the footer - widow/orphan rules
- if a detail is present and there is still room on the page, then the main table header will be renderer due to its keep together
Hope this helps to clarify the behavior,
Nicoleta|||
sriwithaquestion wrote:
...
(FYI : The reason I had to embed a second table was because I have a set of 3,4 lines in the Group Footer which must stay together in one page. I put these lines in the second table and use the KeepTogether property on the table. I didnt know of any other way to do this.)
A rectangle around the lines solve the "keep together" problem, doesn't it? But it won't make them show up on every page. No table footer will do that since they are just footers and should appear last. I think I have managed to get a matrix to show a footer on each page (probably because I didn't want it to since the table continued on the next page!).
Repeat Group Header on new page
Hi,
To explain my question, I need to explain the report a bit, so, pl bear with me.
I have a table in the body of my report.
The table has one grouping.
The group header has been set to repeat on new page and this works fine.
Here is my problem..
The group footer has another table embedded in it. (call it the FooterTable)
When the FooterTable runs to the next page, the GroupHeader of the MainTable doesn't repeat itself. I am assuming it should as the FooterTable is still in the GroupFooter of the main table.
But I cannot get the GroupHeader to repeat on a new page.
(FYI : The reason I had to embed a second table was because I have a set of 3,4 lines in the Group Footer which must stay together in one page. I put these lines in the second table and use the KeepTogether property on the table. I didnt know of any other way to do this. )
Thanks.
SriWithAQuestion.
The structure of a table is:
header
subgroups / details
footer
The RepeatOnNewPage property is available for headers & footers and we will attempt to render them on every page of the subgroups and details.
We have few other rules implemented for tables:
- every row of the table has an implicit keep together
- widow and orphan rules
In your case:
- if the FooterTable is smaller than page height than it will be on its own page (because of its implicit keep together)
- if there is enough room left on the page, a detail of the main table (assuming there is more than one) should be rendered together with the footer - widow/orphan rules
- if a detail is present and there is still room on the page, then the main table header will be renderer due to its keep together
Hope this helps to clarify the behavior,
Nicoleta|||
...
(FYI : The reason I had to embed a second table was because I have a set of 3,4 lines in the Group Footer which must stay together in one page. I put these lines in the second table and use the KeepTogether property on the table. I didnt know of any other way to do this.)
A rectangle around the lines solve the "keep together" problem, doesn't it? But it won't make them show up on every page. No table footer will do that since they are just footers and should appear last. I think I have managed to get a matrix to show a footer on each page (probably because I didn't want it to since the table continued on the next page!).
Repeat Group Header on each page
How do I repeat the group header at the top of each page?RepeatOnNewPage Element
Indicates whether the header or footer should be displayed with the table on each page if the table spans multiple pages.
[XML]
<Header> <!-- or Footer -->
...
<RepeatOnNewPage>...</RepeatOnNewPage>
</Header> <!-- or /Footer -->
Element Characteristics
Characteristic Description
Data type and length Boolean
Default value False
also avaible on table properties
"Greg Anderson" wrote:
> How do I repeat the group header at the top of each page?|||Yes I found out about the table header, but what I want repeated is the Group Header, not the Table Header.
"John" wrote:
> RepeatOnNewPage Element
> Indicates whether the header or footer should be displayed with the table on each page if the table spans multiple pages.
> [XML]
> <Header> <!-- or Footer -->
> ...
> <RepeatOnNewPage>...</RepeatOnNewPage>
> </Header> <!-- or /Footer -->
> Element Characteristics
> Characteristic Description
> Data type and length Boolean
> Default value False
> also avaible on table properties
> "Greg Anderson" wrote:
> > How do I repeat the group header at the top of each page?|||On the Grouping and Sorting dialog there are Repeat Group Header and Footer
checkboxes. Setting these will accomplish what you need.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Anderson" <GregAnderson@.discussions.microsoft.com> wrote in message
news:11AC8168-162C-4B51-96C4-D2BCA1B1B996@.microsoft.com...
> Yes I found out about the table header, but what I want repeated is the
Group Header, not the Table Header.
>
> "John" wrote:
> > RepeatOnNewPage Element
> > Indicates whether the header or footer should be displayed with the
table on each page if the table spans multiple pages.
> >
> > [XML]
> > <Header> <!-- or Footer -->
> > ...
> > <RepeatOnNewPage>...</RepeatOnNewPage>
> > </Header> <!-- or /Footer -->
> >
> > Element Characteristics
> >
> > Characteristic Description
> > Data type and length Boolean
> > Default value False
> >
> > also avaible on table properties
> >
> > "Greg Anderson" wrote:
> >
> > > How do I repeat the group header at the top of each page?
Indicates whether the header or footer should be displayed with the table on each page if the table spans multiple pages.
[XML]
<Header> <!-- or Footer -->
...
<RepeatOnNewPage>...</RepeatOnNewPage>
</Header> <!-- or /Footer -->
Element Characteristics
Characteristic Description
Data type and length Boolean
Default value False
also avaible on table properties
"Greg Anderson" wrote:
> How do I repeat the group header at the top of each page?|||Yes I found out about the table header, but what I want repeated is the Group Header, not the Table Header.
"John" wrote:
> RepeatOnNewPage Element
> Indicates whether the header or footer should be displayed with the table on each page if the table spans multiple pages.
> [XML]
> <Header> <!-- or Footer -->
> ...
> <RepeatOnNewPage>...</RepeatOnNewPage>
> </Header> <!-- or /Footer -->
> Element Characteristics
> Characteristic Description
> Data type and length Boolean
> Default value False
> also avaible on table properties
> "Greg Anderson" wrote:
> > How do I repeat the group header at the top of each page?|||On the Grouping and Sorting dialog there are Repeat Group Header and Footer
checkboxes. Setting these will accomplish what you need.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Anderson" <GregAnderson@.discussions.microsoft.com> wrote in message
news:11AC8168-162C-4B51-96C4-D2BCA1B1B996@.microsoft.com...
> Yes I found out about the table header, but what I want repeated is the
Group Header, not the Table Header.
>
> "John" wrote:
> > RepeatOnNewPage Element
> > Indicates whether the header or footer should be displayed with the
table on each page if the table spans multiple pages.
> >
> > [XML]
> > <Header> <!-- or Footer -->
> > ...
> > <RepeatOnNewPage>...</RepeatOnNewPage>
> > </Header> <!-- or /Footer -->
> >
> > Element Characteristics
> >
> > Characteristic Description
> > Data type and length Boolean
> > Default value False
> >
> > also avaible on table properties
> >
> > "Greg Anderson" wrote:
> >
> > > How do I repeat the group header at the top of each page?
repeat group header at top of new page
I have a report of addresses, grouped by Street Name.
Output type is PDF.
When the report breaks onto a new page, I would like the Group Header - the Street Name last listed on the previous page - to repeat at the top.
Currently it seems to only repeat when the Street Name changes.
Is that possible? If so, how?The grouping and sorting properties dialog has an option to repeat the group
header. Setting this option should do the trick for you. Assuming you are
using a table you can reach this feature by opening the table properties
dialog. Next you would click on the Groups tab. Finally you will need to
edit the Streets Name group.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Anderson" <GregAnderson@.discussions.microsoft.com> wrote in message
news:EA1A1F82-AA0D-4445-AC4E-C88C9EDB0444@.microsoft.com...
> I have a report of addresses, grouped by Street Name.
> Output type is PDF.
> When the report breaks onto a new page, I would like the Group Header -
the Street Name last listed on the previous page - to repeat at the top.
> Currently it seems to only repeat when the Street Name changes.
> Is that possible? If so, how?|||Let me also say that I have gone into the Table Properties and set the "Repeat header rows on each page"
This works when I send it a parameter to sort one way - by street name - but not when I send the sort parameter of "sequence" which is another column in my report.
Any ideas?
"Greg Anderson" wrote:
> I have a report of addresses, grouped by Street Name.
> Output type is PDF.
> When the report breaks onto a new page, I would like the Group Header - the Street Name last listed on the previous page - to repeat at the top.
> Currently it seems to only repeat when the Street Name changes.
> Is that possible? If so, how?
Output type is PDF.
When the report breaks onto a new page, I would like the Group Header - the Street Name last listed on the previous page - to repeat at the top.
Currently it seems to only repeat when the Street Name changes.
Is that possible? If so, how?The grouping and sorting properties dialog has an option to repeat the group
header. Setting this option should do the trick for you. Assuming you are
using a table you can reach this feature by opening the table properties
dialog. Next you would click on the Groups tab. Finally you will need to
edit the Streets Name group.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Anderson" <GregAnderson@.discussions.microsoft.com> wrote in message
news:EA1A1F82-AA0D-4445-AC4E-C88C9EDB0444@.microsoft.com...
> I have a report of addresses, grouped by Street Name.
> Output type is PDF.
> When the report breaks onto a new page, I would like the Group Header -
the Street Name last listed on the previous page - to repeat at the top.
> Currently it seems to only repeat when the Street Name changes.
> Is that possible? If so, how?|||Let me also say that I have gone into the Table Properties and set the "Repeat header rows on each page"
This works when I send it a parameter to sort one way - by street name - but not when I send the sort parameter of "sequence" which is another column in my report.
Any ideas?
"Greg Anderson" wrote:
> I have a report of addresses, grouped by Street Name.
> Output type is PDF.
> When the report breaks onto a new page, I would like the Group Header - the Street Name last listed on the previous page - to repeat at the top.
> Currently it seems to only repeat when the Street Name changes.
> Is that possible? If so, how?
Repeat grid header on each page
Hi,
If a grid header has the RepeatOnNewPage property set to True, how can I figure out when the header is continuing on next pages, so I can add the text '... continue' on every page except the first one?
Thank you.
Radu.
You can try using the RowNumber() function to determine if it's the first record (first page) or not.|||Thank you for your answer...
... but it doesn't work. My report displays more tables, not only one, and each table displays rows grouped by a field XYZ. The RowNumber(Nothing) function gives the current row index in the entire context. It might be helpful to have a variable which is reset to 1 for each table.
I've tried to pass the group name parameter to the RowNumber function (RowNumber("XYZ_group"), where "XYZ_group" is the name of the group by XYZ field), but it gives the total number of records available in one group.
If you have some more ideas, please feel free to suggest them... I'm trying more and I'll post here the answer if I manage to find it.
|||Hi Alexa,
greetings!
a suggestion.. if you please
why dont you write an IIF on pagenumber globals on the visibility condition of the textbox which displays continue
=IIF(Global!PageNo.value = 1,True,False)
hope i am not missing a point in ur question, correct me if i am.
|||You're not allowed to use the PageNumber in the report body... you may use it only in the report header and footer.
I would have liked to be able to use it... because I have another issue: I want to leave a blank page after a sub-report if the sub-report finishes at an odd page. Imagine you're printing something on both sides and a new chapter you want to start at a odd page (it's more readable than starting the new chapter from the even page).
It seems the guys from Microsoft couldn't allow PageNumber to be accessed from the Body (definitely they had a good reason, but what is that reason?).
Subscribe to:
Posts (Atom)