Repeat Data On Each Page (frustrated)

Sorry if this is a repeat question. I've been searching for three hours
trying to find a solution to a simple problem. Thank you in advance.
I have a report with a list control that has 20 textboxes and three sub
reports.
The report usually renders between 1-3 pages, depending on the content.
The report is an invoice report. All I want to do, is repeat the invoice
number at the top of each page. I know the textbox trick, but with a list
control, I can't guarantee that this control will be on each rendered page.
It's on the first page so the invoice number will print at the top. But on
all other pages, that control does not get rendered, which results in the
invoice number not printing on the page.
I have tried nesting list controls but this does not work either, especially
with .pdf rendering.
I understand the how's and why's Reporting Services renders reports.
But this functionality is basic and really a requirement for reports like
invoices where having the invoice number on each page is a requirement.
I also have to be able to print more that one invoice at a time. Currently
my dataset returns all invoice that need printing. My page breaking is
working fine.
I just can't get the invoice number on each rendered page.
Please help and thank you so very much,
KarlHave you tried passing the invoice number through as a parameter, and having
that at the top of the page. May work a little better
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl|||Thank you for your suggestion. This would work if we are only printing one
invoice at a time.
Howerver we are printing between 1 - 50 invoices at a time. The parameter
wouldn't work in this case. The data comes from a Dataset that queries based
on other criteria.
Thank you again for your suggestion.
Karl
"MACNR" wrote:
> Have you tried passing the invoice number through as a parameter, and having
> that at the top of the page. May work a little better
> "Karl 140.6" wrote:
> > Sorry if this is a repeat question. I've been searching for three hours
> > trying to find a solution to a simple problem. Thank you in advance.
> >
> > I have a report with a list control that has 20 textboxes and three sub
> > reports.
> >
> > The report usually renders between 1-3 pages, depending on the content.
> >
> > The report is an invoice report. All I want to do, is repeat the invoice
> > number at the top of each page. I know the textbox trick, but with a list
> > control, I can't guarantee that this control will be on each rendered page.
> > It's on the first page so the invoice number will print at the top. But on
> > all other pages, that control does not get rendered, which results in the
> > invoice number not printing on the page.
> >
> > I have tried nesting list controls but this does not work either, especially
> > with .pdf rendering.
> >
> > I understand the how's and why's Reporting Services renders reports.
> >
> > But this functionality is basic and really a requirement for reports like
> > invoices where having the invoice number on each page is a requirement.
> >
> > I also have to be able to print more that one invoice at a time. Currently
> > my dataset returns all invoice that need printing. My page breaking is
> > working fine.
> >
> > I just can't get the invoice number on each rendered page.
> >
> > Please help and thank you so very much,
> >
> > Karl|||Try putting the invoice within the innermost list, then hide it. You can then
refer to the textbox in the page header using the normal
ReportItems!textbox.Value expression.
"Karl 140.6" wrote:
> Thank you for your suggestion. This would work if we are only printing one
> invoice at a time.
> Howerver we are printing between 1 - 50 invoices at a time. The parameter
> wouldn't work in this case. The data comes from a Dataset that queries based
> on other criteria.
> Thank you again for your suggestion.
> Karl
> "MACNR" wrote:
> > Have you tried passing the invoice number through as a parameter, and having
> > that at the top of the page. May work a little better
> >
> > "Karl 140.6" wrote:
> >
> > > Sorry if this is a repeat question. I've been searching for three hours
> > > trying to find a solution to a simple problem. Thank you in advance.
> > >
> > > I have a report with a list control that has 20 textboxes and three sub
> > > reports.
> > >
> > > The report usually renders between 1-3 pages, depending on the content.
> > >
> > > The report is an invoice report. All I want to do, is repeat the invoice
> > > number at the top of each page. I know the textbox trick, but with a list
> > > control, I can't guarantee that this control will be on each rendered page.
> > > It's on the first page so the invoice number will print at the top. But on
> > > all other pages, that control does not get rendered, which results in the
> > > invoice number not printing on the page.
> > >
> > > I have tried nesting list controls but this does not work either, especially
> > > with .pdf rendering.
> > >
> > > I understand the how's and why's Reporting Services renders reports.
> > >
> > > But this functionality is basic and really a requirement for reports like
> > > invoices where having the invoice number on each page is a requirement.
> > >
> > > I also have to be able to print more that one invoice at a time. Currently
> > > my dataset returns all invoice that need printing. My page breaking is
> > > working fine.
> > >
> > > I just can't get the invoice number on each rendered page.
> > >
> > > Please help and thank you so very much,
> > >
> > > Karl|||Tom,
Great idea with a limitation however.
R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
If it's not on the page, R/S can't "see it"
If it can't "see it" the Invoice Number textbox will end up without a value
assigned to it.
This will happen in the list control extends past one page. This is exactly
the problem I'm having.
Thank you for your suggestion. If I come up with a fix I'll post it here
for sure.
Karl
"Tom" wrote:
> Try putting the invoice within the innermost list, then hide it. You can then
> refer to the textbox in the page header using the normal
> ReportItems!textbox.Value expression.
> "Karl 140.6" wrote:
> > Thank you for your suggestion. This would work if we are only printing one
> > invoice at a time.
> >
> > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > wouldn't work in this case. The data comes from a Dataset that queries based
> > on other criteria.
> >
> > Thank you again for your suggestion.
> >
> > Karl
> >
> > "MACNR" wrote:
> >
> > > Have you tried passing the invoice number through as a parameter, and having
> > > that at the top of the page. May work a little better
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > trying to find a solution to a simple problem. Thank you in advance.
> > > >
> > > > I have a report with a list control that has 20 textboxes and three sub
> > > > reports.
> > > >
> > > > The report usually renders between 1-3 pages, depending on the content.
> > > >
> > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > number at the top of each page. I know the textbox trick, but with a list
> > > > control, I can't guarantee that this control will be on each rendered page.
> > > > It's on the first page so the invoice number will print at the top. But on
> > > > all other pages, that control does not get rendered, which results in the
> > > > invoice number not printing on the page.
> > > >
> > > > I have tried nesting list controls but this does not work either, especially
> > > > with .pdf rendering.
> > > >
> > > > I understand the how's and why's Reporting Services renders reports.
> > > >
> > > > But this functionality is basic and really a requirement for reports like
> > > > invoices where having the invoice number on each page is a requirement.
> > > >
> > > > I also have to be able to print more that one invoice at a time. Currently
> > > > my dataset returns all invoice that need printing. My page breaking is
> > > > working fine.
> > > >
> > > > I just can't get the invoice number on each rendered page.
> > > >
> > > > Please help and thank you so very much,
> > > >
> > > > Karl|||Karl,
Have you tried using a simple one column table to emulate the list. You'll
need to put a rectangle in each cell before you then add fields. You can
then use the Repeat On New Page flag for the table's group header.
"Karl 140.6" wrote:
> Tom,
> Great idea with a limitation however.
> R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> If it's not on the page, R/S can't "see it"
> If it can't "see it" the Invoice Number textbox will end up without a value
> assigned to it.
> This will happen in the list control extends past one page. This is exactly
> the problem I'm having.
> Thank you for your suggestion. If I come up with a fix I'll post it here
> for sure.
> Karl
> "Tom" wrote:
> > Try putting the invoice within the innermost list, then hide it. You can then
> > refer to the textbox in the page header using the normal
> > ReportItems!textbox.Value expression.
> >
> > "Karl 140.6" wrote:
> >
> > > Thank you for your suggestion. This would work if we are only printing one
> > > invoice at a time.
> > >
> > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > on other criteria.
> > >
> > > Thank you again for your suggestion.
> > >
> > > Karl
> > >
> > > "MACNR" wrote:
> > >
> > > > Have you tried passing the invoice number through as a parameter, and having
> > > > that at the top of the page. May work a little better
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > >
> > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > reports.
> > > > >
> > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > >
> > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > all other pages, that control does not get rendered, which results in the
> > > > > invoice number not printing on the page.
> > > > >
> > > > > I have tried nesting list controls but this does not work either, especially
> > > > > with .pdf rendering.
> > > > >
> > > > > I understand the how's and why's Reporting Services renders reports.
> > > > >
> > > > > But this functionality is basic and really a requirement for reports like
> > > > > invoices where having the invoice number on each page is a requirement.
> > > > >
> > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > working fine.
> > > > >
> > > > > I just can't get the invoice number on each rendered page.
> > > > >
> > > > > Please help and thank you so very much,
> > > > >
> > > > > Karl|||I was trying to avoid that but I think you right.
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||ok ... now you lost me. His original set up was a list box with 20 text
boxes and a number of subreports. So the one column table will do what? and
why would he need to enter rectangles before adding fields? I am quite
interested in this ... also ... as you can see ... the "repeat item with
data area on each page" when checked doesnt seem to be working ... and that
has been my experience as well. I have a list box which contains a text box
and 2 tables (which the text box represents the heading for both tables since
they would be the same heading repeated) I have it set up to repeat the text
box with the table on each page ... and when the table spans more than one
page ... the text box doesnt show up (it isnt set to hidden or anything like
that either). The only way I was able to resolve this was to use a table
header ... which WILL repeat on each page ... however the second table would
need the same header and I dont want it repeated (looks redundant). However
there are cases where the second table renders by itself on a new page and
then there is no heading to describe what the table represents - all you see
are the group headings describing the fields them selves (the heading tells
what resource the fields relate to )
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||This sounded like such a good idea as I am trying something similar to Karl.
I thought of the one column table, but it would not let me put tables in the
detail rows. I tried putting the tables into the table footer rows and
repeating the table header, but the header would not repeat on each page.
So, upon reading your post, I put rectangles in the detail rows and then put
the tables inside the rectangles. It looked like it was going to work. But
when I tried to run my report, I got an error saying "The table â'table10â' is
contained inside a table detail row. Data regions are not allowed inside a
table detail row." for each table I tried to put inside the main table. Is
there a way around this? It's ridiculous that's there's no easy way to
repeat an item that contains a field on each page. Thanks.
-Sherri
"Tom" wrote:
> Karl,
> Have you tried using a simple one column table to emulate the list. You'll
> need to put a rectangle in each cell before you then add fields. You can
> then use the Repeat On New Page flag for the table's group header.
> "Karl 140.6" wrote:
> > Tom,
> >
> > Great idea with a limitation however.
> >
> > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > If it's not on the page, R/S can't "see it"
> >
> > If it can't "see it" the Invoice Number textbox will end up without a value
> > assigned to it.
> >
> > This will happen in the list control extends past one page. This is exactly
> > the problem I'm having.
> >
> > Thank you for your suggestion. If I come up with a fix I'll post it here
> > for sure.
> >
> > Karl
> >
> > "Tom" wrote:
> >
> > > Try putting the invoice within the innermost list, then hide it. You can then
> > > refer to the textbox in the page header using the normal
> > > ReportItems!textbox.Value expression.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Thank you for your suggestion. This would work if we are only printing one
> > > > invoice at a time.
> > > >
> > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > on other criteria.
> > > >
> > > > Thank you again for your suggestion.
> > > >
> > > > Karl
> > > >
> > > > "MACNR" wrote:
> > > >
> > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > that at the top of the page. May work a little better
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > >
> > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > reports.
> > > > > >
> > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > >
> > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > invoice number not printing on the page.
> > > > > >
> > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > with .pdf rendering.
> > > > > >
> > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > >
> > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > >
> > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > working fine.
> > > > > >
> > > > > > I just can't get the invoice number on each rendered page.
> > > > > >
> > > > > > Please help and thank you so very much,
> > > > > >
> > > > > > Karl|||Sherri,
Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
with code that I received from Microsoft. There is a workaround that's not
"TO" bad.
Cheers,
Karl
"Sherri French" wrote:
> This sounded like such a good idea as I am trying something similar to Karl.
> I thought of the one column table, but it would not let me put tables in the
> detail rows. I tried putting the tables into the table footer rows and
> repeating the table header, but the header would not repeat on each page.
> So, upon reading your post, I put rectangles in the detail rows and then put
> the tables inside the rectangles. It looked like it was going to work. But
> when I tried to run my report, I got an error saying "The table â'table10â' is
> contained inside a table detail row. Data regions are not allowed inside a
> table detail row." for each table I tried to put inside the main table. Is
> there a way around this? It's ridiculous that's there's no easy way to
> repeat an item that contains a field on each page. Thanks.
> -Sherri
> "Tom" wrote:
> > Karl,
> >
> > Have you tried using a simple one column table to emulate the list. You'll
> > need to put a rectangle in each cell before you then add fields. You can
> > then use the Repeat On New Page flag for the table's group header.
> >
> > "Karl 140.6" wrote:
> >
> > > Tom,
> > >
> > > Great idea with a limitation however.
> > >
> > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > If it's not on the page, R/S can't "see it"
> > >
> > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > assigned to it.
> > >
> > > This will happen in the list control extends past one page. This is exactly
> > > the problem I'm having.
> > >
> > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > for sure.
> > >
> > > Karl
> > >
> > > "Tom" wrote:
> > >
> > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > refer to the textbox in the page header using the normal
> > > > ReportItems!textbox.Value expression.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > invoice at a time.
> > > > >
> > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > on other criteria.
> > > > >
> > > > > Thank you again for your suggestion.
> > > > >
> > > > > Karl
> > > > >
> > > > > "MACNR" wrote:
> > > > >
> > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > that at the top of the page. May work a little better
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > >
> > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > reports.
> > > > > > >
> > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > >
> > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > invoice number not printing on the page.
> > > > > > >
> > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > with .pdf rendering.
> > > > > > >
> > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > >
> > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > >
> > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > working fine.
> > > > > > >
> > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > >
> > > > > > > Please help and thank you so very much,
> > > > > > >
> > > > > > > Karl|||Hi Karl,
I am having the same problem. In the body section of my RDL I have 10
text boxes that are feeding information to the report header and
footer. I have also created a table in the same body section right
below the text boxes. But these text boxes are not displayed from the
second page onwards in the report. Seems like the table gets a
preference in being rendered than my text boxes. For days now, I have
been trying to repeat items on all report pages and i just cant.
Could you please perhaps tell me the work around for this that u
recommended to Sherri?
Thanks a lot!
Noorie
Karl 140.6 wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table 'table10' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||Please Karl ... I need the workaround too ... and it looks like others do
too. Thanks!
"Karl 140.6" wrote:
> Sherri,
> Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> with code that I received from Microsoft. There is a workaround that's not
> "TO" bad.
> Cheers,
> Karl
> "Sherri French" wrote:
> > This sounded like such a good idea as I am trying something similar to Karl.
> > I thought of the one column table, but it would not let me put tables in the
> > detail rows. I tried putting the tables into the table footer rows and
> > repeating the table header, but the header would not repeat on each page.
> > So, upon reading your post, I put rectangles in the detail rows and then put
> > the tables inside the rectangles. It looked like it was going to work. But
> > when I tried to run my report, I got an error saying "The table â'table10â' is
> > contained inside a table detail row. Data regions are not allowed inside a
> > table detail row." for each table I tried to put inside the main table. Is
> > there a way around this? It's ridiculous that's there's no easy way to
> > repeat an item that contains a field on each page. Thanks.
> >
> > -Sherri
> >
> > "Tom" wrote:
> >
> > > Karl,
> > >
> > > Have you tried using a simple one column table to emulate the list. You'll
> > > need to put a rectangle in each cell before you then add fields. You can
> > > then use the Repeat On New Page flag for the table's group header.
> > >
> > > "Karl 140.6" wrote:
> > >
> > > > Tom,
> > > >
> > > > Great idea with a limitation however.
> > > >
> > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > If it's not on the page, R/S can't "see it"
> > > >
> > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > assigned to it.
> > > >
> > > > This will happen in the list control extends past one page. This is exactly
> > > > the problem I'm having.
> > > >
> > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > for sure.
> > > >
> > > > Karl
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > refer to the textbox in the page header using the normal
> > > > > ReportItems!textbox.Value expression.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > invoice at a time.
> > > > > >
> > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > on other criteria.
> > > > > >
> > > > > > Thank you again for your suggestion.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "MACNR" wrote:
> > > > > >
> > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > that at the top of the page. May work a little better
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > >
> > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > reports.
> > > > > > > >
> > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > >
> > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > invoice number not printing on the page.
> > > > > > > >
> > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > with .pdf rendering.
> > > > > > > >
> > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > >
> > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > >
> > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > working fine.
> > > > > > > >
> > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > >
> > > > > > > > Please help and thank you so very much,
> > > > > > > >
> > > > > > > > Karl|||MJT,
Please send me your email and I'll forward the information to you.
Send your email to : ks923z@.yahoo.com
Karl
"MJT" wrote:
> Please Karl ... I need the workaround too ... and it looks like others do
> too. Thanks!
> "Karl 140.6" wrote:
> > Sherri,
> >
> > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > with code that I received from Microsoft. There is a workaround that's not
> > "TO" bad.
> >
> > Cheers,
> >
> > Karl
> >
> > "Sherri French" wrote:
> >
> > > This sounded like such a good idea as I am trying something similar to Karl.
> > > I thought of the one column table, but it would not let me put tables in the
> > > detail rows. I tried putting the tables into the table footer rows and
> > > repeating the table header, but the header would not repeat on each page.
> > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > the tables inside the rectangles. It looked like it was going to work. But
> > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > contained inside a table detail row. Data regions are not allowed inside a
> > > table detail row." for each table I tried to put inside the main table. Is
> > > there a way around this? It's ridiculous that's there's no easy way to
> > > repeat an item that contains a field on each page. Thanks.
> > >
> > > -Sherri
> > >
> > > "Tom" wrote:
> > >
> > > > Karl,
> > > >
> > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > need to put a rectangle in each cell before you then add fields. You can
> > > > then use the Repeat On New Page flag for the table's group header.
> > > >
> > > > "Karl 140.6" wrote:
> > > >
> > > > > Tom,
> > > > >
> > > > > Great idea with a limitation however.
> > > > >
> > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > If it's not on the page, R/S can't "see it"
> > > > >
> > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > assigned to it.
> > > > >
> > > > > This will happen in the list control extends past one page. This is exactly
> > > > > the problem I'm having.
> > > > >
> > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > for sure.
> > > > >
> > > > > Karl
> > > > >
> > > > > "Tom" wrote:
> > > > >
> > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > refer to the textbox in the page header using the normal
> > > > > > ReportItems!textbox.Value expression.
> > > > > >
> > > > > > "Karl 140.6" wrote:
> > > > > >
> > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > invoice at a time.
> > > > > > >
> > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > on other criteria.
> > > > > > >
> > > > > > > Thank you again for your suggestion.
> > > > > > >
> > > > > > > Karl
> > > > > > >
> > > > > > > "MACNR" wrote:
> > > > > > >
> > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > that at the top of the page. May work a little better
> > > > > > > >
> > > > > > > > "Karl 140.6" wrote:
> > > > > > > >
> > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > >
> > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > reports.
> > > > > > > > >
> > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > >
> > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > invoice number not printing on the page.
> > > > > > > > >
> > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > with .pdf rendering.
> > > > > > > > >
> > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > >
> > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > >
> > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > working fine.
> > > > > > > > >
> > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > >
> > > > > > > > > Please help and thank you so very much,
> > > > > > > > >
> > > > > > > > > Karl|||Thanks Karl ... I did send it
"Karl 140.6" wrote:
> MJT,
> Please send me your email and I'll forward the information to you.
> Send your email to : ks923z@.yahoo.com
> Karl
> "MJT" wrote:
> > Please Karl ... I need the workaround too ... and it looks like others do
> > too. Thanks!
> >
> > "Karl 140.6" wrote:
> >
> > > Sherri,
> > >
> > > Send me your email address to : ks923z@.yahoo.com and I'll email you 2 emails
> > > with code that I received from Microsoft. There is a workaround that's not
> > > "TO" bad.
> > >
> > > Cheers,
> > >
> > > Karl
> > >
> > > "Sherri French" wrote:
> > >
> > > > This sounded like such a good idea as I am trying something similar to Karl.
> > > > I thought of the one column table, but it would not let me put tables in the
> > > > detail rows. I tried putting the tables into the table footer rows and
> > > > repeating the table header, but the header would not repeat on each page.
> > > > So, upon reading your post, I put rectangles in the detail rows and then put
> > > > the tables inside the rectangles. It looked like it was going to work. But
> > > > when I tried to run my report, I got an error saying "The table â'table10â' is
> > > > contained inside a table detail row. Data regions are not allowed inside a
> > > > table detail row." for each table I tried to put inside the main table. Is
> > > > there a way around this? It's ridiculous that's there's no easy way to
> > > > repeat an item that contains a field on each page. Thanks.
> > > >
> > > > -Sherri
> > > >
> > > > "Tom" wrote:
> > > >
> > > > > Karl,
> > > > >
> > > > > Have you tried using a simple one column table to emulate the list. You'll
> > > > > need to put a rectangle in each cell before you then add fields. You can
> > > > > then use the Repeat On New Page flag for the table's group header.
> > > > >
> > > > > "Karl 140.6" wrote:
> > > > >
> > > > > > Tom,
> > > > > >
> > > > > > Great idea with a limitation however.
> > > > > >
> > > > > > R/S can "see" the hidden textbox "if" that textbox is rendered on the page.
> > > > > > If it's not on the page, R/S can't "see it"
> > > > > >
> > > > > > If it can't "see it" the Invoice Number textbox will end up without a value
> > > > > > assigned to it.
> > > > > >
> > > > > > This will happen in the list control extends past one page. This is exactly
> > > > > > the problem I'm having.
> > > > > >
> > > > > > Thank you for your suggestion. If I come up with a fix I'll post it here
> > > > > > for sure.
> > > > > >
> > > > > > Karl
> > > > > >
> > > > > > "Tom" wrote:
> > > > > >
> > > > > > > Try putting the invoice within the innermost list, then hide it. You can then
> > > > > > > refer to the textbox in the page header using the normal
> > > > > > > ReportItems!textbox.Value expression.
> > > > > > >
> > > > > > > "Karl 140.6" wrote:
> > > > > > >
> > > > > > > > Thank you for your suggestion. This would work if we are only printing one
> > > > > > > > invoice at a time.
> > > > > > > >
> > > > > > > > Howerver we are printing between 1 - 50 invoices at a time. The parameter
> > > > > > > > wouldn't work in this case. The data comes from a Dataset that queries based
> > > > > > > > on other criteria.
> > > > > > > >
> > > > > > > > Thank you again for your suggestion.
> > > > > > > >
> > > > > > > > Karl
> > > > > > > >
> > > > > > > > "MACNR" wrote:
> > > > > > > >
> > > > > > > > > Have you tried passing the invoice number through as a parameter, and having
> > > > > > > > > that at the top of the page. May work a little better
> > > > > > > > >
> > > > > > > > > "Karl 140.6" wrote:
> > > > > > > > >
> > > > > > > > > > Sorry if this is a repeat question. I've been searching for three hours
> > > > > > > > > > trying to find a solution to a simple problem. Thank you in advance.
> > > > > > > > > >
> > > > > > > > > > I have a report with a list control that has 20 textboxes and three sub
> > > > > > > > > > reports.
> > > > > > > > > >
> > > > > > > > > > The report usually renders between 1-3 pages, depending on the content.
> > > > > > > > > >
> > > > > > > > > > The report is an invoice report. All I want to do, is repeat the invoice
> > > > > > > > > > number at the top of each page. I know the textbox trick, but with a list
> > > > > > > > > > control, I can't guarantee that this control will be on each rendered page.
> > > > > > > > > > It's on the first page so the invoice number will print at the top. But on
> > > > > > > > > > all other pages, that control does not get rendered, which results in the
> > > > > > > > > > invoice number not printing on the page.
> > > > > > > > > >
> > > > > > > > > > I have tried nesting list controls but this does not work either, especially
> > > > > > > > > > with .pdf rendering.
> > > > > > > > > >
> > > > > > > > > > I understand the how's and why's Reporting Services renders reports.
> > > > > > > > > >
> > > > > > > > > > But this functionality is basic and really a requirement for reports like
> > > > > > > > > > invoices where having the invoice number on each page is a requirement.
> > > > > > > > > >
> > > > > > > > > > I also have to be able to print more that one invoice at a time. Currently
> > > > > > > > > > my dataset returns all invoice that need printing. My page breaking is
> > > > > > > > > > working fine.
> > > > > > > > > >
> > > > > > > > > > I just can't get the invoice number on each rendered page.
> > > > > > > > > >
> > > > > > > > > > Please help and thank you so very much,
> > > > > > > > > >
> > > > > > > > > > Karl|||Everyone,
Below is email I received from Microsoft with the solution. I hope this
work around helps everyone.
As I discussed with Karl, the issue want assistance with is generating a
report with Invoice Number (or some other group information) appearing in the
Page Header. I am attaching a project with a single report that accomplishes
this objective. I created a custom function and used it to store the data
between pages. The code for that function is:
Shared employeeID as Object
Public Function GetGroupEmployeeID(empID as Object) as Object
If Not (empID is Nothing)
If Not employeeID = empID
employeeID = empID
End If
End If
return employeeID
End Function
The text box at the top of the form gets the value:
=Code.GetGroupEmployeeID(ReportItems!EmployeeID.Value)
Note that EmployeeID is the name of the text box in the top left of the
outer List. It must be in the list, but you can set its Visibility.Hidden
property to true. You access the custom code section of a report by right
clicking on the report layout background and choosing properties. Then go to
the code tab and enter your code.
This custom function is just a sample of what you want to do. It is not the
solution to your problem. It uses a single, shared variable. This means
that multiple individuals rendering reports simultaneously can cause
unpredictable behavior. The real solution would be to create a custom
assembly that uses a Hashtable and access it within your custom function.
Pass the Globals!UserID and the value you want to store
(ReportItems!EmployeeID.Value in this case) and manage them there.
"Karl 140.6" wrote:
> Sorry if this is a repeat question. I've been searching for three hours
> trying to find a solution to a simple problem. Thank you in advance.
> I have a report with a list control that has 20 textboxes and three sub
> reports.
> The report usually renders between 1-3 pages, depending on the content.
> The report is an invoice report. All I want to do, is repeat the invoice
> number at the top of each page. I know the textbox trick, but with a list
> control, I can't guarantee that this control will be on each rendered page.
> It's on the first page so the invoice number will print at the top. But on
> all other pages, that control does not get rendered, which results in the
> invoice number not printing on the page.
> I have tried nesting list controls but this does not work either, especially
> with .pdf rendering.
> I understand the how's and why's Reporting Services renders reports.
> But this functionality is basic and really a requirement for reports like
> invoices where having the invoice number on each page is a requirement.
> I also have to be able to print more that one invoice at a time. Currently
> my dataset returns all invoice that need printing. My page breaking is
> working fine.
> I just can't get the invoice number on each rendered page.
> Please help and thank you so very much,
> Karl